Excel Practice Sheets

Excel for data analysts

The job description says analysis. The calendar says cleaning, joining and reshaping, and Excel is where most of that still happens.

Start Data Analysis Practice31 exercises, free, no account needed

What the job actually asks for

Analysts spend far more time preparing data than analysing it: splitting text, standardising labels, joining on shared keys, and checking that the join actually matched what it should have. The analysis itself is often the shortest part of the work.

The recurring tasks

  • Clean exports before analysis
  • Join datasets on a shared key
  • Build pivot summaries by dimension
  • Identify outliers and explain them

Where people get caught

Trusting a join without checking it. A lookup that silently returns #N/A for eight percent of rows produces a total that is wrong by eight percent, and nothing on screen says so.

What interviews test

Lookups in both directions, conditional aggregation with several criteria, splitting messy text, and — the part candidates fumble — explaining why you chose one approach over another.

Practice built from data analyst work

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

Beginner

9 exercises · 1 step

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

Intermediate

15 exercises · 2–3 steps

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

Advanced

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