# Video Lesson: Advanced Pivot Tables – Round 1

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.

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

## 66 thoughts on “Video Lesson: Advanced Pivot Tables – Round 1”

1. Amazing Ben! this is just so useful. You are awesome ad thanks so much for sharing these videos, I’m going to be an advanced excel user 😉

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

3. 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.

4. Thank you for sharing your skills this and stay sharp.

• Thank you for sharing your skills good karma to you!

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

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

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

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

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

10. 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.

11. Session is marvelous

12. 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?

13. Extremely useful. Very plain and fluid explanation.

Thanks for sharing

14. 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..

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

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

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

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

19. 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!

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

21. Great review, thank you!

22. 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.

23. 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.

24. This is CRAZY good! Watching for a second time. And, putting it to use immediately!
Thank you so much!

25. 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.