HomeХобби и стильRelated VideosMore From: Excel Campus - Jon

Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)

33635 ratings | 6108682 views
WATCH PART 2: https://www.youtube.com/watch?v=g530cnFfk8Y Download file used in the video: http://www.excelcampus.com/pivot-table-checklist-yt In this video series you will learn how to create an interactive dashboard using Pivot Tables and Pivot Charts. Works with Excel 2003, 2007, 2010, 2013 for Windows & Excel 2011 for Mac Don't worry if you have never created a Pivot Table before, I cover the basics of formatting your source data and creating your first Pivot Table as well. You will also get to see an add-in I developed named PivotPal that makes it easier to work with some aspects of Pivot Tables. Download the files to follow along at the following link. http://www.excelcampus.com/pivot-table-checklist-yt I have another video that shows how to reformat the pivot chart in Excel 2010. In the video above I'm using Excel 2013 and the menus are different from Excel 2007/2010. Here is the link to that video. http://www.youtube.com/watch?v=Jt_QqG-vRRw Get PivotPal: http://www.excelcampus.com/pivotpal Free webinar on The 5 Secrets to Understanding Pivot Tables: https://www.excelcampus.com/pivot-webinar-yt Subscribe to my free newsletter: http://www.excelcampus.com/newsletter
Html code for embedding videos on your blog
Text Comments (2211)
Dinah Catli (1 hour ago)
VERY informative
Martins Major (2 days ago)
Thanks so much
Tom Boerstra (2 days ago)
Pivot Tables are such a massive turn on, honestly.
thisisbob1001 (3 days ago)
You say not to use blank rows or columns but your example download has these in an I cannot create a pivot. What are you meant to do first before you can create a pivot?
Peter Parker (4 days ago)
Hello great tutorial.  How do you add a total sales amount on the graph that you created?  Maybe add the info on the right upper corner or anywhere where it shows the total for all salesperson.  thank you
Very very good! I had forgotten how to use Pivot and your tutorial helped to refresh my knowledge. Your video is the best and easiest to understand so far! Thank you!
Wayne Baird (4 days ago)
This was one of the best tutorials I could find on the introduction to Pivot Tables. Thank you very much!
Akhtar Islam (5 days ago)
That's very good. I love it so much
Joe Swaney (6 days ago)
Stellar video. Thank you.
Alex K (6 days ago)
Useful video for beginners. Thanks
Mahamed salmaan (6 days ago)
Thanks for your help I've watched this awesome video so many times. before now I didn't know what is pivot tables? how does it work? how to differentiate a source of data? how to create beautiful charts? how to build dashboards? and so on so far but now I've more and accurate information/enough information about this. Many thanks for your help.
John Pastore (6 days ago)
Great Video!
fel kif (7 days ago)
Fantastic tutor! Jesus bless you.
Allan Sam (8 days ago)
Kindly view our pivot table examples here : https://www.youtube.com/watch?v=N50FhL8b4MU&list=PLnqHPqY2W3J_3vww-b0nnHFhXfozV8ZHJ
Dorla Grant (8 days ago)
Thanks much.
swapna chamathakundil (9 days ago)
Superb... Thanks a lot
Harald Henrichsen (11 days ago)
Thanks for a good intruduction.
Patricia Osborn (11 days ago)
Great refresher!
Julie Lukehart (11 days ago)
Can you explain how to create a living Pivot table. This shows how to create one from past data what about if we keep making changes to the source data.
Member information (11 days ago)
Matthew 28: 19-20 Go ye therefore, and teach all nations, baptizing them in the name of the Father, and of the Son, and of the Holy Ghost: Teaching them to observe all things whatsoever I have commanded you: and, I am with you always, even unto the end of the world. Amen.
Charles Layton (12 days ago)
Very Helpful!
Mohammed Suleiman (15 days ago)
I am highly elated at your lessons but please how would you do me a favour of downloading your tutorial manuals? Thanks.
Manuel Garza (19 days ago)
Good refresher, amazing what you forget when you no longer use the tools. Thank you and Andy for putting this together.
Lavinia Casas (19 days ago)
Thank you very much for sharing the info,
Platinum Swords (23 days ago)
Was just given a project at work that uses Pivot Tables and it's the first time I've ever used it (nobody else in the office knows how to use it either). This video is like Godsend! Thank you for this!
Excel Campus - Jon (20 days ago)
Thanks so much! Happy to hear you are learning pivot tables and hopefully you can teach the others in the office too. :-)
Lothar Scholz (24 days ago)
Why is nobody giving a more theoretical description of a pivot table. I like maths and then Excel is just the GUI. I find the theory first way way better then clicking stuff where i don't know what is done.
Excel Campus - Jon (20 days ago)
Hi Lothar, I do have a free webinar that goes into more detail on how pivot tables work. It's really about understanding the structure of the source data, and how the pivot table does grouping and calculations on the fields. Here is a link to the webinar, if you want to check it out. https://www.excelcampus.com/pivot-secrets-webinar I hope that helps.
Best07 Best07 (24 days ago)
telefondan süper bitcoin kazanma sistemi. https://www.pivot.one/app/invite_login?inviteCode=dfpbfc
Stanley (25 days ago)
So helpful. Much appreciated.
Excel Campus - Jon (20 days ago)
Thank you Stanley! :-)
Belinda Valencia (25 days ago)
in my job, there's a need for me to create and maintain Pivot tables and Dash Boards. This is a great start on my road to Pivot table expertise. Great instructional video!!
Excel Campus - Jon (20 days ago)
Thank you Belinda! :-)
Sahil Bhatia (25 days ago)
Highly Appreciable Nicely explained Best of luck !
ljbonner (27 days ago)
Excellent. Great tutorial. Thanks.
Maqueeh Diaz (28 days ago)
Thank you so much...I learned a lot...
chiko mutandwa (28 days ago)
Thanks you very much this really helped me i have learnt a lot
Zeljko Djerek (29 days ago)
Hi, when creating the first pivot table (3,30'' onward) you skipped to explain last row: "Choose whether you want to analyze multiple tables ... also, is there any automatic option to update and extend source data (f. e. if we use data from the web)
Excel Campus - Jon (20 days ago)
Hi Zeljko, Great questions! Here are my answers. 1. The "Add this data to the data model" option under "analyze multiple pivot tables" allows us to use PowerPivot to do more advanced calculations. It also allows us to create relationships between data sources to produce pivot tables based on multiple data sets. Here is an article on PowerPivot I have that explains more. https://www.excelcampus.com/pivot-tables/powerpivot-instead-vlookup/ 2. There are a few ways to automatically update pivot tables. We can use a setting in the pivot table options to update the pivot tables when the file is opened. We can also use a simple macro to refresh the pivot tables whenever the source data changes. Here is video that explains more about those options. https://www.youtube.com/watch?v=NI1UQcYtl1A 3. You can use Power Query to pull data into Excel from the web. Here is an article on Power Query. https://www.excelcampus.com/powerquery/power-query-overview/ The data is output into an Excel Table. We can then use the Excel Table as the source of the pivot table, so that any new rows are AUTOMATICALLY included in the pivot table. Here is an article that explains 5 reasons to use Excel Tables for the source of a pivot table. https://www.excelcampus.com/pivot-tables/table-source-pivot-table/ I hope that helps. Thanks again and have a nice day! :-)
Ismael Guerrero (30 days ago)
Nice presentation very understandable
mohsen bafti (30 days ago)
Register PIVOT to get BTC Bonus yon.ir/tJaY8
Diane M (1 month ago)
I think this was the best and most comprehensive training on Pivot Tables I've seen so far.  Thank you.
Millati Azka (1 month ago)
hello Jon, do you have pivot exercise for me as a homework?
Excel Campus - Jon (20 days ago)
Great suggestion! I'll put something together for this. We do have a ton of sample files and article on our downloads page. Here is the link. https://www.excelcampus.com/tools/ I hope that helps.
artemisxbow (1 month ago)
Thanks for the video and thorough explanations.
Tamim Shams (1 month ago)
Thank you, it was very helpful!
Lahiru Sampath (1 month ago)
thanks.great video
Marina Tuffier (1 month ago)
i quiet enjoyed listening to it and you are good at explaining. You start with the basic and quickly depart from it, so we have no choice but to agree that the more you explore and use what is available, the more of an asset you become to your employer. Learning made easy...
Excel Campus - Jon (20 days ago)
Yes! I love the way you phrase that Marina! Thanks so much for your support. :-)
Cosmicslop 12 (1 month ago)
Great video thanks
Max Nejad (1 month ago)
Is there a way to get the spread sheet to practice? Thanks Jon
Karen Jamai (1 month ago)
This is wonderful. Makes it easy to understand.
Basem Elgamal (1 month ago)
Thank you
Mohammad Ali (1 month ago)
for excel file : https://www.excelcampus.com/charts/pivot-tables-dashboards-part-1/
Hunny Bunny (1 month ago)
This is awesome
Spymooping Ovaltine (1 month ago)
Thank you very much! This was very helpful; very well-executed intro and instructions. I’m working on quantitative analysis for my research, I’ll definitely give Pivotpal a try.
Excel Campus - Jon (20 days ago)
Thanks so much Spymooping! :-)
Myrna Suyan (1 month ago)
Thank you so much 😊♥️
Myrna Suyan (1 month ago)
Thank you so much 😊♥️
Zainabu Emamu (1 month ago)
Nice presentation,very useful
Roger R (1 month ago)
Excellent presentation.Thank you.
Paula Warner (1 month ago)
Thank you for the great tutorial, it has been very helpful! I have a fairly large data set that has labels horizontally across the top as well as vertically along the left column. Can I manipulate this data through a pivot table, or do they only work with one horizontal label row?
Excel Campus - Jon (20 days ago)
Hi Paula, Thanks for the nice feedback, and great question! You will most likely want to unpivot this data first. I have a free webinar that explains more about the structure and layout of the source data. Here is a link to register. https://www.excelcampus.com/pivot-secrets-webinar I also have a blog post that covers some of the basics as well. Here is a link to that. https://www.excelcampus.com/modeling/structure-pivot-table-source-data/ I hope that helps. Thanks again and have a nice day! :-)
Mustafa Akçok (1 month ago)
Thank you very much for your contribution. This video is consice, to the point and comprehensive...
Excel Campus - Jon (20 days ago)
Thank you Mustafa! :-)
Nathan Bieber (1 month ago)
great teaching style! thank you this helped a ton!
Excel Campus - Jon (20 days ago)
Awesome! Thanks Nathan! :-)
Sarah Ahmadi (1 month ago)
It was really great and very well explained and shown. Thank you very much. I am starting a new job and I need to know how to use pivot tables and to be honest I was so stressed. Now that I watched this video of yours I feel a bit confident that I can learn it quickly and its not scary as you said. Thank you
Excel Campus - Jon (20 days ago)
Thanks so much Sarah! And congrats on the new job! I'm happy to hear you are feeling more confident with Excel. It definitely gets easier with practice as well, and I know you are going to do great. Thanks again! :-)
ekumi boris (1 month ago)
Thanks, sir
Eduard Galustov (1 month ago)
Thank you Jon, great videos, helped me a lot!!
Excel Campus - Jon (20 days ago)
Thanks Eduard! :-)
Nicky Gounaris (1 month ago)
Really helpful. I had no clue about this before! thanks so much
Excel Campus - Jon (20 days ago)
Awesome! Thanks Nicky! :-)
yassir661 (1 month ago)
useful thank you
W&D Parables (1 month ago)
This three part series on pivot tables and dashboards is the best I've seen. I appreciate how easy you made understanding dashboards and pivot tables and the scenario with Andy. Looking forward to seeing more of your videos. Well done!
Excel Campus - Jon (20 days ago)
Thanks so much! I really appreciate the nice feedback. :-)
Joey Hyde (1 month ago)
I love Excel and like it a lot more than quicken. Is this something that I can do instead of using quicken. Is there a way that I can update and pull information from the bank???
Excel Campus - Jon (20 days ago)
Hey Joey, Great question! You can definitely use Power Query in Excel to pull in data from exported csv or Excel files. This can be mostly automated, except for the export part. Here is an article on Power Query that will help get you started with that. https://www.excelcampus.com/powerquery/power-query-overview/ Pulling data directly from the website will be a bit more tricky, and depend on the sites security, but can be possible with VBA. I hope that helps.
Mr Md Topu (1 month ago)
Thanks
Hesham Abdullah (1 month ago)
Good job, please keep helping us, thanks a lot and best regards
Joe P (1 month ago)
This is the best video that I have found. It has a beginning (WHY do I need it). It has a middle (This is HOW you do it.). End (Show the RESULTS of the process).
Excel Campus - Jon (20 days ago)
Thank you Joe! I really appreciate your support. :-)
templates financial (1 month ago)
see more: https://templateshunter.com/revolving-credit- agreement.html
Keith Voller (1 month ago)
Thanks very helpful and easy to follow
black whole (1 month ago)
Very helpful, thank you....
Shailja K (1 month ago)
Awesome video, easy to understand, it really helped me to get my manager impressed. :) Thank you so much.
Obed Nyaribo (1 month ago)
very good job on pivot tables
Rana Soleimani (1 month ago)
Thanks so much, It seems it is not as hard as I thought.
Excel Campus - Jon (20 days ago)
Awesome! Thanks Rana! Yes, pivot tables are made out to be much scarier than they really are. :-)
Jekaterina Trelina (1 month ago)
Thank you very much, absolutely useful. Best wishes from Finland!
ONTIME EDU (1 month ago)
Awesome Video for new learner.!! Thanku Jon !! Have a nice day to you!!
kimora75 (1 month ago)
I love your introduction. It’s easy to understand and not to lengthy. Clear, concise, and cohesive!
Excel Campus - Jon (20 days ago)
Thank you Kimora! :-)
Sai Phaneendra (1 month ago)
Awesome
Akshay Kadam (1 month ago)
Excel salary sheet dash bhord
Omar Faruqe (1 month ago)
Nice and this is Helpful tutorial
Sajeev Kumar (1 month ago)
HI i need to delete two same names, i use duplicate , but it remove only one name , i need to remove both names . Example ( boby, steve ,jeff, steve , evan ,eric ) need to delete both steve names . any formula please.
Queen Sarcastic (1 month ago)
You made excel seem 90% less intimidating. This is coming from someone with zero knowledge of excel.. Thanks! 😄
Jd Chapman (1 month ago)
Thanks a million it’s going to help me a lot in my new supervisor position
Excel Campus - Jon (20 days ago)
Thanks Jd and congrats on the new role! :-)
LMC Presentations (1 month ago)
Great presentation. Thank you.
tanmay dastidar (1 month ago)
Keep up the good work. Never created pivot tables in my life. after this presentation, I could manage to create one.
Excel Campus - Jon (20 days ago)
Woohoo! That's great to hear. Thanks Tanmay! :-)
Debbie Murphy (1 month ago)
Really useful video and supporting files. thanks very much!
Jessica Brown (2 months ago)
Jon, This was exactly what I needed and plan on using your Pivot Pal app. THANK YOU!
Excel Campus - Jon (20 days ago)
Awesome! Thanks so much Jessica! :-)
surender kumar (2 months ago)
nice
Muhammad Abubakar (2 months ago)
how to add XL campus option in excel
Excel Campus - Jon (20 days ago)
Hi Muhammad, The XL Campus tab appears whenever you install any of our add-ins, including PivotPal. Here is a link to our add-ins page with both free and paid add-ins. https://www.excelcampus.com/add-ins I hope that helps. Thanks again and have a nice day! :-)
Aditya Malve (2 months ago)
This was very helpful, Easily Explained.
Daria Furman (2 months ago)
Great video, thanks a lot.
Jack Guttridge (2 months ago)
The pivot table diagram was exactly what I was looking for! Glad I found this video
Excel Campus - Jon (20 days ago)
Awesome! Thanks Jack! :-)
Gyanesh Kumar (2 months ago)
Any easy way to get to know which option should drag into row,col,filter,value
Justin Raj (2 months ago)
Good Video and you can learn MSBI and SQL https://www.sqlmsbi.com
Belinda Cortez (2 months ago)
Your video made Pivot Tables so much less intimidating.  THANK YOU so much.
Excel Campus - Jon (20 days ago)
Thanks so much Belinda! :-)
KB (2 months ago)
O.M.G Jon, you are heaven sent! Thank you for this. I'm definitely subscribing you're the best!
Excel Campus - Jon (20 days ago)
Thank you KB! I really appreciate your support. :-)
Ahmetcan Caglayan (2 months ago)
I've got an interview coming up for Junior Process Specialist. I've got my lean six sigma certification, I was told I needed to know Pivot Tables and Vlookup. This video has already helped me immensely. Thank you.
Excel Campus - Jon (20 days ago)
Thanks so much Ahmetcan! I hope your interview went well. :-)
Loloy Garcia (2 months ago)
Excellent tutorial
Bisa Kovac (2 months ago)
This has been very helpful, I feel more confident now with my Pivot Tables.. Cheers
Bisa Kovac (19 days ago)
Hi Jon, I keep watching it because I learn with repetition.... I really appreciate it
Excel Campus - Jon (20 days ago)
Thank you Bisa! Happy to hear your confidence is growing with Excel. :-)
Theresa Jones (2 months ago)
Thank you for the concise, informative video! The use of pivot tables will greatly enhance my productivity and impress my boss (I hope).
Roxie Sossa (2 months ago)
Fantastic Tutorial - thanks Jon!
Delly Afshari (2 months ago)
Thank you for this informative video, it's wonderful. I do have a question however, I have hard time formatting my dates. I'm using dates instead of Revenue (your example), and as soon as I insert it in my Values section, the dates change to 01/01/1999. I've tried different formatting on my source data, but can fix it. Would it be possible to get an explanation? Also, I can't find the Part 2 of this video. THANK YOU
Excel Campus - Jon (20 days ago)
Hi Delly, When putting dates in the Values area a lot will depend on the calculation type. You will likely want to change the calculation to MAX or MIN to display a single date for the intersection of data. Summing dates usually doesn't make sense in the Values area. Again, a lot depends on the data. Here is an article on how the date system works in Excel, which might help. https://www.excelcampus.com/functions/how-dates-work-in-excel/ Here is a link to part 2: https://www.youtube.com/watch?v=g530cnFfk8Y I hope that helps. Thanks again and have a nice day! :-)

Would you like to comment?

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