Chapter 8: Analyze Data Dynamically with PivotTables and PivotCharts

There are different ways you can create pivot tables in Excel 2019. We will focus here on the different methods you can use to create pivot tables, including how to generate pivot charts from the pivoted data.

In this chapter, we will cover:

• How to create pivot tables with the Quick Analysis tool.
• How to create a Recommended PivotTable.
• How to create a pivot table manually.
• How to filter, sort and format pivot tables.
• How to create a pivot chart.

An Excel PivotTable is a powerful tool that enables you to dynamically calculate, summarise, and analyze data from different perspectives.

There are several methods for creating a new pivot table in Excel 2019:

• Quick Analysis tool : This option auto-generates a pivot table for you. When you select all the cells in your data list and click the Quick Analysis tool on the Tables tab, you get a list of pre-designed pivot tables for your data from which you can choose. When you select one, Excel inserts the pivot table in a new worksheet.
• Recommended PivotTables button : This option auto-generates a pivot table for you. When you select one cell in your data list and click on the Recommended PivotTables button on the Insert tab, you get a list of recommended pivot tables from which you can choose. When you select one, Excel inserts the pivot table in a new worksheet.
• PivotTable button : This option enables you to create a pivot table manually. When you select one cell in your data list and click on the PivotTable button on the Insert tab, Excel opens the Create PivotTable dialog box where you specify your data source and location of the pivot table before manually selecting the fields to use from the data.