Excel 2013 Pivot Table Data Crunching

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 Your Pivot Table

Tip 7: Reduce the Size of Your 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: Transpose a Data Set with a Pivot Table

Tip 12: Force Two Number Formats in a Pivot Table

Tip 13: Create a Frequency Distribution with a Pivot Table

Tip 14: Use a Pivot Table to Explode ...