◆ Full Builds · drill · Financial Modeling Keyboard Mastery track
Build the model cover
a cover page owns no math — every figure on it is a wire back to the model, and so is the title.
The IC pack goes out at six and page one is still blank. The model outputs strip at the bottom of the sheet is finished — base case and downside — and the deal name came off the data-room export in lower case with the spaces mangled. Build the cover: pull the six headline metrics onto it for both cases, set them to house format, and stamp the title off that raw feed. Nothing on a cover page is ever typed twice.
The shortcuts in this drill
Shift+↓⇧↓ on macExtend selection one cell
Shift+→⇧→ on macExtend selection one cell
Nudge a selection one cell at a time when the block you need doesn’t end at a data edge.
Ctrl+1⌘1 on macOpen the Format Cells dialog
The master formatting dialog — number formats, alignment, borders in one place when a ribbon walk would take longer.
Ctrl+B⌘B on macBold
Bold marks structure: titles, total rows, anything the reviewer’s eye should land on first.
functions you'll type: UPPER() · TRIM()
The optimal line
the par-setting sequence, straight through:
cover box C5:D10 → one selection, =C13, ctrl+↵ · C5:D7 ctrl+1 p · C8:D10 ctrl+1 c · B1 =UPPER(TRIM(C20)) · B1:D1 ctrl+b + ctrl+1 a · ctrl+s
More Full Builds drills