filmov
tv
10 ADVANCED PIVOT TABLE TRICKS that only PROS know about
Показать описание
In this video, we show 10 Advanced pivot table tricks that only pivot table experts know about. These advanced pivot table tricks will take your Excel pivot tables to the next level.
Download Example Files:
Watch Part 2: 10 more advanced pivot table tricks:
Learn Pivot tables in 10 minutes:
Introduction to Power Pivot and DAX:
GET 15% OFF my Excel PowerPivot for beginners Course. Use discount code YOUTUBE15 at checkout (Limited time offer!)
00:00 Introduction
00:24 Trick #1: Create a Calculated field in Pivot tables
02:13 Trick #2: Enable and disable showing details in Pivot tables
04:10 Trick #3: Connecting a slicer to multiple pivot tables
06:51 Trick #4: Creating Timelines
08:22 Trick #5 : YTD Calculations
10:11 Trick #6: Year over Year (YOY) Percentage difference calculation
12:41 Trick #7: Allowing multiple filters for a field
15:00 Trick #8: Creating TOP N Filters
15:55 Trick #9: Repeat Item Labels (For the whole Pivot Table and for individual fields)
18:05 Trick #10: Turn Off GETPIVOTDATA
19:05 Conclusion
Follow us on Social Media:
*****My online Excel Courses*****
#pivottable #pivot_table #pivottables
Download Example Files:
Watch Part 2: 10 more advanced pivot table tricks:
Learn Pivot tables in 10 minutes:
Introduction to Power Pivot and DAX:
GET 15% OFF my Excel PowerPivot for beginners Course. Use discount code YOUTUBE15 at checkout (Limited time offer!)
00:00 Introduction
00:24 Trick #1: Create a Calculated field in Pivot tables
02:13 Trick #2: Enable and disable showing details in Pivot tables
04:10 Trick #3: Connecting a slicer to multiple pivot tables
06:51 Trick #4: Creating Timelines
08:22 Trick #5 : YTD Calculations
10:11 Trick #6: Year over Year (YOY) Percentage difference calculation
12:41 Trick #7: Allowing multiple filters for a field
15:00 Trick #8: Creating TOP N Filters
15:55 Trick #9: Repeat Item Labels (For the whole Pivot Table and for individual fields)
18:05 Trick #10: Turn Off GETPIVOTDATA
19:05 Conclusion
Follow us on Social Media:
*****My online Excel Courses*****
#pivottable #pivot_table #pivottables
Комментарии