Skill path · BeginnerNew
Model Architecture and Construction
Build a readable decision model with linked schedules, scenarios and checks that expose errors.
27 exercises · 4 h · 38 checked cells
6 of 27 exercises free, no account needed.
Before you start
Know Excel Foundations and Formula Fluency and Accounting for Analysts first. You build: A decision model that survives changed assumptions and horizons, with a reviewed handoff.
About 4 h; full access adds 21 exercises.
Loading the spreadsheet…
The route
- 1Define the decision before the workbookDecision, layers and timeline3 exercises · 24 minFree
- 2Separate evidence, assumptions, calculations and outputsDecision, layers and timeline3 exercises · 24 minFree
- 3Build a timeline that can changeDecision, layers and timeline3 exercises · 24 minFull access
- 4Switch assumptions without hiding hardcodesScenarios, links and checks3 exercises · 24 minFull access
- 5Link schedules and document circularityScenarios, links and checks3 exercises · 24 minFull access
- 6Design checks before finishing the modelScenarios, links and checks3 exercises · 24 minFull access
- 7Review the model as the next analystReview, robustness and handoff3 exercises · 24 minFull access
- 8Test changes and repairs systematicallyReview, robustness and handoff3 exercises · 24 minFull access
- 9Case: construct, explain and hand off the Cedar modelReview, robustness and handoff3 exercises · 45 minFull access
What it ends in
A FinX certificate of completion, which anyone can verify by link.
Questions
- How long does Model Architecture and Construction take?
- About 4 h: 27 exercises in 9 lessons, with 38 checked cells between them. Times are estimates from writing the lessons.
- What can I do for free?
- 6 of the 27 exercises are free, with no account: Define the decision before the workbook and Separate evidence, assumptions, calculations and outputs. Full access opens the rest.
- Do I need Excel installed?
- No. Every exercise runs in a spreadsheet in your browser, and each answer is checked cell by cell, so you see exactly which cell is wrong.
- What do I get at the end?
- A FinX certificate of completion, which anyone can verify by link.