Pivot Tables are extremely useful in Excel. This Advanced Excel video lesson is a follow-up to the Introduction to Pivot Tables and covers the first round of advanced topics.

The lesson goes over some additional Pivot Table options and features including:

– Drill-down functionality which creates a summary sheet of any Pivot Table amount selected.

– Pivot Table Options including show/hide totals, error/empty cell display options, and refresh when opening workbook (and more).

– Value calculation options including sum/count/average, % of grand total, and % of parent row / parent column total.

– Formatting / display options including row/column label layout, sorting labels, and other formatting.

As always, download the latest version of the **Master Workbook** to follow along at home.

**Feel like you’re starting to master the Pivot Table? Move on to Advanced Pivot Tables – Round 2 to continue learning more!**

### Like this:

Like Loading...

*Related*

Well explained

such a great site for everything. thank you

Great tutorial!

Thank you very much!

Hey mate, this is really good! the best excel lessons i have found – keep on this way!

Thank you for sharing your knowledge in Excel. Good karma to you !

This is amazing. I can’t thank you enough for posting your knowledge online. I’m so glad to find this website to refresh my excel skills. Excellent explanation with very good demonstration – very easy to follow.

Thank you for sharing 🙂

Thank you for sharing your skills this and stay sharp.

I really appreciate your sharing of your knowledge

Thank you for sharing your skills good karma to you!

Agreed on some of the comments that this is a really good tutorial.

hi..!

And your lessons are really awesome i really like that , thanks to you and to your videos.

I really appreciate your sharing of your knowledge. God bless you!!!!

Thank you for sharing your knowledge, Ben. I really enjoyed watching your video and learning Excel at my own pace. God Bless!

Excellent, Thank you

Amazingly clear and easy to follow along with. After 3 short pivot table videos I feel like a pro 🙂

Bro this is amazing! So simple yet so much information

really useful, easy to follow

This is great! I had forgotten about the use of pivot tables but the lesson was simple and on target. Way to go!

So straight to point and much easier thank you.

Dude you are awesome! Videos are great and I really starting to love excel. Thank you!

Simple and to the point….awesome

Excellent stuff, many thanks for your help

Hi, Just watched and listened and practised this session at same time. Very uselful. Thanks!

excellent

Does anyone know how to access the “Layout & Print” tab found in “Field Settings”—or its equivalent—when using Excel on a Mac? The information shown here as being in the “Subtotals & Filters” tab shows up, but there’s no Layout & Print tab.

Session is marvelous

Excellent – I am a fan – thank you!

THANKS FOR ALL

Great lessons! You are indispensable! Your explanations are very precise and clear!

In the formatting options in 6″ though I can not drag down the Employee to the Row label- it gives me a message that a pivot table can not overlap another pivot table. Any idea what I’m doing wrong?

Brilliant and easy to understand – thank you for sharing

Extremely useful. Very plain and fluid explanation.

Thanks for sharing

Clear instruction and great information..Thank you for your time and effort! This as very helpful in preparing me for an important interview that requires pivot tables..

it’s very useful and amazing. Thanks for construction!

It is awesome. Thanks so much, Ben. It is really helpful, the best excel lesson ever.

thanks!

amazing!!!! this is my first time knowing, how can go detail of pivot table! thanks 🙂

great explanation!! u rock !!

Many thanks! I learned a bit more… Now for the really advanced section!!

I just want to say you are making my life easy. awesome, interesting, and not boring. I am learning a lot.

Another informative, straight to the point lesson! I’ve been using pivot table for over 4 years and I still learn few additional features from your 6 mins lesson. Olea’s suggestion is quite good in taking pivot table to the next level.

Again Thank you!

Thanks. It is very useful.

Excellent content, very well detailed explantions of each step and so helpful

Great review, thank you!

Very helpful…

Thanks very much…all these will really help a lot in my career!! God bless you!

Really good and easily explained

Great tutorial!!

Thank you!!

Man you are good. I never heard of pivot table before but you thought me in less than 5 minutes.

Please post more videos. Thanks a lot.

Great work. Very useful…Thanks a lot. Please upload videos on importing data from various sources and some financial functions like Multiple regression, trend line, Statistics.

Thank you so much, U R super! Love them all.

Very helpful! Thank you!

This increases the functionality exponentially!

This is CRAZY good! Watching for a second time. And, putting it to use immediately!

Thank you so much!

Amazing….Thanks for sharing this…Very informative!

This is simply Superb. Thanks a lot for sharing your knowledge.

Great job – Thanks.

Excellent. Thank you!

This is really great and practical! Many jobs are required knowledge of Excel and pivot tables. I wish all your lessons were connected in some sort of a project i.e load data from different sources and make the reports applying conditions, formatting, pivot tables etc. Also, more exercises would be helpful! Thanks again!

This is a great idea and I will try to think of a good way to incorporate a similar concept in the future.

Glad you enjoyed it!

You are AMAZING at what you DO. Thank you so much for the Excel help, it was NEEDED.

BEST SITE EVER SEEN FOR EXCEL TUTORIAL….IN SIMPLE LANGUAGE AND VERY EASY TO UNDERSTAND

This is fantastic, thank you.