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 — Logical Functions · for Marketing

Sort:Recommended Difficulty Newest

IntermediateLogical Functions
Flag campaigns over budget by a margin
Mark a campaign only when it overspends by more than a tolerance.
IF
8 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

Excel practice exercises, numbered in recommended learning order.
#	Exercise	Functions	Difficulty	Time	Status
47	Flag campaigns over budget by a marginHarbor Supply — campaign budget versus actual	IF	Intermediate	8 min	25 pts
64	Turn a product code into a categoryHarbor Supply — SKU category decode	IFS · LEFT	Intermediate	9 min	30 pts

Clear all filters

Excel practice exercises

Flag campaigns over budget by a margin

Turn a product code into a category

Flag campaigns over budget by a margin

Turn a product code into a category