Excel speed and shortcuts for finance interviews
Many finance and consulting interviews include a timed Excel exercise: a paper LBO or DCF in a sheet, a modelling test, a data case or a quick sensitivity table. The people marking it can see how fast you move as well as whether the answer is right. A candidate who reaches for the mouse for every step loses minutes that a good one spends checking the model. This guide gives the shortcuts worth learning first, a build order for a timed test, the formatting rules reviewers look for, and a drill plan. Keys are given for Excel on Windows, with the Mac differences below; check each one in your own copy before you rely on it, because versions and keyboard layouts differ.
Which shortcuts should I learn first?
Learn in this order. The first group saves the most time and you will use it in every test.
Move and select without the mouse
| Keys | What it does |
|---|---|
| Ctrl + arrow | Jump to the edge of a block of data |
| Ctrl + Shift + arrow | Select from here to the edge of the block |
| Ctrl + Home, Ctrl + End | Go to A1, or to the last used cell |
| Ctrl + Space, Shift + Space | Select the whole column, or the whole row |
| Ctrl + Page Down, Ctrl + Page Up | Next sheet, previous sheet |
| Ctrl + G or F5 | Go To a cell or a named range |
| Alt + ; | Select visible cells only, after filtering or hiding rows |
Edit and fill
| Keys | What it does |
|---|---|
| F2 | Edit the cell, with the cursor at the end |
| F4 | Cycle a reference through $A$1, A$1, $A1 and A1 while editing; repeats your last action otherwise |
| Ctrl + D, Ctrl + R | Fill down, fill right from the first cell of a selection |
| Ctrl + Enter | Enter the same formula or value in every selected cell |
| Alt + Enter | New line inside a cell |
| Alt + = | AutoSum the block above or beside |
| Ctrl + Z, Ctrl + Y | Undo, redo |
| Ctrl + Shift + L | Turn filters on or off |
Audit as you build
| Keys | What it does |
|---|---|
| Ctrl + [ | Jump to the cells a formula uses |
| Ctrl + ] | Jump to the cells that use this cell |
| Ctrl + ` (the key above Tab) | Show formulas instead of values, to spot a hardcode |
| F9 | Recalculate (useful if calculation is set to manual) |
| Alt + M, then P or D | Trace precedents, trace dependents |
How do I format fast and correctly?
Formatting is where the mouse costs the most time. These work from the keyboard.
| Keys | What it does |
|---|---|
| Ctrl + 1 | Open Format Cells (number, alignment, font, border, fill in one place) |
| Ctrl + Shift + 1 | Number with a thousands separator and two decimals |
| Ctrl + Shift + 4, Ctrl + Shift + 5 | Currency, percentage |
| Ctrl + Shift + 7 | Outline border around the selection |
| Ctrl + B, Ctrl + I | Bold, italic |
| Alt + H, then 0 or 9 | Add a decimal place, remove a decimal place |
| Alt + H, then O, then I | Autofit column width |
| Alt + H, then H | Fill colour menu |
| Ctrl + Alt + V | Paste Special (then V for values, T for formats, F for formulas) |
Reviewers expect the conventions a bank or fund uses:
- Blue for hardcoded inputs, black for formulas, green for links to other sheets.
- Assumptions in one block at the top or on their own sheet, never buried inside a formula.
- One formula per row, the same across all columns, so the row can be filled right with Ctrl + R.
- Units and the period in the column heading, and the sign convention stated once.
- A check row that should read zero (assets less liabilities and equity, or sources less uses).
Avoid merged cells. They break selection and fill. Use Center Across Selection from the Alignment tab of Format Cells (Ctrl + 1) instead.
In what order should I build a timed test?
A fixed order stops you from losing time deciding what to do next.
- Read the whole brief first for two minutes and note what is asked, the units and any trap, such as a stated tax rate or a minimum cash balance.
- Set up the sheet: assumptions block, years across, one tab per statement or one tab if time is short. Name the tabs.
- Build the spine first: revenue, margins and the cash flow the answer depends on. Leave detail you can skip.
- Link, do not retype. Every number that exists once should be typed once.
- Add the checks before you read the answer off the model.
- Run the sensitivity last, with a data table or two or three scenarios. Alt + A, then W, then T opens a data table; Alt + A, then W, then G opens Goal Seek.
- Spend the last five minutes checking signs, units and whether the answer is plausible, and write one line on what you would do next with more time.
If the test says to submit a number in a form, copy it as a value first (Ctrl + Alt + V, then V) so it cannot change.
Which functions should I know cold?
You do not need hundreds. Know these without looking them up.
- SUM, SUMPRODUCT, AVERAGE, MIN, MAX and IF, IFERROR for most arithmetic and checks.
- INDEX with MATCH, or XLOOKUP to pull one value from a table. Know one lookup form well rather than three loosely.
- NPV, XNPV, IRR, XIRR and the difference: NPV and IRR assume equal periods, the X versions take dates.
- EOMONTH and EDATE for dates, and ROUND where a figure must match a stated one.
- PMT, IPMT, PPMT for a simple loan schedule.
- SUMIFS and COUNTIFS for a data case, then a pivot table (Alt + N, then V) for a quick cut.
What are the common errors and how do I avoid them?
- A hardcode inside a formula, such as =B5*1.05. Put the 1.05 in an assumption cell.
- A reference that moved when you filled it. Press F4 to lock the part that should not move before you fill.
- Mixed units, such as millions against thousands, or a monthly rate on annual periods.
- A sign error in cash flow, where a cost is added instead of subtracted.
- A circular reference you did not mean. Look for a formula that includes its own total, and turn on iterative calculation only if the task asks for it.
- Pasting values over a live formula by accident. Undo straight away with Ctrl + Z.
- Reading the answer without a check row.
What is different on a Mac?
Most shortcuts use Command where Windows uses Control, but several differ. F2 to edit a cell is Control + U, and F4 to cycle references is Command + T (or F4 with the Fn key held, depending on your settings). The Alt sequences, such as Alt + H, then O, then I, do not exist; you can add your own keys under the Excel menu, then Customize Keyboard. Many timed tests run on Windows, so if you practise on a Mac, check your keys on a Windows machine before the day or ask the recruiter which platform you will use.
Common questions
Do I need to memorise every Excel shortcut?
No. About twenty, used until they are automatic, cover almost everything in a timed test. Learn the movement and selection keys first, then fill and edit, then formatting. Add a new one only when you can use the last ones without thinking.
Is speed or accuracy more important in an Excel test?
Accuracy, but speed decides whether you have time to check. A correct, simply formatted model with check rows beats a faster one with an error you did not catch. Practise building quickly so you finish with minutes to review.
Can I use the mouse in an interview Excel exercise?
Yes, and nobody marks a mouse click as wrong. The advantage of the keyboard is time and, in a live exercise, the impression of fluency. Use whichever is faster for the step in front of you, and do not freeze looking for a shortcut you have forgotten.
What if the firm uses its own template or add-in?
Follow it. Many firms provide a template with formats and checks already set; use its colours and layout rather than your own. If a task names an add-in, ask the recruiter in advance whether it will be available.
What to do this week
- Learn the ten movement, selection and fill keys in the first group above, and use them for a full day of ordinary work with the mouse out of reach.
- Time yourself formatting a 12-row, 6-column table with no mouse: headings, number formats, borders, autofit and the colour conventions. Repeat until it takes under two minutes.
- Build a one-page DCF or paper LBO from a made-up brief in 30 minutes using the build order above, and add a check row.
- Make a deliberate mistake in a copy of your model, such as a hardcode or a sign flip, and find it using Ctrl + `, Ctrl + [ and the check row.
- Practise a data table and Goal Seek once each, so the Alt sequences are familiar.
About this guide: it is original to Charta Learning and has not yet been reviewed by an experienced practitioner. Shortcuts differ by version, keyboard layout and operating system, and firms differ in what they test and in the platform they use. Examples use invented numbers.