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
Sophisticated Functions
- Logical functions
- Mathematical and statistical functions
- Financial functions
Retrieval Processes and Data Tables
- Application of lookup functions
- Utilization of MATCH and INDEX
- Advanced list administration
- Validation of cell inputs
- Investigation of database functions
PivotTables and PivotCharts
- Construction of Pivot Tables
- Calculated Items and Calculated Fields
Handling External Information
- Data export and import procedures
- Exporting and importing XML information
- Inquiries to external databases
- Establishing database connections
- Linking to XML information sources
- Analysis of online data (Web Inquiries)
Analytical Features
- Goal Seek
- Solver
- The Analysis ToolPak
- Scenario Analysis
- Macros and bespoke functions
- Execution and capture of macros
- Engagement with VBA code
- Development of functions
Conditional Formatting and SmartArt
- Conditional formatting utilizing graphics
- SmartArt graphics
Requirements
Proficiency in Excel, mathematics, and fundamental financial concepts is recommended.
Target Audience
Financial or market analysts, managers, and accountants
Course Objectives
To enable and streamline the execution of diverse financial analyses utilizing 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