Each project arrives with its purpose, milestones and first tasks written out. Here is how the first three read.
Personal modelling standard for client work
Models built on a Monday night under deadline pressure all look different, and the reviewer has to learn a new layout every time. A one-page standard covering cell colours for inputs, formulas and links, sign conventions, units, tab order and naming means every model you build reads the same way, and a manager can review it in half the time.
First tasks
- Find your firm's modelling or Excel guide in the knowledge base
- Write the colour, format, sign and unit rules on one page
- Build a blank starter workbook with cover, inputs, calcs, outputs and checks tabs
- Send the standard to your engagement manager and ask for one change
Excel set-up for keyboard-first modelling
Consultants lose hours a week to default settings: automatic calculation on a heavy file, a ribbon hunted with the mouse, and paste-special buried three menus deep. One session setting calculation mode, the Quick Access Toolbar, autosave behaviour and your most used shortcuts pays back within the first week of any engagement.
First tasks
- List the ten commands you reach for most with the mouse
- Add them to the Quick Access Toolbar in order of use
- Set the AutoRecover interval and check where recovered files land
- Export the toolbar customisation and save it to your own notes
Model scoping note before the first formula
Most rebuilt models were rebuilt because nobody wrote down what they had to answer. Half a page agreed with the engagement manager, naming the questions, the outputs and their units, the time horizon, the level of detail and who will use the file, stops you building a monthly SKU model when the steering committee wanted three annual scenarios.
First tasks
- Write the questions the model must answer for this engagement
- Sketch each output table with its units on paper
- Decide the time horizon, period length and currency
- Walk the engagement manager through the note in fifteen minutes