Analyze with pivot tables
Summarize a large table by the dimensions that matter to a decision.
Pivot Table Excel Tutorial
From Kevin Stratvert. Watch here or open it on YouTube .
Follow the exact pivot mechanics in the video, then change one field at a time and explain how the business meaning changes.What this lesson is really solving.
Begin with a decision question, then choose rows, columns, values, filters, and aggregation accordingly. Confirm whether the value is sum, count, distinct count, average, or percentage. Drill into surprising totals before interpreting them.
Understand the idea before touching the steps.
A pivot asks: measure what, grouped by which dimensions, filtered to which scope?
Follow these steps in order.
Take the action in each step; then use the deliverable below to prove the lesson is finished.
- 1
Write the decision question before dragging fields into rows and values.
- 2
Choose a measure and aggregation that match the data: sum, count, distinct count, average, minimum, or maximum.
- 3
Add only the dimensions needed to compare time, category, region, owner, or status.
- 4
Refresh after source changes and reconcile the pivot total to a known control total.
See the standard in context.
To find where cancelled orders are concentrated, the analyst puts Region in rows, Status in columns, Order ID count in values, and Order Date as a filter. A percentage-of-row view is added beside raw counts so a large region does not look bad merely because it has more orders.
Inspect before you move on.
- The aggregation answers the written question.
- Filters and refresh status are visible to the reader.
- At least one pivot total is independently reconciled to source data.
Your deliverable
Three pivot views answering trend, mix, and exception questions from the same source table.
Watch for this
Averaging averages or counting rows when the business question requires unique customers.
Prove it—don’t just recognize it.
You can state the grain, measure, aggregation, filters, and control total behind every pivot.
Quick knowledge check
Answer from the lesson—not from confidence alone. Score at least 2 of 3 to unlock completion.
This curriculum-aligned check is scored automatically and stored with your account when signed in. It is an objective learning signal, but it has not yet been independently validated as a standardized assessment.
Tools, templates, and references
Pass the knowledge check above first.
Completion unlocks after a score of 2 out of 3. Then confirm that you produced the lesson deliverable.
Go to the knowledge check