Skip to content

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.

#ProblemWhat you see
1No header styleThe first row looks like data: no bold, no fill, no borders.
2A number is missingNumbers were typed by hand, so they jump (176 → 178 in the full file).
3Text in the wrong column“long” slipped into Quantity.
4Messy textExtra spaces, mixed capitals: glass cutter, Binding Wire.
5Empty prices and totalsNo formulas, so nothing adds up.
6Not ready to printNo 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.

Download