Thirteen day-modules. Seventy-five 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, and 8 are split into A and B halves. M4B is delivered as a half-day. The remaining ten run as full days. Default primary dataset is Prestige AV; M5 introduces Greenfield Resource Recovery; M7 and M8 use Financial Insights Pro.
Spill-aware design, three-layer architecture, strategic protection and auditing, refactoring legacy conditional logic, Boolean logic, conditional aggregation.
Modern lookup, FILTER, SORT, UNIQUE, SEQUENCE, dynamic ranges, and the foundations of array thinking.
Array shaping, TOCOL, TOROW, WRAPCOLS, HSTACK, VSTACK, CHOOSEROWS, CHOOSECOLS, and reshape-driven logic.
Custom functions, recursion, MAP, REDUCE, BYROW, BYCOL, SCAN, and named-function libraries.
Formula-driven aggregations, multi-dimensional pivots without PivotTables.
Connect, clean, combine. The visual transformation surface that scales from one file to many.
Under the hood: M code, parameters, query folding, production ETL architecture.
Time-value, depreciation, amortisation, and the core finance primitives.
Goal Seek, Solver, scenario manager, and database functions for planning models.
Data models, relationships, measures, calculated columns, time intelligence, and DAX patterns that scale to Power BI.
Layout, hierarchy, chart selection, conditional formatting, accessibility, and dashboard composition.
Form controls, slicers, parameterised views, and the production-ready interactive workbook.
The 2026 question every L and D leader is asking: how AI changes the analyst toolkit. Prompt engineering for Excel, paired-analyst patterns.
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.