A facilitated 14-module programme that teaches participants to think structurally before they think syntactically. Every unit opens with a business problem a working analyst would recognise, then introduces the technique as the solution.
Most Excel training is tools-first: here is FILTER, here is its syntax, here is a contrived exercise. Participants return to their desks and rebuild the same fragile workbooks they were building before. Excel by Design closes that gap.
Every unit opens with a Prestige AV operational scenario. The participant understands the goal before the syntax. When the function is introduced, it has a reason to exist.
The three-layer architecture is introduced in Unit M1.2 and is never set aside. Every module that follows is taught within that structural frame.
One core curriculum delivered against 36 purpose-built Australian datasets. The participant's industry context is in the data, not in the trainer's apologies for it.
When a model breaks, it almost never breaks because the analyst did not know the right function. It breaks because the workbook was not designed to hold up. — Excel by Design, Design Philosophy
From spill-aware table design through to AI-augmented workflows. Each unit runs a focused 1 hour, including a facilitated exercise grounded in a companion dataset.
| ID | Module | Format | Units |
|---|---|---|---|
| M1 | Model Architecture Foundations | Full day | 6 |
| M2 | Data Transformation with Dynamic Arrays | Full day | 7 |
| M3 | Advanced Array Manipulation | Full day | 6 |
| M4A | LAMBDA Architecture and Higher-Order Functions | Full day | 6 |
| M4B | Dynamic Aggregation with GROUPBY and PIVOTBY | Half day | 3 |
| M5A | Power Query — Transform and Shape | Full day | 6 |
| M5B | Power Query — Code, Connections, Architecture | Full day | 5 |
| M6A | Financial Functions — Core | Full day | 6 |
| M6B | Financial Functions — Planning and Optimisation | Full day | 5 |
| M7 | PowerPivot, DAX and Advanced Analysis | Full day | 8 |
| M8A | Dashboard Design and Charting | Full day | 6 |
| M8B | Interactive Controls and Delivery | Full day | 5 |
| M9 | AI-Augmented Excel Workflows | Full day | 6 |
Most Excel training teaches techniques in isolation. The Modelling Pathway is the only facilitated track that teaches financial modelling as a structured progression: construction at small scale, construction at depth, then inherited-model review and upgrade.
Yarra Valley cellar door · AUD 480k
The Mariana Perth · AUD 295m hotel
Inherited model · the same deal
Audio-visual retail through to forensic carbon-credit accounting. Real Australian conventions throughout: AUD currency, DD/MM/YYYY dates, 1 July to 30 June fiscal year, 12% superannuation guarantee. Free overlay for most engagements.
The default dataset across all standard units. Sydney, Melbourne, Brisbane, Perth audio-visual integrator. FY2016 to FY2026, 110,000+ rows.
Star schema retail dataset at scale. 17 million rows of CSV across 16 Parquet files. The advanced Power BI workout.
The only forensic dataset. Records pack of a fictional carbon brokerage in voluntary administration, with eight discrepancy vectors deliberately encoded.
Deliberately compact at 406 rows. The small-business companion for introductory M1+M2 single-day deliveries.
All prices in Australian dollars, ex GST. The discount is applied automatically based on enrolment level. Volume pricing available for five or more participants.
A short conversation surfaces the role mix, the priority skills, and the industry dataset that fits. We will return a written proposal with a recommended path or programme, an indicative schedule, and a quote.
Launch the proposal tool