Microsoft Excel 2013 Inside Out

Chapter 23. Analyzing data with PivotTable reports

• Introducing PivotTables

• Creating a PivotTable

• Rearranging PivotTable fields

• Refreshing a PivotTable

• Changing the numeric format of PivotTable data

• Choosing report layout options

• Formatting a PivotTable

• Displaying totals and subtotals

• Sorting PivotTable fields

• Filtering PivotTable fields

• Changing PivotTable calculations

• Grouping and ungrouping data

• Displaying the details behind a data value

• Creating PivotCharts

• Moving beyond PivotTables

A PIVOTTABLE report is a special kind of table that summarizes information from selected fields of a data source. The source can be a Microsoft Excel list or table, a relational database file, or an online analytical processing (OLAP) cube. When you create a PivotTable, you specify ...