Excel Practice Sheets

Excel for product managers

Product managers use Excel to answer their own questions quickly rather than waiting a week for someone else's queue.

Start Product Management Practice9 exercises, free, no account needed

What the job actually asks for

Sizing an opportunity, tracking activation across cohorts, scoring a backlog, summarising feedback by theme. The bar is speed and directional accuracy rather than production-grade rigour — but the numbers still end up in a deck.

The recurring tasks

  • Size a market or feature opportunity
  • Track activation and retention cohorts
  • Prioritise a backlog with scoring models
  • Summarise user feedback by theme

Where people get caught

Overcomplicating. A nested formula five levels deep is harder to check than three columns that each do one thing, and in a spreadsheet others will read, legibility is a feature.

What interviews test

Sizing something from assumptions you state out loud, and summarising a dataset by dimension without reaching for a pivot table.

Practice built from product manager work

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

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