Excel case study
How many orders shipped late?
Real problems with no formula named for you. You decide what to use.
This order export includes a free-text notes column that isn't relevant. Count how many orders were marked Late.
The data
| A | B | C | |
|---|---|---|---|
| 1 | Order | Status | Notes |
| 2 | #301 | On Time | - |
| 3 | #302 | Late | Customer notified |
| 4 | #303 | On Time | - |
| 5 | #304 | Late | Weather delay |
| 6 | #305 | On Time | - |
| 7 | Late Count |
This is the actual sheet the case study hands you, including whatever column turns out not to matter. Figuring out what to ignore is part of the exercise.
Why this one matters
Real exports bury the column you need among ones you don't. Learning to ignore noise is the actual skill.
More case studies
- Work out this order's shipping cost
- Break down spending by department and category
- Flag the SKUs actually at risk
Case Studies are part of the full unlock
Case Studies are locked until you unlock the full site: real, messier problems with no function named for you, graded the same way every Practice exercise is. Open this one to see how to unlock the rest.
Open this case study →