Excel 2016 Tips and Tricks

Lesson 4 - C REATING /R EVISING P IVOT T ABLES This lesson covers the following objectives:

Recommended PivotTables Creating a PivotTable Report

Adding PivotTable Report Fields Search for PivotTable Report Field Selecting a Report Filter Field Item

Refreshing a PivotTable Report Changing the Summary Function Adding New Fields to a PivotTable Report Moving PivotTable Report Fields Using Expand and Collapse Buttons Hiding/Unhiding PivotTable Report Items Deleting PivotTable Report Fields Creating Report Filter Pages Formatting a PivotTable Report Creating Slicers Filtering with Slicers Editing a Slicer Using Multi-Select Slicers Creating a PivotChart Report Exercise