Module 01 · Lesson 01
Your practice file
One messy store stock list with six problems. By the end of the course you'll fix all of them.
Excel basics3 min
The whole course works on one real file: a store stock list. It arrives the way most spreadsheets arrive: messy.
| # | Problem | What you see |
|---|---|---|
| 1 | No header style | The first row looks like data: no bold, no fill, no borders. |
| 2 | A number is missing | Numbers were typed by hand, so they jump (176 → 178 in the full file). |
| 3 | Text in the wrong column | “long” slipped into Quantity. |
| 4 | Messy text | Extra spaces, mixed capitals: glass cutter, Binding Wire. |
| 5 | Empty prices and totals | No formulas, so nothing adds up. |
| 6 | Not ready to print | No repeating header, no page numbers. |
Download the mini practice file (CSV)
16 rows from the store stock list with the same six problems planted: no header style, a missing number (12), “long” in the Quantity column, messy text, empty prices and totals, a duplicate and a spelling slip. Opens in Excel. Blank quantities and prices are blank on purpose: type your own numbers to practise formulas.