Everything you need to follow along
Start with the file.
Finish with a checked result.
Original fictional data, a formula-driven workbook, and explicit expected outcomes. No email or account required.
Weekly sales worked example
Three sheets: Weekly report, prepared Orders, and the original Raw export. Formulas calculate the reporting window, line values, SKU totals, and distinct included orders.
Download the Excel workbook ↓Follow the complete workflow ↗Expected week: October 26–November 1, 2026. Net sales RM267.60. No macros or external file connections.
| Practice file | What it contains | Download |
|---|---|---|
| Original order export | 14 records. Exact repeated line, two-line order, statuses, and date boundaries. | CSV ↓ |
| Prepared order export | 13 lines after removing the known exact repeated record. ISO date strings and plain amounts. | CSV ↓ |
| Included report lines | Nine Shipped lines within the reporting week. | CSV ↓ |
| Comparison snapshot A | Six order-level records, including a repeated key. | CSV ↓ |
| Comparison snapshot B | Five order-level records. | CSV ↓ |
| Mixed-date practice | Ambiguous, invalid, blank, ISO, and leap-day examples. | CSV ↓ |
| CSV import edge cases | Leading zeros, long references, quoted commas, multiline notes, and formula-like text. | CSV ↓ |
| RM amount practice | Known answers, a negative, zero, blank, and an unresolved decimal convention. | CSV ↓ |
| Lookup-key practice | Spaces, a nonbreaking space, and a text identifier. | CSV ↓ |
| Second source for refresh | Two lines. Five units and RM85.00 net sales. | CSV ↓ |
| Blank method measurement log | Record your own setup, work, review time, and observed outcome. | CSV ↓ |
| Expected weekly results | Reporting window, row counts, units, gross, discount, and net totals. | JSON ↓ |
Using the files
Every record and contact detail is fictional and created for these examples. You may use and adapt the practice data for learning and internal training. Attribution is appreciated. Third-party sources retain their own rights.
CSV has no spreadsheet column types. Import identifiers as Text and apply the declared date and decimal convention. The edge-case sample includes a deliberately formula-like note; inspect it through a text-typed import. The worked XLSX stores identifiers as text.
For a reusable workflow, read the guide's scope and test a second sample before replacing it with your own records. See how the examples are checked.