BeginnerStatistical Functions
Count orders above a threshold with COUNTIF
Count how many rows meet a numeric condition.
COUNTIF
5 min15 points
Excel for product managers
Product managers use Excel to answer their own questions quickly rather than waiting a week for someone else's queue.
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
3 exercises using the situations above, ordered from most approachable to hardest.
- IntermediateLogical Functions
Band orders by size with nested IF
Return one of three labels depending on where a value falls.
IF
9 min25 points - AdvancedData Analysis
Build a regional summary from raw orders
Produce a summary line combining count, total and average for one region.
COUNTIF · SUMIF
16 min40 points