Course Outline
Advanced functions
- Logical functions
- Math and statistical functions
- Financial functions
Lookups and data tables
- Using lookup functions
- Using MATCH and INDEX
- Advanced list management
- Validating cell entries
- Exploring database functions
PivotTables and PivotCharts
- Creating Pivot Tables
- Calculated Item and Calculated Field
Working with External Data
- Exporting and importing
- Exporting and importing XML data
- Querying external databases
- Linking to a database
- Linking to an XML data source
- Analysing online data (Web Queries)
Analytical options
- Goal Seek
- Solver
- The Analysis ToolPack
- Scenarios
- Macros and custom functions
- Running and recording a macro
- Working with VBA code
- Creating functions
Conditional formatting and SmartArt
- Conditional formatting with graphics
- SmartArt graphics
Requirements
Good Excel, maths and basic finance knowledge may be beneficial.
Delivery Options
Private Group Training
Our identity is rooted in delivering exactly what our clients need.
- Pre-course call with your trainer
- Customisation of the learning experience to achieve your goals -
- Bespoke outlines
- Practical hands-on exercises containing data / scenarios recognisable to the learners
- Training scheduled on a date of your choice
- Delivered online, onsite/classroom or hybrid by experts sharing real world experience
Private Group Prices RRP from €4560 online delivery, based on a group of 2 delegates, €1440 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.
Contact us for an exact quote and to hear our latest promotions
Public Training
Please see our public courses
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