14. Advanced Pivot Table Tips and Techniques
In This Chapter
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: Turn Pivot Tables into Hard Data
Tip 5: Fill the Empty Cells Left by Row Fields
Tip 6: Add a Rank Number Field to a Pivot Table
Tip 7: Reduce the Size of Pivot Table Reports
Tip 8: Create an Automatically Expanding Data Range
Tip 9: Compare Tables Using a Pivot Table
Tip 10: AutoFilter a Pivot Table
Tip 11: Force Two Number Formats in a Pivot Table
Tip 12: Create a Frequency Distribution with a Pivot Table
Tip 13: Use a Pivot Table to Explode a Data Set to Different Tabs
Get Excel® 2016 Pivot Table Data Crunching now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.