Analysts and reporting owners who are pushing Excel past its comfortable limits.
Excel — Advanced
Turn Excel into a reporting engine. Power Query for repeatable cleanup, the data model for real relationships, and dynamic arrays that replace whole sheets of helper columns.
What we cover
- Power Query: import, reshape and refresh
- Unpivoting and appending multiple sources
- The Excel data model and relationships
- DAX basics inside Excel
- Dynamic arrays: FILTER, SORT, UNIQUE, LET
- Building a dashboard sheet that refreshes in one click
- When to stop and move the work to Power BI
Who it is for
What you need first
Confident with pivot tables and lookup functions.
Would this suit your whole team?
We run Excel — Advanced privately, at your offices or online, built around your own files.