Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Advanced Functions
- Logical functions
- Mathematical and statistical functions
- Financial functions
Lookups and Data Tables
- Application of lookup functions
- Utilising MATCH and INDEX
- Advanced list management
- Cell entry validation
- Database function exploration
PivotTables and PivotCharts
- Pivot Table creation
- Calculated Items and Calculated Fields
External Data Integration
- Data export and import
- Handling XML data exports and imports
- Querying external databases
- Database linking
- Connecting to XML data sources
- Web query analysis for online data
Analytical Tools
- Goal Seek
- Solver
- Analysis ToolPak
- Scenarios
- Macros and custom functions
- Executing and recording macros
- VBA code development
- Function creation
Conditional Formatting and SmartArt
- Conditional formatting using graphics
- SmartArt graphic implementation
Requirements
Familiarity with Excel, mathematics, and fundamental finance concepts is recommended.
Target Audience
Professionals in finance or market analysis, managers, and accountants
Learning Outcomes
To enable and automate comprehensive financial analysis using Microsoft Excel
14 Hours
Testimonials (3)
I learned new things so that is a good point
Daria - LKQ Polska Sp. z o. o.
Course - Analysing Financial Data in Excel
many exercises
Julia - LKQ Polska Sp. z o. o.
Course - Analysing Financial Data in Excel
The tips for many of the functions that the trainer presented, which we can easily remember and implement in our future work
