Advanced Excel
From raw files to a refreshable report.
A practical workshop on tables, transformations and readable models. Start with the data and work towards an answer you can check.
Who it is for
For students and professionals familiar with basic formulas and cell references.
The programme
- Tables, keys and XLOOKUP.
- Cleaning, append and merge with Power Query.
- PivotTables, dynamic arrays and dashboards.
- Scenarios and checks for decision models.
What you build
A refreshable report with identifiable sources, calculations and checks.
The format is a short live workshop with case-based practice and direct support. The duration and materials for each edition will be stated before enrolment.
Future editions
Programme preview. Dates and enrolment will be published once confirmed.
For your team
Recurring reports, data imports and dashboards built around the team’s processes.
Try an exercise
A free data challenge and a checklist for reviewing an Excel workbook.