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
- Applying lookup functions
- Utilizing MATCH and INDEX
- Advanced list management
- Cell entry validation
- Exploring database functions
PivotTables and PivotCharts
- Building Pivot Tables
- Using Calculated Items and Calculated Fields
Handling External Data
- Importing and exporting data
- Importing and exporting XML data
- Querying external databases
- Establishing database links
- Connecting to XML data sources
- Analyzing online data via Web Queries
Analytical tools
- Goal Seek
- Solver
- The Analysis ToolPak
- Scenario planning
- Macros and custom functions
- Recording and executing macros
- Manipulating VBA code
- Building custom functions
Conditional formatting and SmartArt
- Conditional formatting with graphical elements
- SmartArt graphics
Requirements
A solid foundation in Excel, mathematics, and basic financial principles is advantageous.
Target Audience
Financial or market analysts, managers, and accountants
Learning Objectives
To enable and automate comprehensive financial analysis workflows 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