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
great tutorial once again!
Very helpful, I will be sending everyone I know a link to this.
Very helpful… Thank you so much
really great tutorial !! loved it !!
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!
awesome
AWESOME. YOU MAKE IT SO EASY
Thank you so much! This was quick and to the point!
Thank you, Very useful and excellent explanation.
Thanks found this very helpful.
Precise, accurate, and to the point.
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.
Pingback: A Complete Introduction to Excel | MBAx.me
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.
thanks so much…..excel always terrified me….so this site is so so helpful….
Your tutorial videos are awesome!
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
Thank you so much for the positive feedback!
Brought a smile to my face
Thanks so much…now I understand!!
Great lessons on Excel – very grateful for your work Sir!
This was the best tutorial video I have ever seen. Thank you so much. You just get to the point. It is awesome.
This was Great! I’m learning a whole new side of excel. Keep up the good work.
Another great lesson in the comfort of my own home. Thank you, thank you, thank you.
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
Great tutor. Very Helpful. Short and Crisp…..
Very helpful,thanks!
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!
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.
you make it so easy….good job
Great lesson! Very easy to understand
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.
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!
Helpful!
Thanks,
Great stuff for a startup!
this is great – SLICE AND DICE BABY!!
THANK YOU SIR!
very helpful. I can’t wait for your advanced pivot table lesson!