Video Lesson: Introduction to Pivot Tables

Pivot Tables are an extremely useful way of analyzing large sets of data quickly and easily in Excel.

This video lesson provides a beginner’s introduction to Pivot Tables.

Download the most recent Master Excel Workbook to follow along.

Now that you know the basics, it’s time to get your hands dirty with Advanced Pivot Tables – Round 1

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

70 Responses to Video Lesson: Introduction to Pivot Tables

  1. Anonymous says:

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

  2. Pingback: 8 tricks to boost Excel productivity | Resultize

  3. Jason says:

    Very helpful, thanks

  4. Carolyn says:

    Awesome stuff!! Thank you so much! (:

  5. kim says:

    this is great…but, how do i make a data table to begin with? I have inputted the information and went to ‘insert tab’ and the ‘what if analysis’ to choose data table…but when I get to row input cell…etc, i don’t know what to type in there.

  6. wendycroft says:

    Thank you for making this available to us for free. It’s really helping me out.

  7. Anonymous says:

    excellent of stationery and helpful

  8. Anonymous says:

    When I go to add a filter for employees, I get an error saying “We can’t do that to a merged cell”. I am using Excel 16 and haven’t edited your worksheet at all. I’ve tried unmerging cells in both the 6-Pivot 1 and 5 – Pivot Data (example 1) tables.

    • Anonymous says:

      Nevermind, I did change your sheet by deleting the pivot table and starting it over. The problem was putting the pivot table in B3 instead of B4 like in the video, resulting in Excel wanting to put the filter in the “Back to Table of Contents” cell.


  9. afiyin fambegbe says:

    great video, this is irrelevant but which platform do you use to edit your videos

  10. Anonymous says:

    Thank you so much!!!!!!!!!!!!!!!! That really helped

  11. Anonymous says:

    Thanks for these awesome lessons!!!

  12. cj cook says:

    would it be feasible to use something other than Vimeo. It halts a lot and have to restart it often.

  13. kaushik says:

    how can i overlap new pivot table within old pivot table… if

  14. Ben says:

    Hey, when I try to put in a ‘Report Filter’ it comes up with an error saying “A PivotTable report cannot overlap another PivotTable Report.”

  15. Anonymous says:

    Excellent stuff, very helpful!

  16. Anonymous says:

    Thank You ….Very Good…

  17. Anonymous says:

    Good stuff thanks!

  18. Anonymous says:

    Unless I am missing something I get an error that states “A PivotTable report cannot overlap another PivotTable Report.” I am one minute into the video I triple checked the steps, but I am still getting the error. I don”t know if you know what it is stating or if you could reproduce it to see what the issue is.

    Thank you though these video are great and I will continue to use them. Ill just have to skip this one for now.

    • Anonymous says:

      Same Guy, never mind I am an idiot, but of course you already knew that.

      On the 6th sheet in the Master Excel Workbook you have a table and in the video I was selecting the same row and column (B3) as you which had a table in it. So I just clicked an empty area and voila it worked.

      My apologies

  19. Anonymous says:

    Very clear and helpful lesson, thanks.

  20. chris says:

    This lesson is very useful and easy to understand. Thank you

  21. Anonymous says:

    Excellent Tutorial. Very helpful. Thanks

  22. Anonymous says:

    Very useful course as I prepare for an actuarial internship: thank you!!

  23. ashutosh says:

    Hi Ben,
    This is very helpful
    one more request can wehave a single link for all the available lessons so that we can download it once and learn at our own pace?

  24. Anonymous says:

    Thank you so much! very helpful and easy to learn

  25. Anonymous says:

    This was very helpful. My first lesson in Pivot Tables and Wow! Looking forward to more advanced lessons.

  26. Bingo says:

    Hey !A great introduction to Pivot tables but i guess this video is not playing properly now…didn’t got the full lesson:(

  27. Humphrey Gachanja says:

    Great lesson; and very helpful. Thank you.

  28. SuzieQ says:

    This is another lesson that is not working.

  29. Anonymous says:

    Thank you so much for great lesson !

  30. Anonymous says:

    great tutorial once again!

  31. Jo Morrison says:

    Very helpful, I will be sending everyone I know a link to this.

  32. Anonymous says:

    Very helpful… Thank you so much

  33. Anonymous says:

    really great tutorial !! loved it !!

  34. Greg says:

    Many thanks indeed! I have used Pivot tables before, but never really understood the four “boxes” at the bottom of the item list …. Now I do!

  35. Anonymous says:


  36. Anonymous says:


  37. Anonymous says:

    Thank you so much! This was quick and to the point!

  38. Anonymous says:

    Thank you, Very useful and excellent explanation.

  39. Anonymous says:

    Thanks found this very helpful.

  40. Chris says:

    Precise, accurate, and to the point.

  41. LIllian Perez says:

    This courses have helped me so much! The flexibility to go over course over and over again, is ideal for me. I’ve played the same video a number of times just so I can practice and remember the lesson. This is something you don’t get in a classroom. You get the class and if you got it okay, if not, then too bad. The instructor is extremely easy to understand, he explains and demonstrates. Very, very, very good.

  42. Pingback: A Complete Introduction to Excel |

  43. Phillip says:

    Page 6 Isn’t blank like in the video. It has a data table already input and this is with the latest version from January 11, 2013. Just f.y.i.

  44. anything says:

    thanks so much…..excel always terrified me….so this site is so so helpful….

  45. Anonymous says:

    Your tutorial videos are awesome!

  46. Anonymous says:

    Thank you very much – very helpful and will be going through each of your lessons. You have great speaking tone and most importantly, you care!!! Thanks so much for doing this

  47. Albert says:

    Thanks so much…now I understand!!

  48. Great lessons on Excel – very grateful for your work Sir!

  49. delta says:

    This was the best tutorial video I have ever seen. Thank you so much. You just get to the point. It is awesome.

  50. Anonymous says:

    This was Great! I’m learning a whole new side of excel. Keep up the good work.

  51. Anonymous says:

    Another great lesson in the comfort of my own home. Thank you, thank you, thank you.

  52. Linda says:

    Thank you so much.. i now some what understand it. My worksheet did not work like the tutorial.. but I still received some information. I do have a better understanding.
    thank you again

  53. Shan says:

    Great tutor. Very Helpful. Short and Crisp…..

  54. Anonymous says:

    Very helpful,thanks!

  55. KosherDog says:

    You taught me more in 2 minutes and 50 seconds than I have been able to figure out in hours of classes and years of beating my head against the wall. Thank you for revealing the obvious clearly and beautifully! Wow! Thank you!

  56. Anonymous says:

    Great lesson. I’m going in for an interview as an analyst tomorrow and I’ve had multiple phone screenings that all asked if I knew Pivot Tables in Excel – needless to say, tomorrow I can say yes. I appreciate you taking to time to teach this for free.

  57. Anonymous says:

    you make it so easy….good job

  58. Anonymous says:

    Great lesson! Very easy to understand 🙂

  59. Linda says:

    Excellent lesson! Thank you so much for providing this; I’ve been trying to figure out how to use Pivot Tables in my work, and this was a great intro so that I can get an idea of what I could do with it.

  60. Anonymous says:

    Loved the lesson. It was simple, clear and easy to duplicate. I had never used pivot table. I was totalling everything the hard way which was very time consuming. After watching the video, I went to one of my spreadsheets, inserted a pivot table and the results were calculated within seconds. Amazing. This will be a great tool for me in Human Resources!

  61. Anonymous says:


  62. Anonymous says:

    Great stuff for a startup!

  63. Anonymous says:

    this is great – SLICE AND DICE BABY!!

  64. defrew says:


  65. Lin says:

    very helpful. I can’t wait for your advanced pivot table lesson!

Leave a Reply