Fourteen day-modules. Seventy-seven unit positions. One core curriculum. Each unit is a focused 1 hour facilitated session built around a real business problem, the technique, and a hands-on exercise grounded in a companion dataset.
Conventional Excel training is tools-first. A function is introduced, its syntax explained, a contrived exercise completed, the next function begins. After 40 hours, the participant has seen many capabilities but has no framework for deciding when to use them.
Every unit opens with a Prestige AV business problem that a working analyst would recognise. The participant understands what they are trying to achieve before they see the syntax. The function arrives with a reason to exist.
Modules 4, 5, 7, and 8 are split into A and B halves. M4B and M7B are delivered as half-days. The remaining twelve run as full days. Default primary dataset is Prestige AV; M5 introduces Greenfield Resource Recovery; M7 and M8 use Financial Insights Pro.
Spill-aware table design, three-layer architecture, protection and auditing, refactoring legacy conditional logic, Boolean logic, conditional aggregation.
XLOOKUP, error handling and the new isolation pattern, FILTER, dynamic SORT and UNIQUE, SEQUENCE for pattern generation.
Stack, extract, reshape, select, flatten, and resize arrays with VSTACK, HSTACK, TAKE, DROP, WRAPCOLS, WRAPROWS, CHOOSECOLS, CHOOSEROWS, TOCOL, TOROW, EXPAND, TRIMRANGE.
LET and LAMBDA, advanced LAMBDA, MAP, REDUCE, SCAN, BYROW and BYCOL. The Advanced Formula Environment and named-function libraries.
Formula-driven aggregations and multi-dimensional pivots without traditional PivotTables. The half-day closes with a 3-hour integrative capstone exercise that combines M4A and M4B techniques.
The visual transformation surface. Connect, clean, reshape with unpivot, merge, append, advanced transformations, parameters and dynamic sources.
Under the hood: the M language, advanced text functions, REGEX, external connections, and production ETL architecture. The day closes with a 1-hour facilitator-led recap consolidating M5A and M5B.
Time-value of money, loan and lease mechanics, depreciation, investment analysis, business statistics, and the Analysis ToolPak.
Database functions, sensitivity analysis with Goal Seek, strategic scenario modelling, payroll and superannuation cost modelling, Solver for optimisation. The day closes with a 1-hour facilitator-led wrap-up consolidating M6A and M6B.
PowerPivot basics, the Data Model and relationships, foundational DAX measures with display-folder organisation, and GETPIVOTDATA for custom report layouts. Strongest preparation in the programme for Power BI.
Filter context, time intelligence configured for the Australian 30/06 fiscal year-end, DAX text functions, and REGEX in DAX. The half-day closes with a 3-hour integrative capstone exercise. A 1-hour M7 Wrap-Up consolidates M7A and M7B.
Visual reporting fundamentals, enhanced conditional formatting, professional dashboard design, the FIP architecture, advanced charts, and data tables for scenario analysis.
Shape-based navigation, interactive Form Controls, dynamic column selection, PIVOTBY visualisation, IMAGE function, and the Module 8 Wrap-Up consolidation walk-through.
The 2026 question every L and D leader is asking: how AI changes the analyst toolkit. AI prompting for Excel, AI for Power Query and M code, AI for DAX and PowerPivot, AI for dashboard design, AI production workflow and risk assessment, and an integrative AI capstone.
Every dataset, every exercise, every reconciliation point uses Australian conventions throughout. Participants see the same formatting, the same fiscal year, the same superannuation rate they use at their desk.
All financial figures in Australian dollars.
Australian date format throughout every workbook.
1 July through 30 June reporting period.
Current superannuation guarantee charge built into payroll exercises.
Eight role-based learning paths curate a subset of the curriculum for a specific role. Four programme bundles pair complementary paths for whole-of-team coverage. Or take the full programme at the deepest discount.