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 — Beginner · Statistical Functions · for Business Analyst

Sort:Recommended Difficulty Newest

BeginnerStatistical Functions
Count the headcount in one department
Count how many people sit in a single department on a staff list.
COUNTIF
4 min10 points
BeginnerStatistical Functions
Find the typical order size with MEDIAN
Use the median to describe a set of orders that one huge deal has skewed.
MEDIAN
5 min15 points

Excel practice exercises, numbered in recommended learning order.
#	Exercise	Functions	Difficulty	Time	Status
9	Count the headcount in one departmentHarbor Supply — staff list by department	COUNTIF	Beginner	4 min	10 pts
29	Find the typical order size with MEDIANHarbor Supply — October orders, one outlier	MEDIAN	Beginner	5 min	15 pts

Clear all filters

Excel practice exercises

Count the headcount in one department

Find the typical order size with MEDIAN

Count the headcount in one department

Find the typical order size with MEDIAN