Chapter 18
Analyzing data with PivotTables
In this chapter, you will:
Hide and customize PivotTable subtotals
Change the value field summary calculation
Create custom PivotTable calculations, including calculated fields and calculated items
Learn how to use PivotTable results in worksheet formulas
Tables and external databases can contain hundreds or even thousands of records. Analyzing that much data can be a nightmare without the right kinds of tools. To help you, Excel offers a powerful data analysis tool called a PivotTable. This tool enables you to summarize hundreds—or even hundreds of thousands—of records in a concise tabular format. You can then manipulate the layout of the table to see different views of your data. Because this ...
Get Microsoft Excel 2019 Formulas and Functions, First 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.
