Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365)

CHAPTER 14. Advanced pivot table tips and techniques

In this chapter, you will learn 23 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 ...