1. Prepare a reporting table from related files
TASK: Create a working line table with order date and status from an exact order lookup. Record key uniqueness, unmatched count and completed line count.
Your method:
Your evidence/result:
Limitations and next action:


2. Create PivotTables and compatible measures
TASK: Build monthly completed value and order-count summaries. State whether you used a distinct count or an order-grain intermediate.
Your method:
Your evidence/result:
Limitations and next action:


3. Reconcile formulas and write a reporting note
TASK: Write the grand AOV formula and compare it with the unweighted monthly average. Prepare a short report note with exclusions.
Your method:
Your evidence/result:
Limitations and next action: