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.
Duration 14 hours
Course Outline
Advanced functions
- Logical functions
- Mathematical and statistical functions
- Financial functions
Lookups and data tables
- Implementing lookup functions
- Applying MATCH and INDEX
- Advanced list administration
- Cell entry validation
- Database function exploration
PivotTables and PivotCharts
- Building Pivot Tables
- Calculated Items and Calculated Fields
Managing External Data
- Data export and import procedures
- XML data export and import
- External database querying
- Establishing database links
- Connecting to XML data sources
- Online data analysis (Web Queries)
Analytical tools
- Goal Seek
- Solver
- Analysis ToolPack
- Scenario management
- Macros and custom functions
- Macro execution and recording
- VBA code manipulation
- Function development
Conditional formatting and SmartArt
- Graphical conditional formatting
- SmartArt graphics
Requirements
A solid grasp of Excel, mathematics, and fundamental finance concepts is advantageous.
Target Audience
Financial or market analysts, managers, and accountants
Learning Objectives
To enable and automate comprehensive financial analysis using Microsoft Excel
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
