HomeХобби и стильRelated VideosMore From: Jon Flynn

Microsoft Excel Pivot Table Tutorial for Beginners - Excel 2003, 2007, 2010

8764 ratings | 2228128 views
This is an introduction to using Pivot Tables (or PivotTables) in Microsoft Excel. It works in Excel 2003, 2007, 2010, and 2013.
Html code for embedding videos on your blog
Text Comments (479)
Eagle One (1 day ago)
I feel smarter lol thanks now I can interview
IThinkWithMy Dick (6 days ago)
Show me how to delete a pivot table in Excel 2000. Absolutely NONE of the advice online works for Excel 2000, as ALL the advice is for Excel 2007 & later.
An HOUR? It would take me a YEAR - and then I'd give up - to code my own filters!
3200trinity (24 days ago)
Thank you a very helpful video.
Charlene Garcia (26 days ago)
This was awesome... I was listening to another tutorial on Pivot Tables... On YouTube, but they ended up only showing Charts...... I ended up on part IV... Hoping that they would get to what I needed to learn... But that didn't happen. Thanks Again!
Kashif Raza (1 month ago)
Thankyou sir! #Respect
Limit Breaker Vegeta (1 month ago)
thanks!!! I was trying take the long route and then I saw you video in 2019.
Coke Dogg (1 month ago)
Great video. Not only did the “sort &filter” save me hours, this video just got me what would have taken a day to compile, an awesome report in four minutes.
Sahibdeep Singh (2 months ago)
Thiago Stulpen (2 months ago)
do you have this excel exercise to download?
Life Best (3 months ago)
Just came across this video..the best ever demo for a pivot table...thanks Man..I know am late but really appreciated.
Shane Shamuyarira (3 months ago)
hello jonny boy
Harry Bull (3 months ago)
hello jon
M J (3 months ago)
This is so helpful. Thank you, John.
Office 461 Gmail (3 months ago)
AWESOME HELP JOHN! The way you explained and demonstrated STEP BY STEP was just PERFECT. I reproduced it on my side and it now I know how it works! YOUR VIDEO WILL HELP ME GREATLY! Thanks again!! Take care! : )
Cameron Ramsay (3 months ago)
Still relevant in 2018 helped me in my business management degree in the U.K. thank you!
Carlo DLR (3 months ago)
Wow, you made it sound so easy! Thanks man
pratyay ganatra (4 months ago)
Helped me for my exams, thanks a lot
Allan Sam (4 months ago)
Please view these excel pivot table examples :https://www.youtube.com/watch?v=N50FhL8b4MU&list=PLnqHPqY2W3J_3vww-b0nnHFhXfozV8ZHJ
Oliver Sarnadeh Taylor (4 months ago)
thanks for the video; how can i get such a sample dataset to practice on?
Kevin Hanley Chong (5 months ago)
Can your data be across multiple sheets? or just 1?
Max Nejad (5 months ago)
Is there a way to get your spread sheet to practice on? Thanks
Mr Md Topu (5 months ago)
TruthFoot (5 months ago)
Dude, your the demo is nice and you seem to know how to use it, but you fail to explain what a PivotTable is succinctly. A PivotTable is automation summation tool that automatically creates summary views of data by summing and filtering data for you. A PivotTable relieves you from the need to write forumlas and maintain separate spreadsheets of summary views otherwise manually created.
Austin Duffield (6 months ago)
Very useful video thank you so much
Clive Madzikanda (6 months ago)
Thanks - very powerful tool
Unathi Silanda (7 months ago)
OMG, what I've been struggling with for hours I got right in 2 minutes. Thank you so much
rooftop princess (7 months ago)
thank you for this :) I was really worried to my buss.stat subject t i dont really understand it because my prof is to fast to teach. This is a big help :)
Richard Jones (7 months ago)
Great work done by you. It is really very helpful. Keep doing it. Thank you
sgmarshall3 (8 months ago)
Very helpful. Thank you
Marissa Williams (8 months ago)
This Was Super Easy To Learn, Thank You So Much!!!!!!!!!
f (8 months ago)
very informative video Jon!
MINA GH (8 months ago)
good info. thanks
Rabi Narayan (8 months ago)
I Thought marlon Brando is a gangster But he buys ......😂😂😂😂🤔🤔🤔
Alfa Won (9 months ago)
Thanks - Good refresher for advanced also
Ethel G. Rubio (9 months ago)
awesome! thank you!
Kim K (9 months ago)
Excellent excellent excellent!!
Marco Polo (9 months ago)
Hey, how can i add my own functions on the pivot table? Fro exaple to find a proce after taxes?
Penchal Bapana (9 months ago)
Really good job and this video will definitely useful. Thanks for great video and expecting that, will receive more useful videos from your side. Thanks
ankush sharma (9 months ago)
Good job thanks
Rakesh Verma (9 months ago)
Sir Your tutorial is valuable I like your video Please also help me to promote channel to grow link given below: https://www.youtube.com/c/excelclassestricks?sub_confirmation=1 Thank you #excelclasses
Patricia Werner (10 months ago)
Thank you so much!! Very helpful👍👍👍
J ABBASI (10 months ago)
Excellent, Thanks.
Excel Classes (10 months ago)
Sir Your way of teaching of too great I like your video Please also help my to promote channel to grow link given below: https://www.youtube.com/c/excelclassestricks?sub_confirmation=1 Thank you #excelclasses
Kreeky Blox (10 months ago)
Jefri Jamal (10 months ago)
Thank you so much for this!
NBS (10 months ago)
Pewlett Hackard?! LOL Nice Video Btw.
Juan Arias (11 months ago)
Tks for posting, helpful video.
Zuo Lifu (11 months ago)
quite clear, thank you!!
Thomas Samuelson (11 months ago)
Shivneel Kumar (11 months ago)
very helpful
Hamidur Rahman (11 months ago)
Good and easy presentation ):
F (11 months ago)
D XD (11 months ago)
Can you provide links to actual practive exercises one can practice? Tutorials are good but mean nothing without exercises. I'd apperciate it.
Maggie Blyth (11 months ago)
Great video, it was clear and exact on how to do things, thank you for sharing this it made my life so much easier
Sele Training (11 months ago)
Good work. Check out my quick pivot table in 30 seconds: https://youtu.be/05vXappumt8
Solve Tune (11 months ago)
#PivotTable শিখুন বাংলাতে প্রথম থেকে সঠিক ভাবে #SolveTune https://youtu.be/Kq4vZuNwYNg
Tarvinder Singh (11 months ago)
Great video. Very nice and clear!
Coconut & Mangosteen (1 year ago)
Thank you.
flubber27100 (1 year ago)
wow. still a great video tutorial for that mystifying pivot table scenario. easily explained. Thank you
Faisalnazir Khawaja (1 year ago)
thank you sir
Bisola Imam (1 year ago)
Hi thanks for this! So helpful. Did you say you had a second or more advanced videos delving more into Pivot tables? Where can I find it? Thanks so much.
wina rahayu (1 year ago)
thanks alot buddy
Bruce W (1 year ago)
How can I obtain the spreadsheet so I can do the exercises watching the video?
Lyse Tshims (1 year ago)
Excellent ! Thanks. Clear and simple
Shilpa Gupta (1 year ago)
Crisp and clear
Abhishek S (1 year ago)
Thank you Jon.
Meljorie Fabian (1 year ago)
Great VIdeo!! Thanks :D
gymtrainer310 (1 year ago)
"This could take months!".... : P At my pace, yes! LMAO! Thanks for a great video... made me smile and genuinely over my fear of PivotTables! #yeyyyme
Excel Pathshala (1 year ago)
Please check my you tube video to know all important feature available in pivot tables https://youtu.be/5ieWn-WJdfs
Thumbs up from me Jon good stuff
Basheer Ahamed (1 year ago)
Very Easily and god work sir
N World (1 year ago)
Selene Beltran (1 year ago)
Wow! I learned a lot!
Titus Massey (1 year ago)
Stop talking too much it made me angry so much
Faizan Faizy (1 year ago)
JOHN COYLE HERE (1 year ago)
Very good
navneet Kumar (1 year ago)
can u pls give the data used here, means pls provide the link to download the spreadsheet used in ur video
ripon mahmud (1 year ago)
I see you are a classic movie fan! Subscribed!
Tasmin de villiers (1 year ago)
Great crash course, Great video !!
Emma Waliczek (1 year ago)
Thank you very clear and I shall come back to this video! I had not really used pivot tables much before, so this will help me thank you :)
Michael Reynolds (1 year ago)
Thank you so much. I hadn't done a pt in years. Excellent tutorial
Why do you nerds always try to over explain shit. Just show how to do the pivot table. All you nerds have monotone voices and it gets really annoying listening to you try to explain shit that has nothing to do with how to actually complete the function. I ended up getting so annoyed by your stupid explanation I can no longer focus on pivot tables because i am only thinking of how much i wish something bad happens to you
Zoelis17 (1 year ago)
This is an awesome video! Great job!
Mandeep Goyal (1 year ago)
Thanks, This is very useful video.
william hutchinson (1 year ago)
Nice work, John. Thank you.
Leigh Lazarus (1 year ago)
Please can you help me? I have two lists of rental income from 2 different software. One list (paylease) is imported into the software of another (yardi). The problem is that they do not match and I have spent hours trying to find out what is missing or wrong and can't seem to find a way to simplify in EXCEL. I was able to compare the tenant numbers, but then when I reviewed the results I realized that there is often more than one allocation to the income so excel may pull the same number in more than once because they share the same tenant number. Is there a way to do this?
kevin jainarain (1 year ago)
wooo this is great didnt know this was this easy to do until i watcg this vidoe
Isaac Isaac (1 year ago)
Thank you !!!!!!!!
anthony bitmayl (1 year ago)
That was great, thank you!
Imtiaz Khan (1 year ago)
Excellent tutorial. Where can I download the data that you use to practice?
really very informative... can u post few more complex piovt table....
Vipin Rahul (1 year ago)
Warren S. (1 year ago)
Excellent tutorial, much appreciated!
Brad Morgan (1 year ago)
Very helpful video. Short and to the point. Thank you!
UMAR FARUK (1 year ago)
My life saver. Thankyou Jon for this great video. 1
Eyo Z (1 year ago)
Perfect, well explained and concise. Thanks.
Swigitty Swooty (1 year ago)
7 Min of watching and Im no longer think that pivot is scary and complicated. Fuck me this video is so good.
Nathaniel Paz (1 year ago)
Very helpful video. Thanks Jon!!

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.