Advanced Pivot Tables Tips and Little known Secrets

If you have been using Pivot Tables for a long time...
and If you know Pivot Tables inside Out... then this Tutorial is for you.
In this tutorial I show you 10 Powerful little known Tips and Secrets about Pivot Tables.
You can jump to a specific topic by clicking on the timeline as follows:

Efficiency and File Size 01:58
Quick Explore 06:32
Flattened Pivot Table 08:26
Cache Problem 11:07
Dashboard with a Click 13:04
Fiscal Year 16:54
Multiple Subtotals 21:07
Quick Analysis 22:22
Undo Show Details 23:13
Slicer Drop List 24:24

I invite you to learn hundreds of Tips and Tricks to be the Next Pivot Tables Guru, by reading my Book
Pivot Tables
From Data... To Dashboard

It's available in 2 Formats:
Digital Online Version ► You can get it right now from the link

You will learn and follow along by downloading all the exercise files (link is in the Book)

You can explore the INCREDIBLE Table of Contents from the Link:

Happy Learning everyone!!

[IvanCortinas_ES]

Excellent tutorial Nabil. I especially appreciate the fiscal-year headland. Thank you!!!

[vadirajasharma]

So nice to watch your videos. Each one comes with great treasures

[wayneedmondson]

Hi Nabil. An awesome demonstration of 10 Advanced Pivot Table tips and secrets! I knew a few and learned a few. Thanks so much for sharing your knowledge and insight.. very much appreciated :)) Thumbs up!!

[saremammar]

You are the best Excel coach I ever met.
Thanks a million, Dr. Nabil ^_^

[axion]

Extraordinary! Your videos are at the top for those seeking sensible, real-world application of Excel. Wish I could give more than just this comment and a thumbs up to drive people to your channel. Many thanks.
P.S. It is extremely unfortunate to find that so many useful features (including Data Model and Power Query) are not available to the over 100, 000, 000 Mac users, including me! I will likely have to get a Windows machine because of this and I'm sure this is not wasted on Microsoft.

[Luciano_mp]

Wow, that's great, some tricks I didn't know about, these are great tips. It will help a lot, excellent work. Thank you so much Nabil!

[vijayarjunwadkar]

Super useful video Nabil! Thanks a lot for sharing your expertise through your channel. It has helped me a lot. Keep up the great work and stay blessed! 😊👍

[davidsyes]

Wow! You made 27 minutes FLY BY FAST!

Probably the fastest 27 minutes I've experienced.

[mirrrvelll]

Smooth, this video deserved Save in my Excel/Data folder list =) Thanks!

[YouExcelTutorials]

Great video Nabil 💪saw it at #EW7 but still watched it all over again. Thanks for sharing!

[mhdamoody]

Another awesome Video, salute to you Sir,

[uA]

hello, thanks for the information, query: how can I select in a drill down the number of columns that I want to show in the new sheet. If the base data has many columns, perhaps not all of them are of interest in a drill down, thank you very much in advance

[richardhay]

Your videos are great BUT there are only a couple of videos in the past year????