Subtotals are formulas, not typed numbers — Ctrl+arrows fly you to each #REF!, you rebuild the sum, and one margin formula filled right covers the whole row.
THE FOUNDATIONS CAPSTONE — everything the chapter taught, one board. The quarterly operating model reached you with four subtotal rows — Gross profit, EBITDA (operating profit before depreciation and amortization), EBIT (after it) and Net income — each missing one cell to #REF!, Excel’s broken-reference error. Get every subtotal computing again — subtotals are formulas, never typed numbers — put the bottom line in dollars, land both margin rows and take them to percent, then leave the model at the top for its reader. A clean run (no mouse, no guided) opens the next leg of the track.
Alt walks: tap Alt, release, then the letters in sequence — each key steps one ribbon menu. On a Mac, tap ⌥ and use the same letters (KeyTips, Excel 2024+).
Ctrl+C⌘C on macCopy
Copy starts almost every hand-off — grab a finished block once, then place it in the summary, the deck, or next quarter’s column.
Ctrl+V⌘V on macPaste
Plain paste brings everything: values, formulas, formats. Reach for Paste Special when you only want part of it.
Ctrl+Shift+$⌘⇧$ on macCurrency, 2 decimals
Price columns and per-share figures read as money instantly — standard on comps pages and output rows.
Ctrl+R⌘R on macFill right from the cell to the left
Same as fill down, but across — one quarter’s formula becomes the whole year in two keystrokes.
Ctrl+Shift+%⌘⇧% on macPercent, 0 decimals
Margins, growth rates, weights — any ratio gets the percent treatment the moment it’s computed.
Alt h 0⌥ h 0 on macAdd a decimal place
Add decimals until the figure carries the precision the page needs.
Ctrl+Home⌘Home on macGo to A1 · compact keyboards: Ctrl+Fn+←
Back to A1 — end every session with the cursor home so the next person opens the tab clean.
the par-setting sequence, straight through:
fly ctrl+arrows to each #REF! (F5, B9, D12, E15) → rebuild the sum of the lines above it · Net income B15:F15 ctrl+shift+$ · B6 =B5/B3 → fill right ctrl+r · B10 =B9/B3 → ctrl+r · both margin rows ctrl+shift+% + alt h 0 · ctrl+home · ctrl+s