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 — Beginner · Excel Basics
Divide a unit count by the case size to see how many cases were ordered.
Subtract cost from revenue to find what each order actually earned.
Subtract leave taken from entitlement to see what each person has left.
| # | Exercise | Functions | Difficulty | Time | Status |
|---|---|---|---|---|---|
| 8 | Convert loose units into full casesHarbor Supply — pick list, units to cases | — | Beginner | 3 min | 10 pts |
| 17 | Work out gross margin per orderHarbor Supply — order profitability | — | Beginner | 3 min | 10 pts |
| 18 | Work out remaining leave daysHarbor Supply — annual leave tracker | — | Beginner | 3 min | 10 pts |