Microsoft Excel 2019 Pivot Table Data Crunching

Chapter 14Advanced pivot table tips and techniques

In this chapter, you will learn 21 pivot table tricks and techniques:

• Tip 1: Force pivot tables to refresh automatically

• Tip 2: Refresh all pivot tables in a workbook at the same time

• Tip 3: Sort data items in a unique order, not ascending or descending

• Tip 4: Use (or prevent using) a custom list for sorting your pivot table

• Tip 5: Use pivot table defaults to change the behavior of all future pivot tables

• Tip 6: Turn pivot tables into hard data

• Tip 7: Fill the empty cells left by row fields

• Tip 8: Add a rank number field to a pivot table

• Tip 9: Reduce the size of pivot table reports

• Tip 10: Create an automatically expanding data range

• Tip 11: Compare tables using a pivot table

• Tip 12: AutoFilter ...