ADVERTISEMENT
Google AdSense Slot (headerLeaderboard)
Set your Publisher ID in src/config/ads.ts to display live ads.
Excel for Data Analysis Tutorial• 7 min read
Pivot Tables & Pivot Charts: Instant Summarization
Fields, Rows, Columns, Values, Grouping dates, and Slicers
Pivot Tables allow you to summarize, cross-tabulate, filter, and analyze hundreds of thousands of rows of data in seconds without writing a single formula.
The 4 Quadrants of a Pivot Table
1Rows: Categorical variables that become row headers (e.g. Sales Rep).
2Columns: Categorical variables that become column headers (e.g. Quarter / Year).
3Values: The numerical metrics to aggregate (e.g. Sum of Revenue, Average Discount).
4Filters / Slicers: Interactive visual buttons that filter the entire Pivot Table with a single click.
Pro Tip
Right-click date fields in a Pivot Table and select "Group" to aggregate raw transaction dates into Years, Quarters, and Months automatically.
ADVERTISEMENT
Google AdSense Slot (inContentBanner)
Set your Publisher ID in src/config/ads.ts to display live ads.
Test Yourself With Exercise
In an Excel Pivot Table, where should you drag the `Revenue` field to calculate total sales figures?