Excel case study
Who still owes on their invoice?
Real problems with no formula named for you. You decide what to use.
Finance needs a headcount: how many clients in this export have an outstanding balance over $1,000?
The data
| A | B | |
|---|---|---|
| 1 | Client | Balance |
| 2 | Nova Retail | 1240 |
| 3 | Kessler Co | 860 |
| 4 | Bright Path | 2100 |
| 5 | Ardent Group | 400 |
| 6 | Delta Freight | 1750 |
| 7 | Orinda LLC | 990 |
| 8 | Over $1,000 |
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
Knowing when to count, sum, or average is half of real spreadsheet work. The other half is writing the formula.
More case studies
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 →