In this video we're going to look at the top 25 advanced pivot table tips and tricks for Microsoft Excel. These tips are going to super charge your pivot tables!
Table of Contents
1. Use a Table for Your Source Data 0:09
2. Show Details Behind a Value 2:22
3. Delete The Source Data 3:11
4. Replace Blank Cells 4:08
5. Show Items with No Data 5:11
6. Group Text Fields 6:16
7. Group Number Fields Into Ranges 7:53
8. Group Date Fields Into Ranges 8:39
9. Automatically Refresh Data when Opening Your Workbook 10:02
10. Automatically Create a Pivot Table for each Item in a Filter 10:34
11. Allow Multiple Filters Per Field 12:05
12. Sort Items According to a Corresponding Value 14:00
13. Create a Custom Sort Order 14:45
14. Change the Layout 16:35
15. Repeat All Item Labels 17:34
16. Turn Off GETPIVOTDATA 18:17
17. Prevent Column Width Changing on Update 19:03
18. Add A Calculated Field 19:57
19. Create a PivotChart 21:03
20. Add a Slicer 22:15
21. Add a Timeline 23:05
22. Connect Slicers or Timelines to Multiple Pivot Tables 24:06
23. Filter on Top N Items 24:42
24. Add Multiple Subtotal Calculations 25:35
25. Show Value As 27:03 👇
Check out my full courses and ebooks here
👉 www.howtoexcel.org/courses/
DOWNLOAD the example workbook here
📖 www.howtoexcel.org/downloads/
SUBSCRIBE & get my 3 FREE eBooks
📧 www.howtoexcel.org/newsletter/
CONNECT with me on social
Facebook: / howtoexcelblog
Twitter: / howtoexcelblog
LinkedIn: / john-macdougall
Thanks for all your support!