Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)
HTML-код
- Опубликовано: 3 фев 2015
- Sign up for our Excel webinar, times added weekly: www.excelcampus.com/blueprint...
PART 1: www.excelcampus.com/charts/pi...
WATCH PART 2: • Introduction to Pivot ...
Download file used in the video: www.excelcampus.com/pivot-tab...
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.
www.excelcampus.com/pivot-tabl...
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. • Excel 2010: Pivot Char...
Get PivotPal: www.excelcampus.com/pivotpal
Free webinar on The 5 Secrets to Understanding Pivot Tables: www.excelcampus.com/pivot-web...
Subscribe to my free newsletter: www.excelcampus.com/newsletter - Хобби
Who all are watching this in 2024
You have explained the subject in a very clear and simple way. Good job!
I keep coming back to this tutorial. I have NEVER seen anything so lucid and easy to follow. It is my holy grail.
Thank you Winnie! I really appreciate that. I'm also happy to hear you keep coming back. Practice and repetition is so important for learning, and something I stress inside our training courses. It's great that you are using this as a resource and implementing what you are learning. Awesome! 🙌
I can see why. Great help.
0000
Hi Jon! I just wanted to let you know that your videos really helped me get a my most desired position for a new role in an international company. I'm very very grateful and you should continue sharing your knowledge. By doing this, you really make a difference in people`s lives. Thank you again!
Glad to hear it, Ronald! 😀
Simply perfect: perfect timing, perfect volume control, organized and efficient. Thank you from a 70 year old geezer in Gainesville FL.
I'm from India, but a proud Gator.... I graduated from UF with Masters in Transportation Engineering!
Cheers!
@@050138 did we ask
@@semirasuleman1989 didnt tell ya!
I have struggled with excel till I bumped into your RUclips Channel. Excel has never been more fun to learn. What an amazing job you are doing! I have set aside some time every day to learn. Thank you very much.
Thanks so much for this simplified explanation. One of my goals during the 2020 stay home order is to enhance my limited knowledge of Excel. This really helps!
Awesome teaching and quite simple, explaining in layman's terms. I have never used pivot tables before but think that I will be able to do so now confidently. Thank you.
I've been wanting to get additional training on Excel for years & never thought it would be this easy. Thank you so much for your clear & concise training! Absolutely love this.
Uncomplicated and easy to follow, by far the best tutorial out there. Thank you very much for all your help
Although you dropped this video a few years ago... it doesn't go out of fashion!! Thank you!
Jon, I taught for thirteen years before pivoting to data analysis and I must say that your delivery is better than so many teachers I worked with. There is a harmful belief that students are not learning because teachers are not animated (read: not enough of an entertainer) ...thank you for being a testament that good teaching is direct, thorough, and well-paced. Cheers!
Hello nichole
Thank you for creating these videos for Pivot Tables! Very very helpful.
A big thank you for your "class" all of them about pivot tables. I learned and applied in my job and you help me to save my position. Thanks again
I've been searching for a good tutorial on Pivot Tables for some time. Finally I've found a tutor who knows how to present the subject, has the skills to convey understanding, and a manner that makes listening and learning a pleasure. Thank you so mu8ch.
Great first Pivot Table video. Very clear instructions on your tasks. I wanted to get into the functions, data changes, and filters right away and didn't think I needed the chart stuff so early but I'm glad to see that Video 2 will cover that stuff. Thank you!
Thank you so much for producing these videos. I used to be incredibly intimidated by pivot tables, but your tutorials explain them in a very easy-to-understand manner! This has been unbelievably helpful!!!
This was one of the best tutorials I could find on the introduction to Pivot Tables. Thank you very much!
Yup, It's me again. Finished Parts 2 and 3 - and finally did your Dashboard Tutorial that I've wanted for ages!!! You make it so easy it's almost a sin. Even an old coot like me just sails along with your instructions. Thank you, Jon
I'm watching this in 2019 and it's been very helpful. I'm going to use it to analyze data for my final year project. Thank you so much.
same here i'm in my second year I just don't understand my lecturer
I used to use Excel all the time and was considered a guru because I used pivot tables. I've been in another career for 10 years and was worried I'd forgotten everything (upcoming job interview has me scurrying). Your video is undoubtedly the best - and now I've subscribed to your channel. If I knew 1/10th of what you know, I'd be a real guru, but I'm going to watch all over your videos over and over until I get it. Thank you for being so clear, concise and thorough!
Indeed he has given us the keys to the kingdom with this video!
Can anyone tell me how to match two data lists together in excel so the dates sit in the same rows?
eg. would need to excel to match dates and leave gaps on days there are no matches.
11/11/18 . 11/12/18
11/10/18 . 11/11/18
11/08/18 . 11/09/18
I have a similar story - only 20 years out.
Great video content! Forgive me for the intrusion, I am interested in your initial thoughts. Have you ever tried - Weydaniel Organized Dominator (Sure I saw it on Google)? It is a good exclusive product for getting 7000 plus project management and business templates without the hard work. Ive heard some awesome things about it and my close friend Aubrey after many years got great results with it.
Same here. It's funny how fast we forget things lol.
Yesterday, I was a completed ignorant. Thanks to your excellent tutorial video, now I have learned how to utilized Pivot tables. Rating 10 out of 10.
Thank you Ravana! :-)
Hi Jon, simply outstanding presentation of the tutorials. I have seen multiple tutorials of yours, at the end of it, for learners like me, it provides a sense of satisfaction and confidence. Thank you!
Dude....literally the first 5 minutes of this video has saved me countless hours of work.....can't believe I've been doing things the dumb way for so long.
Great presentation Jon. Your voice modulation and expertise is second to none. Many thanks for your service.
I really enjoy watching your videos. I've checked a few out and yours are by far more superior to others I've watched. Others can have a patronising instructor but you come across friendly and professional. The pace is good and I can keep up. I had to do some learning prior to an interview on things I've never done before which helped me greatly. Got the job now to perfect my skills ready to start!!!
A good Instructor could make his student understand better and are one of those.
I was about to hire someone to teach me Ms Excel. But, I changed my mind. I already found a brilliant teacher like you for free. WOW! YOU are doing a fantastic job Jon. May God bless you more wisdom to share to us. Thank you so very much! Keep it up!
Good explaining
Thank you for the concise, informative video! The use of pivot tables will greatly enhance my productivity and impress my boss (I hope).
Thank you, Jon, for your professional and easy-to-follow instruction. Really appreciate your making the practice data available and Mynda's link as well. So glad I found you!
Patricia Chilton agreed
Hi Jon, you are made adding tabs very easy for me. I have downloaded your free e-workbook. I am taking data analytic classes and when I reference adding tabs its much easier for me to do it now. You are a great instructor. I will now look at your video for Pivot tables and reference back to your free e-workbook. Please keep adding videos on excel. I will be very good at this in no time.
Wonderful video Jon. I have worked on excel for more than 5 years, but never actually used a pivot table. This has made it very easy for me. Thanks!
Really good explanations and visualizations. I enormously benefit from it in terms of my business studies.
Hello, I want to inform you that the video was really helpful to me. I was practising it along with you and enjoyed the process. I missed a job opportunity because I could not generate the pivot Table as directed. This is a wao!!!! moment for me now
ऊपर
Rxfvcdcq1qckjdndc fbdf1n
THANK YOU SO MUCH. I HAD GOT AN JOB ASSIGNMENT YESTERDAY , HAD TO MAKE a dashboard , i never used this , you explained so simply. finally i made it. thank you.
Glad it helped! 😀
Thank you for such great instructions. I have never used a pivot table/pivot chart. This made it easy for someone having to re-enter the working world. Please keep up the lessons.
This was actually pretty easy to understand. Thank you! 💗
Hi Jon, thank you for your really helpfull videos! I start a new job next week and I feel like this series truely helped me to prepare for it. Everything was super clear and entertaining to watch! I hope you have a wonderful day and wish you all the best!
This was great, haven’t used pivot tables in a very long time. Looking to incorporate this back into my daily life. Thank you
Fantastic educational video! Clear, concise information that flowed smoothly. You integrated supporting tidbits of how's and why's very effectively. As an out-of-practice Industrial Engineering student, I especially appreciate the color coded boxing. I'm actually excited to see what else I learn from you guys.
Much appreciated! 😀
Great tutorial! I really appreciate you supplying the excel file to work along with you.
Thank you for the clear and understandable explanation. Just right, not boring and slow or too fast and assuming!
Thanks Susan! :-)
I recently started to learn the different functions in using a pivot table and adding charts for work. My boss is letting me take charge in creating analysis around different areas for our department. This was most helpful
This is , in my opinion, actually the best channel that I’ve found to learn this new functionality. I’ve watched other videos before I spontaneously fell on this one. Without mentioning names and I’m not saying that these people weren’t explaining well, but they just offer an Excel-folder that’s already completed with the stuff they show in their video and I obviously can’t work/learn with that while watching. Too bad. But this is a well-made video that explains everything in the necessary details and you get an Excel-Folder that YOU have to complete while watching. And this for free. Great job! 👍
Thanks for explaining Pivot table with such great elegance. Really loved your presentation
Thanks Debabrata!
Thank you for watching the video! Here are the links I mentioned in the video.
DOWNLOAD the Pivot Table Checklist & Excel File: www.excelcampus.com/pivot-table-checklist-yt
Learn more about PivotPal: www.excelcampus.com/pivotpal
Free webinar on The 5 Secrets to Understanding Pivot Tables: www.excelcampus.com/pivot-webinar-yt
Watch video #2: ruclips.net/video/g530cnFfk8Y/видео.html
Please leave a comment below with any questions, and hit the like button above if you enjoyed the video. I really appreciate your support! :-)
I can't follow your instruction because it is not selecting the cells I need :(
I got it :)
thank you sir I got the file
thank you :)
I am also having trouble finding it!
I just watched a couple of exercises and the lessons were so healthful, I wish I had known this technique years ago, I would have carved a different niche and create an incredible resource for crunching number. The techniques you demoed are powerful. Thanks
you are the benchmark for the best practices in Excel trainings
Glad to hear that, Shosh! 😀
I can’t imagine how grateful I am for coming to your campus to learn this Pivotal Table... Please accept my warmest appreciations
Dude, you saved my life today. My report is due in an hour and now it looks amazing! Thank you...
I built a tracker using this video series a few years ago that became very popular at my job as a result, and that i still regularly maintain. Looking back now, it's amazing how much of this is superfluous by using Power Pivot and DAX to insert charts based off the data model. Nevertheless, I credit this video series with helping me learn what I needed to get me where I am today!
i can't believe how much i have learned in such a short time by watching your videos. Thank you so much.
Hey Jon. Thank you so much for sharing. You are an excellent teacher, you explain very well. Your course is easy to follow and pretty useful to learn how to visualise in a clear manner lots of business data. I am starting a new role soon and the pivot tables are going to be super necessary! Thank you again for your effort and for being so helpful with your videos.
These tutorials give me in-depth learning about how excel can create a lot of things we use. Thank you for sharing with us and hope for more lessons and tips that you can teach.
support me sister
I have a business and always working with Excel. Your video has been very instrumental. Thank you
Great job in explaining how this works. I feel a little more prepared for my upcoming interviews after viewing this. Keep up the awesome work!!!
I have seen several tutorials on the same subject, but this is by far the most explicit and easiest to understand. Congratulations Jon
Indeed
Jon this was awesome, very helpful. I recently accepted a new role and want to work with data better and I believe that your videos will give me the assistance I need! Thank you!
This is the most simplified and easily understandable video on pivot tables. Your video is concise and short that is better than long videos that discusses a lot of topics that you forget what you learned after the video!!
Thank you so much. I am looking for new jobs and, after utterly failing an Excel test, got a good lesson to learn more skills. Coming from someone who's struggled in school, thank you.
Hi Jon, I start a new Job this week and will need to use Pivot tables and other various excel functions. You have eased my mind and helped me gain more confidence in my capability to deliver my work with flair. I look forward to learning more and becoming super efficient and fast with excel! Thank you Champ!
your pic has eased my mind girl
@@cei5140 🤣🤣🤣
I am wowed....with your explanations on each steps...very short and detailed...video is seriously on point...good job
Jon thank you so much for offering this course. Its been a while since I've used Pivot Tables and I really appreciate your help for offering this course.
Fantastic intro to Pivot Tables that really takes the anticipated bite away!
I appreciate you showing added formatting
Hi
Thank you! I just went to a job interview and the hiring manager is looking for someone with pivot table, charting and vlookup experience. Your tutorial was very helpful. I have subscribed to you channel, gave you thumbs up on video and hit the notification bell. Again thank you sharing your knowledge I will be watching your videos.
This is a great video for pivot newbies like myself. My boss uses them all the time and is quite familiar with them. My hope is to get as familiar. This video is certainly a great start. I'm looking forward to Part 2. Thanks a bunch!
This was exactly what I was looking for, and the way you explained every step is very clear and so easy to understand.
Thank you so much this was very helpful and you didn't speed
Thanks to this video, my new job thinks I am a total genius for knowing how to do pivot tables!
That's awesome Paola (aka pivot table genius)! :-) Pivot tables really are Excel magic for anyone that has not seen them before.
Paola Lopez 09uu
How to set Auto Reply in Outlook
ruclips.net/video/3xjxWH2_EWU/видео.html
Me too.
yeah this is so Look awesome in your Job HEHEHE ,i Like to appLy and hands on for this exam ^_^
a Lot of magic i Learn ,Thank you sir Jon
Thank you so much! I am a small business owner in retail, and thanks to the video I now have created a spreadsheet from my POS export that shows everything I need for a better buy plan!!! Amazing!
This series is significantly more professional than other Excel videos
This was excellent! Very easy to follow along. I'm looking for additional videos!
Hi John. Thank you so much for your video. It was informational and very easy to follow.
This video is literally saving my life right now lol! I have worked in AR and considered myself to be an expert at Excel until I started my new job! My new job is very Excel-heavy. I am familiar with Pivot Tables, but I didn't realize how much I did not know until I started this job. I didn't understand the sum column in the Pivot Table until I saw your tutorial. Now it all makes sense! I'm not even done watching this yet, but I had to come here and comment while I was having my lightbulb moment. Thanks!
No doubt being a great teacher implies being an artist too, you are both a great teacher and an artist showing us how to use excel.
Would you tell me what excel version does he use please ? The version I’m using is so different
Amazing and easy-to-follow tutorial. Loved you provided the Excel template to follow along; helped a lot.
Unlike other videos I have tried on pivot tables, this one is more detailed and it tells you why/how in a step-by-step process, and the visual and audio are really good. It is the best so far I have come across. Thanks Jon
Lll
Ql
1/q
PLp1\lPqp
/0q1
your step by step was so easy to follow. I've been trying to learn the basics of excel for years and feel like I learned so much after this video. thank you!
Useful, Didactic, Simple. Straight to the point. Well done
Thanks, @user-bj4ne8iy6k 😀
This is the best of the best Pivot Tables tutorial, I have seen. Good Job Jon.
+Ghazy Sabh Thanks Ghazy!
Hi Jon, can you tell me what software I would require to create those toon characters? I need to do a project for college and this would be great for my presentation.
awesome.
awesome.
How to set Auto Reply in Outlook
ruclips.net/video/3xjxWH2_EWU/видео.html
I have always been intimidated by PVs; avoided them at all costs and did the calculations the LONG WAY (obviously creating more work for myself). Your video clearly explains the "why" and "how" more effectively than the Excel course I took in college! The textbook was utterly useless and only covered three lessons. I have subscribed - I'm a sponge for knowledge!
Hi John, Leon Kotze from Namibia, joined your campus lately, and really blessed to have been guided here, gain a lot from your sessions, also going to work through macros next, Greetings
Welcome aboard, Leon! 😀
This is what I need as an ICT Coordinator in our District. Thanks for sharing this and it's in my recommendation ☺️
Awesome video! Very well presented. So easy to follow along. I was clueless on how to create a simple pivot table and this tremendously helped me . Thanks sooooooo much!
This tutorial video have taught me a lot. Appreciate it so much. Thanks for the big help. 😘
Great video. I received a promotion at my job and I'm using your videos to help me with my trainings. I will be working on several reports and metrics, so I appreciate this video. I took an excel training that involved pivot tables and charts, and I must say, if you don't use it, you'll lose it. Your video will be saved.
That is awesome, Isharah! Happy to hear that. 😀
Pure gold of a video. The quality in this video is what i'm striving for with my channel. Hats off to you, sir.
Hello Jon, thanks for sharing, beautifully explained . Wonderful!!! Greetings from Germany.
lol cool, you're from Germany :o no one cares :(
Greeting from Bikini Bottom
You made excel seem 90% less intimidating. This is coming from someone with zero knowledge of excel.. Thanks! 😄
ruclips.net/video/HOa5r2IavRY/видео.html
EXCEL SLICER FOR PIVOTS1
I usually get the end product of excel reports and this video opened my eyes to a whole new world. Thank you
The easiest and the best pivot table tutorial i have ever watched. I salute🙌 you and thank you for the time and effort and thank you for sharing your knowledge.
You explain it so well.. Whenever I need a refresher this is my go to list
This is great, I can't believe I've not used them before! Thanks for the explanation - looking forward to applying this to all my hobby stats.
Please allow me to just say, i am so grateful to have you here being so patient and teaching at a level that makes perfect sense. I am forever a subscriber.
You're so welcome and thank you for subscribing! 😀
I already do some of these, albeit the hard way. this is simplified and demystified. Thanks a lot. Amazing tutorial. Good job man!!
ruclips.net/video/HOa5r2IavRY/видео.html
EXCEL SLICER FOR PIVOTS2
Thank you for this amazing tutorial ! You made it look so simple and is funny how I had a question in my mind and you almost instantly answered it every time! Thanks and keep the great work!
tutorial from indonesia
This is the best, simplest "intro. to pivot tables" video I've seen. Will definitely use with some of our new employees. Thanks!
Thanks Arturo!
Thank you for this amazing video. With your help I could easily understand how to create pivote table and chart.
wow! after part 1, I just tried it on my own and... I am confident I will get that job!!!! Thank you so much!