10 ADVANCED PIVOT TABLE TRICKS that only PROS know about

preview_player
Показать описание
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:

GET 15% OFF my Excel PowerPivot for beginners Course. Use discount code YOUTUBE15 at checkout (Limited time offer!)

ExcelBonanza
Автор

Fantastic video! It's definitely underrated by the algorithm.

nikosmakrymanolakis
Автор

Excellent content. I wish i had this video years ago. Please make a video about get pivot table functions.

ericrobbins
Автор

Thank u Abdel Rahman this is great video. Can u please add another tip about how to add at the bottom of tbe table the average and sum and max etc.

nadermounir