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
- Utilizing lookup functions
- Applying MATCH and INDEX functions
- Advanced list management techniques
- Validating cell entries
- Exploring database functions
PivotTables and PivotCharts
- Creating Pivot Tables
- Using Calculated Items and Calculated Fields
Working with External Data
- Exporting and importing data
- Handling XML data export and import
- Querying external databases
- Establishing links to databases
- Connecting to XML data sources
- Analyzing online data (Web Queries)
Analytical Tools and Options
- Goal Seek
- Solver
- The Analysis ToolPak
- Scenarios
- Macros and custom functions
- Running and recording macros
- Working with VBA code
- Creating custom functions
Conditional Formatting and SmartArt
- Applying conditional formatting with visual elements
- Utilizing SmartArt graphics
Requirements
Proficiency in Excel, along with a solid foundation in mathematics and basic finance, will be advantageous.
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