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 live online training, plus books, videos, and digital content from nearly 200 publishers.