Chapter 20
Generating PivotTables
IN THIS CHAPTER
Understanding how PivotTables summarize data and enable you to analyze tables
Filtering a PivotTable with Slicers
Creating a new PivotTable
Changing the summary function used in the PivotTable
Formatting a PivotTable and changing PivotTable options
Creating a PivotChart with your PivotTable
Excel’s PivotTables enable you to quickly summarize and play around with vast amounts of worksheet data. Many people consider PivotTables to be the most versatile of Excel’s many data analysis features, if not its coolest and most powerful. In this chapter, you get the chance to practice creating and using PivotTables and their visual equivalent, PivotCharts, to see how they can help reveal complex relationships in your data that may otherwise go completely unnoticed.
Working with PivotTables
PivotTables are great for summarizing the data in a range, ...
Get Excel Workbook For Dummies, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
