Charta is on Google Play: practise on the go. Get the app

Excel speed and shortcuts for finance interviews

26 October 2026 · 8 min read · Charta Learning

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

KeysWhat it does
Ctrl + arrowJump to the edge of a block of data
Ctrl + Shift + arrowSelect from here to the edge of the block
Ctrl + Home, Ctrl + EndGo to A1, or to the last used cell
Ctrl + Space, Shift + SpaceSelect the whole column, or the whole row
Ctrl + Page Down, Ctrl + Page UpNext sheet, previous sheet
Ctrl + G or F5Go To a cell or a named range
Alt + ;Select visible cells only, after filtering or hiding rows

Edit and fill

KeysWhat it does
F2Edit the cell, with the cursor at the end
F4Cycle a reference through $A$1, A$1, $A1 and A1 while editing; repeats your last action otherwise
Ctrl + D, Ctrl + RFill down, fill right from the first cell of a selection
Ctrl + EnterEnter the same formula or value in every selected cell
Alt + EnterNew line inside a cell
Alt + =AutoSum the block above or beside
Ctrl + Z, Ctrl + YUndo, redo
Ctrl + Shift + LTurn filters on or off

Audit as you build

KeysWhat 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
F9Recalculate (useful if calculation is set to manual)
Alt + M, then P or DTrace precedents, trace dependents

How do I format fast and correctly?

Formatting is where the mouse costs the most time. These work from the keyboard.

KeysWhat it does
Ctrl + 1Open Format Cells (number, alignment, font, border, fill in one place)
Ctrl + Shift + 1Number with a thousands separator and two decimals
Ctrl + Shift + 4, Ctrl + Shift + 5Currency, percentage
Ctrl + Shift + 7Outline border around the selection
Ctrl + B, Ctrl + IBold, italic
Alt + H, then 0 or 9Add a decimal place, remove a decimal place
Alt + H, then O, then IAutofit column width
Alt + H, then HFill colour menu
Ctrl + Alt + VPaste Special (then V for values, T for formats, F for formulas)

Reviewers expect the conventions a bank or fund 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.

  1. 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.
  2. Set up the sheet: assumptions block, years across, one tab per statement or one tab if time is short. Name the tabs.
  3. Build the spine first: revenue, margins and the cash flow the answer depends on. Leave detail you can skip.
  4. Link, do not retype. Every number that exists once should be typed once.
  5. Add the checks before you read the answer off the model.
  6. 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.
  7. 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.

What are the common errors and how do I avoid them?

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

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.

More guides

Practise with questions that explain every wrong answer, and a plan built from a short diagnostic.

Start free →

Charta Learning is independent. It is not affiliated with, sponsored by or endorsed by any bank, fund or consultancy. All questions, cases and notes are original, written for this product with invented companies and public information only; none is a real question from any firm's recruitment process. Feedback on written answers is AI-assisted and can be wrong. The legal and documentation topics are general education, not legal advice. We do not guarantee interviews, offers or results.