Week 01
Model hygiene
First Tuesday of the cohort
A shell that a second person can navigate in two minutes.
We start with an empty workbook and a bad habit list. You set the colour key, the sign convention, the units, and a timeline of thirty-six months plus annual formulas. Sheet order is fixed for the rest of the course so that later weeks are additions, not rearrangements. Protection is discussed as a review aid, not as a way to hide work.
- Excel in the room
- Sheet structure, named ranges used sparingly, freeze panes, print titles, GROUP and outline, custom number format for pounds: £#,##0; (£#,##0); "—".
- You leave with
- Cover, Index, Time, and blank statement sheets with the check rows already waiting.