A facilitated 17-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 + 3hr Cap |
| M5A | Power Query, Transform and Shape | Full day | 6 |
| M5B | Power Query, Code, Connections, Architecture | Full day | 5 + 1hr Recap |
| M6A | Financial Functions, Core | Full day | 6 |
| M6B | Financial Functions, Planning and Optimisation | Full day | 5 + 1hr Wrap |
| M7A | PowerPivot, Data Model and DAX Foundations | Full day | 6 |
| M7B | Advanced DAX, Time Intelligence and REGEX | Full day | 4 + 2hr Cap |
| M8A | Dashboard Design and Charting | Full day | 6 |
| M8B | Interactive Controls and Delivery | Full day | 5 + 1hr Wrap |
| M9 | AI-Augmented Excel Workflows | Full day | 6 |
| M10A | Advanced Power BI, Modelling | Full day | 5 + 1hr Proj |
| M10B | Advanced Power BI, Engineering | Full day | 5 + 1hr Proj |
| M10C | Advanced Power BI, Design | Full day | 5 + 1hr Proj |
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. The Advanced Power BI extension (M10A, M10B, M10C) is priced separately at $1,224 ex GST for the full three-module series.
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