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.

9 exercises — for Product Manager

Sort:Recommended Difficulty Newest

BeginnerText Functions
Build a product code with CONCAT
Join a category prefix and an item number into a single SKU.
CONCAT
4 min10 points
BeginnerMath Functions
Calculate a funnel conversion rate
Work out what share of one funnel stage reached the next.
5 min15 points
BeginnerStatistical Functions
Count orders above a threshold with COUNTIF
Count how many rows meet a numeric condition.
COUNTIF
5 min15 points
IntermediateLogical Functions
Band orders by size with nested IF
Return one of three labels depending on where a value falls.
IF
9 min25 points
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
IntermediateLogical Functions
Turn a product code into a category
Read a code's prefix and translate it into a readable category name.
IFS · LEFT
9 min30 points
IntermediateLookup & Reference
Name the best-performing campaign
Return the campaign name behind the highest conversion count.
INDEX · MATCH · MAX
10 min30 points
AdvancedText Functions
Extract a lot number from a messy code
Pull a fixed-length value out of the middle of a code that varies in shape.
MID · FIND
12 min35 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
2	Build a product code with CONCATHarbor Supply — new catalogue load	CONCAT	Beginner	4 min	10 pts
3	Calculate a funnel conversion rateHarbor Supply — distributor sign-up funnel	—	Beginner	5 min	15 pts
27	Count orders above a threshold with COUNTIFHarbor Supply — October orders	COUNTIF	Beginner	5 min	15 pts
45	Band orders by size with nested IFHarbor Supply — October orders	IF	Intermediate	9 min	25 pts
53	Count orders inside a value bandHarbor Supply — order values, last month	COUNTIFS	Intermediate	7 min	25 pts
64	Turn a product code into a categoryHarbor Supply — SKU category decode	IFS · LEFT	Intermediate	9 min	30 pts
68	Name the best-performing campaignHarbor Supply — conversions by campaign, unsorted	INDEX · MATCH · MAX	Intermediate	10 min	30 pts
70	Extract a lot number from a messy codeHarbor Supply — warehouse barcode strings	MID · FIND	Advanced	12 min	35 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

Build a product code with CONCAT

Calculate a funnel conversion rate

Count orders above a threshold with COUNTIF

Band orders by size with nested IF

Count orders inside a value band

Turn a product code into a category

Name the best-performing campaign

Extract a lot number from a messy code

Build a regional summary from raw orders