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 — Text Functions · 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
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

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
70	Extract a lot number from a messy codeHarbor Supply — warehouse barcode strings	MID · FIND	Advanced	12 min	35 pts

Clear all filters

Excel practice exercises

Build a product code with CONCAT

Extract a lot number from a messy code

Build a product code with CONCAT

Extract a lot number from a messy code