Investment banking Excel shortcuts: the 40 you need before day one

Why banks take the mouse away

Most training programs run the first Excel day with the mouse unplugged. It is not hazing. A model is a grid of a few thousand cells, and almost every action on it is one of a dozen moves: jump to the edge of a block, select it, fill a formula across it, lock a reference, format a row, paste values, trace where a number comes from. Each of those is one or two key presses, or four to six seconds with a mouse. Multiply by a thousand actions a day and the keyboard analyst goes home earlier with a cleaner model.

The second reason is review. An associate or VP checks a model by tracing formulas, and watches how you move through it when you walk them through a change. Reaching for the mouse to click a cell reads as not knowing the sheet. Ctrl+[ to the precedent, F5 Enter back, reads as command of it.

The color convention, and the shortcut that applies it

Every bank model uses the same font colors: blue for hard-coded inputs, black for formulas, green for formulas that pull from another sheet, sometimes red for links to other files. A reviewer can then see at a glance which numbers may be changed and which are calculated. The shortcut is Alt, H, F, C and then the color; the faster habit is to apply it as you type each input, not in a pass at the end. The Input color pass task drills exactly this on a mini model with the clock running.

1. Moving through the model

Learn these first. They replace scrolling entirely and they are the base for selection.

2. Selecting

Shift extends any jump. The rest is rows, columns and the current region.

3. Formatting a schedule

Number formats are the chords; borders, colors and widths are Alt chains. A schedule is formatted in one pass: header bold and bordered, amounts in comma format, rates in percent, inputs blue.

4. Building formulas

F4 is the shortcut that makes a model fillable. Learn the four states and count the presses: B13, $B$13, B$13, $B13.

5. Paste special

Three options cover the day: values to freeze a calculation or retire a helper sheet, formats to paint a row, transpose to turn assumptions into a column.

6. Structure

Grouping, hiding, freezing and sheet management keep a 20-tab model navigable. These are the shortcuts the mouse creeps back in for, because none is used every minute.

The Alt key chains

Press Alt in Excel for Windows and letters appear over the ribbon tabs; press one and letters appear over that tab's commands. The chain is the sequence. They look slow written out and are fast in the hand: Alt, H, O, I autofits a column in well under a second once the fingers know it. The chains worth memorizing are the ones above plus Alt, H, B for the borders menu, Alt, H, H for fill color, Alt, N, V for a pivot table and Alt, H, D, S to delete a sheet. Each has its own page under ribbon key tips.

If you are on a Mac

The bank will put you on Windows. The chords mostly carry over with Cmd for Ctrl, the number formats use Control, and the Alt chains do not exist on a Mac at all. If you want to prepare on your own machine, use the Windows key set: the Shortcutdrill sheet treats Option as Alt, so the chains work in the browser even though they do not in Excel for Mac. The Mac shortcuts page has the full mapping.

How to actually learn them

Not from this page. Lists are for reference; reflexes come from doing the move under a constraint. The Analyst track is twenty days of fifteen minutes: three to five new drills a day on a live sheet with a key-press limit, five spaced repeats, a timed task from day 8, and a ten-minute interview-style test on day 20 with a result card you can keep. Twenty-five drills are free; the full set is $9 a month, $29 a year, or $49 once.

Questions