Excel Practice Sheets

Excel for students

Excel is the skill most often screened for before an interview and most often overstated on a résumé. Closing that gap is worth more than another line on the CV.

Start Practising21 exercises, free, no account needed

What the job actually asks for

The functions that appear in graduate assessments are a small, stable set: lookups, conditional aggregation, logical tests and text cleaning. Depth in those beats passing familiarity with fifty functions.

The recurring tasks

  • Learn the functions interviews actually test
  • Practise under time pressure
  • Build a portfolio-worthy analysis
  • Understand why a formula works, not just that it does

Where people get caught

Learning by watching. Reading about XLOOKUP produces recognition, not recall — and an assessment asks for recall, on data you have not seen, with someone watching.

What interviews test

Writing lookups and conditional sums from memory, at speed, and explaining the reasoning while you do it.

Practice built from student work

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

Beginner

19 exercises · 1 step

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

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 student — they are the keystrokes and the misconceptions that catch everyone out, whatever the spreadsheet is about.