Excel Practice Sheets

Excel for finance

Finance runs on spreadsheets that other people rely on without checking. That raises the bar: a formula that is merely usually right is a liability, because nobody downstream will catch it.

Start Finance Practice40 exercises, free, no account needed

What the job actually asks for

Most finance Excel work is not modelling — it is reconciliation, variance analysis and building the same report faster than last month. The skill that separates people is not knowing exotic functions; it is building sheets that survive a new row being added, a column being inserted, or a colleague reopening them in six months.

The recurring tasks

  • Build budget-versus-actual variance reports
  • Model revenue forecasts across scenarios
  • Calculate margins, growth rates and run rates
  • Reconcile figures between systems

Where people get caught

Hard-coded ranges. A variance report built against A2:A47 quietly stops covering the data the month a 48th row appears, and because the total still looks plausible, nobody notices until someone reconciles it by hand.

What interviews test

Expect to be handed two tables and asked to join them, then asked what happens to your formula when a column is inserted. The answer they want involves XLOOKUP or INDEX/MATCH, and an explanation of why VLOOKUP's column number is fragile.

Practice built from finance work

40 exercises using the situations above. Work down the levels — each one assumes the one before it.

Beginner

12 exercises · 1 step

One function, one step, a small and tidy dataset.

Intermediate

19 exercises · 2–3 steps

Two or three functions combined, or one function with conditions.

Advanced

9 exercises · 3–5 steps

Nested logic across a realistic dataset, with edge cases that bite.

Prefer to work in real Excel? Download the practice files — the same datasets with the answer cells left blank. You lose the feedback, which is the part that does the teaching.

Other roles

Skills every role needs

These are not specific to finance — they are the keystrokes and the misconceptions that catch everyone out, whatever the spreadsheet is about.