Tip 1: Force pivot tables to refresh automaticallyTip 2: Refresh all pivot tables in a workbook at the same timeTip 3: Sort data items in a unique order, not ascending or descendingTip 4: Using (or prevent using) a custom list for sorting your pivot tableTip 5: Use pivot table defaults to change the behavior of all future pivot tablesTip 6: Turn pivot tables into hard dataTip 7: Fill the empty cells left by row fieldsTip 8: Add a rank number field to a pivot tableTip 9: Reduce the size of pivot table reportsTip 10: Create an automatically expanding data rangeTip 11: Compare tables using a pivot tableTip 12: AutoFilter a pivot tableTip 13: Force two number formats in a pivot tableTip 14: Format individual values in a pivot tableTip 15: Format sections of a pivot tableTip 16: Create a frequency distribution with a pivot tableTip 17: Use a pivot table to explode a data set to different tabsTip 18: Apply restrictions on pivot tables and pivot fieldsTip 19: Use a pivot table to explode a data set to different workbooksTip 20: Use percentage change from previous for year-over-yearTip 21: Do a two-way VLOOKUP with Power QueryTip 22: Slicer to control data from two different data setsTip 23: Format your slicersNext steps