Excel practice exercises

Real situations from working spreadsheets — sales targets, commission tiers, messy exports, aged invoices. Numbered in recommended order: start at 1 and work down, or filter to what you need.

2 exercises — Data Analysis · for Product Manager

Sort:Recommended Difficulty Newest

IntermediateData Analysis
Count orders inside a value band
Apply an upper and a lower bound to the same column at once.
COUNTIFS
7 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

Excel practice exercises, numbered in recommended learning order.
#	Exercise	Functions	Difficulty	Time	Status
53	Count orders inside a value bandHarbor Supply — order values, last month	COUNTIFS	Intermediate	7 min	25 pts
71	Build a regional summary from raw ordersHarbor Supply — raw October order export	COUNTIF · SUMIF	Advanced	16 min	40 pts

Clear all filters

Excel practice exercises

Count orders inside a value band

Build a regional summary from raw orders

Count orders inside a value band

Build a regional summary from raw orders