Statistical Assistant how-to
How to Build a Pivot Table Summary
Pivot tables summarize fast.
Quick answer
Pivot tables summarize fast. In short: select; insert; add, then complete the remaining steps below.
Step by step
Select data.
Insert a pivot table.
Add rows.
Add values.
Add filters.
Format clearly.
Safety reminders for statistical assistants
- Protect confidential data
- Follow data security rules
- Document changes
- Report errors
Key terms
Mean · Median · Mode · Standard deviation · Outlier · Missing data: see the full statistical assistant glossary.