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.
7 exercises — Beginner · for Business Analyst
Turn separate year, month and day columns into a real date Excel understands.
DATE
Express clicks as a percentage of the impressions that earned them.
Divide leavers by average headcount to get a turnover percentage.
Divide a unit count by the case size to see how many cases were ordered.
Count how many people sit in a single department on a staff list.
COUNTIF
Divide campaign spend by the leads it generated.
Use the median to describe a set of orders that one huge deal has skewed.
MEDIAN
| # | Exercise | Functions | Difficulty | Time | Status |
|---|---|---|---|---|---|
| 1 | Assemble a delivery date with DATEHarbor Supply — inbound delivery schedule | DATE | Beginner | 5 min | 15 pts |
| 4 | Calculate click-through rateHarbor Supply — campaign performance export | — | Beginner | 4 min | 10 pts |
| 6 | Calculate the annual turnover rateHarbor Supply — annual turnover summary | — | Beginner | 4 min | 10 pts |
| 8 | Convert loose units into full casesHarbor Supply — pick list, units to cases | — | Beginner | 3 min | 10 pts |
| 9 | Count the headcount in one departmentHarbor Supply — staff list by department | COUNTIF | Beginner | 4 min | 10 pts |
| 26 | Work out cost per leadHarbor Supply — spend and leads by campaign | — | Beginner | 4 min | 10 pts |
| 29 | Find the typical order size with MEDIANHarbor Supply — October orders, one outlier | MEDIAN | Beginner | 5 min | 15 pts |