Clean Source Data & Your First PivotTable
Prepare tidy tabular columns, insert a PivotTable from an Excel Table, and place dimensions into Rows, Columns, and Values.
Key takeaways while you watch
- Every column must have a single unique header row — avoid merged cells or blank sub-headers.
- Convert raw data to a Table (Ctrl+T) first so Refresh picks up new rows automatically.
- Drag text attributes to Rows/Columns and numeric measures to Values.
Drill: Spot Why Pivot Values Default to COUNT
When a numeric Revenue column contains even one blank cell or text string (e.g. 'TBD'), what aggregation does Excel pick by default?
| Order | Revenue | Default Pivot Aggregation |
|---|---|---|
| #101 | 450 | SUM when all numbers |
| #102 | TBD | COUNT instead of SUM |
Module 01 Knowledge Check
Answer all 3 questions and check your score to unlock credit toward completion.