My Best 22 Pivot Tables Tips and Tricks - Master Pivot Tables
In this tutorial, I want to share with you, my Best 12 Tips and tricks in Pivot Tables. Along the way I will give you 10 extra bonus tips as well.
These Tips were carefully selected from my Book:
Pivot Tables from Data To Dashboard
############ 60% Discount ##############
You can get the book at 60% discount from the OfficeInstructor website, the link is here below:
https://officeinstructor.com/product/...
You can watch my tutorial► Unpivot Any Data either by Power Query or with a single Dynamic Array Function, by clicking on the link:
• Unpivot Any Data With A single Function
############ Book A Corporate Training ############
In Canada and Worldwide
https://officeinstructor.com/corporat...
############ Timeline ###########
Here is a list of tips and the start time on the timeline:
Tip # 01 ► Filtering The Value Fields 00:26
Bonus ► +/- Buttons 02:37
Tip # 02 ► Slicer Drop List 02:56
Bonus ► Filter Connection 05:11
Tip # 03 ► Multiple Subtotals 05:37
Bonus ► Field List Shortcut 06:50
Tip # 04 ► Sort by Typing Over 07:00
Bonus ► Merge Label Fields 09:20
Tip # 05 ► Repeat Single Field items 09:50
Tip # 06 ► Dynamic Conditional Formatting 11:00
Bonus ► Top/Bottom items Filter 15:06
Tip # 07 ► Unpivot Cross Tabulated List 15:40
Bonus ► Power Query vs Dynamic Arrays 17:28
Tip # 08 ► Stop Drill Down Feature 17:54
Tip # 09 ► Change the Default PT Layout 19:01
Bonus ► Field List Layout 20:10
Tip # 10 ► Different Fiscal Year 20:55
Bonus ► Refresh Pivot Table Shortcut 23:15
Tip # 11 ► Fiscal Year in November 23:30
Tip # 12 ► Relationships and Measure. 27:00