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.

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

17 exercises using the situations above, ordered from most approachable to hardest.

Other roles