Chapter 6
Creating and Using PivotTables
IN THIS CHAPTER
Getting to know PivotTables
Using an Excel table to build a PivotTable
Using external data to build a PivotTable
Putting the “pivot” in PivotTable
Grouping and filtering PivotTables
Excel tables and external databases can contain thousands of records. Let’s face it: Figuring out how to glean useful insights from that much data will either keep you awake at night or cause nightmares if you do sleep. Want to get some quality shut-eye? No need for sleeping pills when Excel offers a powerful and versatile data-analysis tool called a PivotTable, which enables you to take those thousands of records and summarize them in a concise tabular format. You can then manipulate the layout of — or pivot — the PivotTable to see different views of your data.
This chapter shows you everything you need to know to get started with what is arguably Excel’s most useful data-analysis tool. You learn how to create PivotTables, refresh them, pivot them, ...
Get Excel Data Analysis For Dummies, 5th 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.
