Advanced
Excel.

— Formulas 01 / 05

01day

Advanced formula techniques

• VLOOKUP, INDEX / MATCH, INDIRECT
• Dynamic array formulas
• Named ranges & error handling
• Complex nested functions

— Analysis 02 / 05

02day

Expert pivot tables

• Calculated fields, slicers, timelines
• Connecting to external sources
• Synchronised multi-pivot reports
• Power Query to transform data

— Visuals 03 / 05

03day

Professional visualisation

• Combo charts & sparklines
• Advanced conditional formatting
• Dashboard design
• Maps & hierarchy charts

— Automation 04 / 05

04day

Macros & VBA

• Recording and editing macros
• Writing VBA scripts
• Forms & interactive buttons
• Automating recurring tasks

— Production 05 / 05

05day

A complete dashboard

• Combining pivot tables + charts + VBA
• Presentation to the trainer
• Individual feedback & certification
• A real case on your business data