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.

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!

This entry was posted in Data Input & Manipulation and tagged , , , , , . Bookmark the permalink.

67 Responses to Video Lesson: Advanced Pivot Tables – Round 1

  1. Anonymous says:

    Thank you so much Ben. It’s really useful.

  2. Mamadou says:

    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 😉

  3. Anonymous says:

    thankyou 🙂

  4. Sreenu says:

    Well explained

  5. Anonymous says:

    such a great site for everything. thank you

  6. Anonymous says:

    Great tutorial!
    Thank you very much!

  7. Anonymous says:

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

  8. Anonymous says:

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

  9. Fatema says:

    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.

  10. Anonymous says:

    Thank you for sharing 🙂

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

  12. chandrasekaran says:

    I really appreciate your sharing of your knowledge

  13. Anonymous says:

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

  14. Anonymous says:

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

  15. Anonymous says:

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

  16. Anonymous says:

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

  17. Anonymous says:

    Excellent, Thank you

  18. Anonymous says:

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

  19. Bib says:

    Bro this is amazing! So simple yet so much information

  20. Linnetie Mugore says:

    really useful, easy to follow

  21. Donmelo says:

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

  22. Anonymous says:

    So straight to point and much easier thank you.

  23. Anonymous says:

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

  24. Anonymous says:

    Simple and to the point….awesome

  25. Lucy Hollings says:

    Excellent stuff, many thanks for your help

  26. Vineet (India) says:

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

  27. Anonymous says:


  28. alexdickey says:

    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.

  29. Hareesh Kumar Kurapati says:

    Session is marvelous

  30. nunh says:

    Excellent – I am a fan – thank you!

  31. Anonymous says:


  32. Mirela says:

    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?

  33. Anonymous says:

    Brilliant and easy to understand – thank you for sharing

  34. Lovelock says:

    Extremely useful. Very plain and fluid explanation.

    Thanks for sharing

  35. Tracy says:

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

  36. Van says:

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

  37. Rachel says:

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

  38. Anonymous says:


  39. yingyu says:

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

  40. Anonymous says:

    great explanation!! u rock !!

  41. Greg says:

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

  42. Anonymous says:

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

  43. Lindy says:

    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!

  44. Anonymous says:

    Thanks. It is very useful.

  45. Anonymous says:

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

  46. Jessica Marie says:

    Great review, thank you!

  47. Lillian Perez says:

    Very helpful…

  48. Mency says:

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

  49. Anonymous says:

    Really good and easily explained

  50. Adam Petru says:

    Great tutorial!!
    Thank you!!

  51. delta says:

    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.

  52. Shan says:

    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.

  53. Sherry says:

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

  54. Anonymous says:

    Very helpful! Thank you!

  55. KosherDog says:

    This increases the functionality exponentially!

  56. KosherDog says:

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

  57. Anonymous says:

    Amazing….Thanks for sharing this…Very informative!

  58. Anonymous says:

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

  59. Satha says:

    Great job – Thanks.

  60. LouiseMaria says:

    Excellent. Thank you!

  61. olena says:

    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!

  62. Curly says:

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

  63. deepak kr kanodia says:


  64. DarlingBubbly says:

    This is fantastic, thank you.

Comments are closed.