12 Pivot Tables Secrets for Advanced Excel Users

If you think you know everything about the methods and sources for creating Pivot Tables, then please, watch this video and think again.
In this tutorial I show you 12 methods and Sources for creating Pivot tables from basic to mind blowing.
So, let's dive in.

I encourage you to watch my Free Course "Pivot Tables for Beginners" before watching this one by following the link:

When dealing with Pivot Tables, you should be very familiar with the differences in functionality between "Lists and Tables" in Excel, and here is your one stop shop for learning all the details along with many tips and tricks. Just click on the link here below:

For this Advanced Tutorial on 12 Secrets and methods for creating Pivot tables, you can download the Exercise File and follow along by clicking on this Link:
Coming Soon

You can Preorder my new Book
"Pivot Tables …From Data to Dashboard"
which will be available in Paperback format (on Amazon) or Digital Version on the OfficeInstructor website.
This book of 400 pages is the most comprehensive guide for learning Pivot Tables from basics to Power User level, including Data Model, Power Query, Dynamic Arrays, VBA, and Dashboard secrets.
Preorder Now and get a 60% Discount as a very limited time introductory offer.
Click below to Preorder:

Music Credit:

[jimfitch]

Another fantastic video, Nabil. Comprehensive, well-explained, excellent illustrations, perfectly paced. I knew many of the techniques you describe, but certainly not all. It’s always such a gem to “discover” the capabilities that are right there in plain view, but obscured by past habits such as overlooking them. Thanks!

[ifqytcl]

many thanks Mr. Nabil for very useful information

[dhananjaypinjan]

Very well explained.. Thanks for Mr. Nabil!!!

[spilledgraphics]

Wow....you always learn something new = Ctrl + Q to open up the Quick Analysis window! awesome Nabil ! 🚀🚀

[nadermounir]

Thank you Nabil for this wonderful video 📹 👍

[loidaasar]

Hello, i am an avid follower of all your works.

[IvanCortinas_ES]

Another powerful tutorial. Deep, professional and didactic. It will make you improve in your daily work. Thank you again Nabil, for another gift!

[vadirajasharma]

so nice the video and its contents. Really amazing Nabil Sir

[suecampanelli]

Always insightful whether you are an advanced or novice Excel user! Looking forward to pre-ordering your new book!

[vijayarjunwadkar]

Amazing video Nabil! Excel is evolving and sometimes it is difficult to catch up, but thanks to you for your passion and easy to follow tutorials which makes it simple. Looking forward for more! Keep doing the great work! 😊👍

[wayneedmondson]

Hi Nabil. Great lesson! Lots of good tips and tricks there. Thanks for sharing your knowledge :)) Thumbs up!!

[Saad.PS]

شرح واضح ومميز جدا وفقك
معلومات مفيدة جدا
بارك الله فيك وجزاك الله خير الجزاء

[chandramohan]

SIr Pl make videos on POwer pivot from basic to Advanced. thank yu

[pnagarajkumarbe]

Nicely presented. Can you please name the software you used for creating this videos.

[shoppersdream]

Thank you! Very Nice! At 7:37 time of your video, when we click on the down arrow under Pivot Table, I see 4 options in your case and the last option is From Power BI. I have only the top 3 options. How do you have the 4th one? Is it because you have paid version of BI? My From Data Model Option is also Grayed out. Are we supposed to check the box for Add it to Data Model and then it will become active? Thanks

[ubaidillahmuhammad]

Nice and good job. Put excel practiced files in the description.

[EnkhturDamdinjav]

wtf so many adds and slowplay for this