BeginnerExcel Basics
Convert loose units into full cases
Divide a unit count by the case size to see how many cases were ordered.
3 min10 points
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 — Excel Basics · for Operations
Divide a unit count by the case size to see how many cases were ordered.
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 |
| 18 | Work out remaining leave daysHarbor Supply — annual leave tracker | — | Beginner | 3 min | 10 pts |