Creating and managing PivotTables and PivotCharts

In this section, you will learn how to create a PivotTable using cell data and how to modify it using the field options and selections, as well as how to organize, summarize, and report data. In addition, we will create slicers and timelines and learn how to group PivotTable data. PivotCharts are also covered in this section as they are used to create graphical representations of PivotTables.

Creating a PivotTable

When creating a PivotTable, the data used to create the table remains as it is in the workbook—unchanged. A separate table is produced after creation where the data is manipulated to make it more understandable to the reader. There are a few things you should...