Paste Special
The shortcut junior analysts miss most. A full paste across tabs drags formatting and formulas you did not want. Paste Special is how you stay surgical.
| Shortcut | Action |
|---|
| Alt + H + V + V | Paste values |
| Alt + H + V + F | Paste formulas |
| Alt + H + V + R | Paste formatting |
| Alt + H + V + T | Paste transposed |
Paste values is the default move when linking outputs between tabs — it prevents the kind of silent model break that a VP will find six hours before the print.
Formatting
Banks care about formatting because formatting signals rigor. A model with inconsistent number formats reads as a model whose numbers cannot be trusted.
| Shortcut | Action |
|---|
| Ctrl + B | Bold |
| Ctrl + I | Italic |
| Ctrl + U | Underline |
| Ctrl + 5 | Strikethrough |
| Alt + H + H | Fill color |
| Ctrl + 1 | Format Cells dialog |
Number Formats
Most banks follow the same convention: blue font for inputs, black for calculations, green for links between tabs. The commands below are what let you hold that convention across a 200-tab model without slowing down the actual analysis.
| Shortcut | Action |
|---|
| Alt + H + K | Comma style |
| Alt + H + P | Percent style |
| Ctrl + Shift + Dollar | Currency format |
| Ctrl + Shift + # | Date format |
| Alt + H + 0 | Increase decimal |
| Alt + H + 9 | Decrease decimal |
Analyst Toolkit
The commands that separate first-year output from third-year output. Formula discipline, audit mechanics, and the layout tools that keep a fifty-tab LBO readable under a deadline.
| Shortcut | Action |
|---|
| F4 | Cycle reference type (absolute → mixed-row → mixed-column → relative) |
| Alt + M + P | Trace precedents |
| Alt + M + D | Trace dependents |
| Alt + H + B + A | All borders |
| Alt + H + O + I | AutoFit column width |
| Alt + H + I + R | Insert rows |
| Alt + A + G + G | Group rows or columns |
| Alt + W + F + F | Freeze panes |
| Ctrl + H | Find & replace |
F4 is the highest-return shortcut on the list. Cycling a reference through absolute, mixed-row, mixed-column, and relative without retyping is what makes a DCF build tolerable. Senior analysts hit it hundreds of times a day without thinking.
Alt+M+P and Alt+M+D — trace precedents and dependents — are how you walk a VP through the WACC build on a fifty-tab LBO without scrolling. Senior bankers notice.
Speed Training: Building Muscle Memory
Shortcuts you have to think about are not real shortcuts. The target is unconscious fluency — your hand executes before the thought finishes.
Training sequence. Run one category per week, in the order the trainer presents them: Essentials, Navigation, Paste Special, Formatting, Number Formats, Analyst Toolkit. Do not jump ahead. The later categories assume the earlier ones are reflex.
Practice scenarios.
- Build a DCF in thirty minutes, keyboard only.
- Format a 200-row dataset without the mouse.
- Debug a broken merger model using only the audit shortcuts.
- Build a sensitivity table with advanced selection.
Speed benchmarks.
- Jump between any two cells in under two seconds.
- Select any data range in under three seconds.
- Apply number formatting in under one second.
- Build SUMIF without looking at the keyboard.
Real speed is chaining. Copy, jump, paste as a single motion, not three decisions. Analysts who hit that level stop thinking about Excel and start thinking about the model.
What banks actually drill
Every investment bank enforces blue-input / black-calc / green-link formatting. That part is universal. The training stack is where firms diverge — some run in-house programs that walk first-year analysts through the shortcuts over several weeks; others outsource to third-party modeling curricula and compress the whole thing into a week before you hit a live deal.
The vendor does not matter. A classroom can show you that Paste Values is Alt+H+V+V. It cannot put the sequence in your fingers. That step is on you regardless of which program the bank pays for.
And the bank knows it. They are not grading you on whether you recognize the shortcut by week two. They are grading you on whether you still need to look at the keyboard by week eight. The analysts who arrive with the muscle memory already loaded spend their first month on the actual work — modeling, diligence, deck building — while peers are still consciously translating intent into keystrokes.
Build the reflex before training starts. It makes everything after it easier.
Common Excel Mistakes That Kill Your Credibility
Mouse dependency. The fastest signal of inexperience. A senior banker clocks it in under a minute.
Inconsistent formatting. Random font sizes, mixed borders, no color convention. The model reads as untrusted before anyone checks a single number.
Broken formula references. Circular references, stale links, values where formulas should be. All preventable with Paste Special and F4 discipline.
Slow navigation. Ten seconds of scrolling to find a tab during a live call is ten seconds of dead air your MD notices.
Manual calculations. Typing a total instead of writing a SUM formula. Saves three seconds now, costs an hour when someone asks you to audit the build.
These mistakes compound at 2 AM. A staffed analyst updating a merger model before a 7 AM kickoff has no margin for any of them.
Where to drill this
OFFERGOBLIN ships twelve Excel drill playlists — Essentials, Navigation, Paste Special, Formatting, Number Formats, Analyst Toolkit, and six more — timed, tracked, and ramped from entry-level to analyst toolkit. The drills tell you which shortcuts you already own cold and which ones you are still thinking through.
Start drilling at /model-training.
Conclusion
Excel fluency is not the deliverable. The deliverable is a clean model, shipped early, that the VP can use without rework. Shortcuts are the path to that. Essentials and Navigation first, then Paste Special, then Formatting and Number Formats, then the Analyst Toolkit. Drill until your hands move without your permission.
The analysts who get promoted are not the ones who know the most shortcuts. They are the ones who stopped thinking about them.