FICTIONAL TRAINING DATA ONLY
One row represents one order in the verified reference extract.
order_id: unique order identifier. F = February, M = March; prefixes are sample labels, not a production parsing rule.
order_date: ISO calendar date, YYYY-MM-DD. Reporting periods are full February and March 2026 in this exercise.
channel: web or store.
status: completed, returned, cancelled. These are final status snapshots; there is no refund or payment ledger.
order_value_eur: recorded order value in EUR; not net profit or accounting revenue. For this exercise only, sales means SUM(order_value_eur) WHERE status = completed.
The reference file is the verified source supplied by the fictional operations owner. It is not derived by guessing corrections from the raw file.
The raw file deliberately contains a duplicated M004, invalid date and missing channel on M006, and negative value on returned order M005. Do not silently fix unknown production values.
No customer IDs, costs, traffic, campaign assignments or order-line records are available. No causal, customer-retention or profit conclusions are supported.

MODULE 02 WORKBOOK LAYOUT
Analysis B5/C5: actual date keys 2026-02-01 and 2026-03-01. B6:C8: completed sales, completed orders, AOV. D/E: absolute and relative changes. B14:C15: web/store completed sales. B16:C16 channel sums; B17:C17 reconciliation differences.
Prepared A5:H17: Orders Excel Table; verified 12 rows. A:E are reference inputs. F month_start; G sales_channel; H completed_value.
Source A5:E18: unchanged raw snapshot; dates intentionally retained as text.
Mapping A5:B7: unique web/store keys and nonblank Digital/Physical store labels.
The starter prepopulates verified Prepared inputs so formula lessons can proceed. Recreate cleaning independently on a scratch copy of Source.
Formulas use fixed sample ranges through Prepared row 17. They are not an automatic source-refresh system. Extend and test them for extra records. No native PivotTable is prebuilt; learners create one in their Excel edition. The solution includes an editable range-backed chart and formula-based independent totals.
English formulas use commas; adapt separators/function names to your Excel locale. INDEX/MATCH is used in the workbook; XLOOKUP is discussed as an optional alternative.