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.

3 exercises — Data Analysis · for Data Analyst

Sort:Recommended Difficulty Newest

IntermediateData Analysis
Average one region without AVERAGEIF
Build a conditional average out of a conditional sum and a conditional count.
SUMIF · COUNTIF
9 min30 points
IntermediateData Analysis
Count backorders on three conditions
Narrow a count with three criteria at once rather than filtering by hand.
COUNTIFS
8 min25 points
IntermediateData Analysis
Total only the orders above average
Sum the orders that beat the average, without typing the average in yourself.
SUMIF · AVERAGE
8 min25 points

Excel practice exercises, numbered in recommended learning order.
#	Exercise	Functions	Difficulty	Time	Status
51	Average one region without AVERAGEIFHarbor Supply — orders by region	SUMIF · COUNTIF	Intermediate	9 min	30 pts
52	Count backorders on three conditionsHarbor Supply — open order lines by warehouse	COUNTIFS	Intermediate	8 min	25 pts
60	Total only the orders above averageHarbor Supply — October order values	SUMIF · AVERAGE	Intermediate	8 min	25 pts

Clear all filters

Excel practice exercises

Average one region without AVERAGEIF

Count backorders on three conditions

Total only the orders above average

Average one region without AVERAGEIF

Count backorders on three conditions

Total only the orders above average