DATA ANALYST FOUNDATIONS / MODULE 02: EXCEL
Keep your files locally. Fictional sample only.
1. Import note: original/reference row counts, row grain, field types, invalid date behaviour.
2. Quality log: record, issue, observed value, correction, source authority.
3. Formula log: F6 month key; H6 completed value; B6 sales; B7 orders; B8 AOV; D6 absolute change; E6 relative change. Explain copied C6 and final F17.
4. Mapping tests: unknown key, duplicate key, blank classification. Restore original values after each.
5. Native PivotTable: create My pivot in Excel. Record source, field layout, completed filter, refresh test and reconciliation. This feature is not prebuilt in either workbook.
6. Chart: use linked completed-sales totals. Record before/after/restore values for a temporary source edit.
7. Evidence note: 120-180 words including scope, findings, limitations and next step.
8. Self-review: 0-2 each for preparation, formulas, mapping, summary/chart and communication. Record unavailable native PivotTable practice as pending.