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

[@nicholasnorman9591]

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!

[@whyistheworldsowicked]

Hello nichole

[@winniewaudo5662]

I keep coming back to this tutorial. I have NEVER seen anything so lucid and easy to follow. It is my holy grail.

[@ExcelCampus]

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! 🙌

[@pamelaguidry1817]

I can see why. Great help.

[@user-oo7py5bx4x]

0000

[@ronaldmelendez4558]

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!

[@ExcelCampus]

Glad to hear it, Ronald! 😀

[@kristinloehrmann5262]

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!

[@MrRefract]

Indeed he has given us the keys to the kingdom with this video!

[@BlackStar-ff2kn]

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

[@maynardclark9295]

I have a similar story - only 20 years out.

[@edgararenas8042]

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.

[@atama203]

Same here. It's funny how fast we forget things lol.

[@jgorjez]

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!

[@faridmedjoudj5482]

Good explaining

[@onelovebeauty7903]

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.

[@ExcelCampus]

You're so welcome and thank you for subscribing! 😀

[@chandraoaks-garcia212]

I have a business and always working with Excel. Your video has been very instrumental. Thank you

[@fosterchild4523]

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.

[@dylan1658]

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! 👍

[@JOHNCARLWILLIS]

Simply perfect: perfect timing, perfect volume control, organized and efficient. Thank you from a 70 year old geezer in Gainesville FL.

[@050138]

I'm from India, but a proud Gator.... I graduated from UF with Masters in Transportation Engineering! Cheers!

[@semirasuleman1989]

@@050138 did we ask

[@050138]

@@semirasuleman1989 didnt tell ya!

[@charlessotis6672]

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

[@nayeligonzalez13]

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

[@CandiceRoseMusic]

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!

[@cei5140]

your pic has eased my mind girl

[@CandiceRoseMusic]

@@cei5140 🤣🤣🤣

[@violynenguti3230]

I have struggled with excel till I bumped into your KZbin 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.

[@Juber_Human]

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.

[@ExcelCampus]

Glad it helped! 😀

[@CC5956]

I have seen several tutorials on the same subject, but this is by far the most explicit and easiest to understand. Congratulations Jon

[@thedivineson2995]

Indeed

[@arturog.faustoberumen7336]

This is the best, simplest "intro. to pivot tables" video I've seen. Will definitely use with some of our new employees. Thanks!

[@ExcelCampus]

Thanks Arturo!

[@leonkotze7663]

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

[@ExcelCampus]

Welcome aboard, Leon! 😀

[@cypresscitycomics1185]

Dude, you saved my life today. My report is due in an hour and now it looks amazing! Thank you...

[@ronsimonsen6694]

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.

[@eleonoraminelli5264]

Although you dropped this video a few years ago... it doesn't go out of fashion!! Thank you!

[@victormalaolu3976]

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

[@tapaskumardas4518]

ऊपर

[@nycollassilva3558]

Rxfvcdcq1qckjdndc fbdf1n

[@anada11]

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.

[@ExcelCampus]

Thank you Ravana! :-)

[@isharahknox6506]

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.

[@ExcelCampus]

That is awesome, Isharah! Happy to hear that. 😀

[@loveroftruth1011]

Thank you very much for this instructional video. I will be starting to work as analyst and pivot table is a must. Before, I was really overly concern because I thought pivot table is really difficult. You made it so easy and I am thankful to God for people like you. More power, Sir!

[@ExcelCampus]

Thank you Dennis and congrats on the new job! Awesome!

[@DebabrataPatnaik]

Thanks for explaining Pivot table with such great elegance. Really loved your presentation

[@ExcelCampus]

Thanks Debabrata!

[@RaviKumarCreativeCorner]

i can't believe how much i have learned in such a short time by watching your videos. Thank you so much.

[@oluwabusayomakinde7000]

I am wowed....with your explanations on each steps...very short and detailed...video is seriously on point...good job

[@jameskiawu4210]

I can’t imagine how grateful I am for coming to your campus to learn this Pivotal Table... Please accept my warmest appreciations

[@piusclement8103]

I did a lot of findings on pivot tables, charts and dashboard but i couldn't get an explicit understanding about it. But i can tell you this, this is by far the most easiest mothed ever. Cheers Jon

[@just4meha]

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.

[@ExcelCampus]

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: kzbin.info/www/bejne/nWaWYZake8uebrs Please leave a comment below with any questions, and hit the like button above if you enjoyed the video. I really appreciate your support! :-)

[@Lu-hx3hy]

I can't follow your instruction because it is not selecting the cells I need :(

[@Lu-hx3hy]

I got it :)

[@balajir188]

thank you sir I got the file

[@nigarkarim4959]

thank you :)

[@Gary-gp4le]

I am also having trouble finding it!

[@PhoenixBlacc]

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!

[@aju8946]

Who all are watching this in 2024

[@xlwatcher8885]

Correct me if I'm wrong: Although there are many new functions in micro 365, the methods of building basic Pivot Tables is pretty much the same in 2024 after a big change brought by Office 2010. Isn't that true?

[@sumarnitamuina9461]

Me

[@hindalaqeel1057]

Me 😂

[@prilhg9037]

Me 🙏

[@EliaKayira]

Am watching it on 04/09/2024

[@fotinivakalopoulou9798]

You have explained the subject in a very clear and simple way. Good job!

[@topsyturvyy4558]

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.

[@hendmohamed851]

Would you tell me what excel version does he use please ? The version I’m using is so different

[@mariochangala2932]

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

[@DavinderSingh-fm1zd]

Lll

[@DavinderSingh-fm1zd]

Ql

[@DavinderSingh-fm1zd]

1/q

[@DavinderSingh-fm1zd]

PLp1\lPqp

[@DavinderSingh-fm1zd]

/0q1

[@leonardogranados2733]

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

[@powerbiselfstudyguide]

This is the one of the best Excel Tutorial (Pivot Table) at KZbin, lecture is to the point and appropriate wording & example was used. Moreover, i would like to request to discuss Measures, Calculated Column & DAX Formula, please. Thanks a lot.

[@nerissacreencia8505]

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.

[@IJTutorial]

support me sister

[@feelzie31]

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!

[@motowong4524]

Excellent tutorial! Deserves to be top of Google's search. Easy to understand, good highlight graphics, nice speech pace.

[@shoshtube]

you are the benchmark for the best practices in Excel trainings

[@ExcelCampus]

Glad to hear that, Shosh! 😀

[@francissikazwe3237]

@@ExcelCampusmy excel isn’t showing where to add the label data

[@susanclark8930]

Thank you for the clear and understandable explanation. Just right, not boring and slow or too fast and assuming!

[@ExcelCampus]

Thanks Susan! :-)

[@comopowerbi]

Excel is indeed a powerful tool and knowing how to use it is a great differentiator and can bring you a huge professional prominence. Knowing different functions, graphics and knowing how to apply them to your problems, will certainly bring you an absurd differential.

[@etornamtsyawo6407]

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.

[@Rella28]

same here i'm in my second year I just don't understand my lecturer

[@feliciataylor4028]

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.

[@alfredkaburuk6018]

Jon this is the best pivot tables explanation one could ever ask for Thanks

[@ExcelCampus]

Thanks, @alfredkaburuk6018! 😀

[@williampalmer9252]

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!

[@Doreen20101]

This is the best of the best Pivot Tables tutorial, I have seen. Good Job Jon.

[@ExcelCampus]

+Ghazy Sabh Thanks Ghazy!

[@Gizmo7007]

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.

[@phillipushainana9932]

awesome.

[@phillipushainana9932]

awesome.

[@THEVIRALSTORY]

How to set Auto Reply in Outlook kzbin.info/www/bejne/aanNqYp-Z8R4jbc

[@frankdeangelo1208]

This series is significantly more professional than other Excel videos

[@JN-qj1ot]

earlier i watched your video on VLOOKUP and i knew that this is gonna be the channel im following:) Thank you for your videos! so clear and concise!:)

[@ExcelCampus]

Awesome! Thank you! :)

[@paolalopez518]

Thanks to this video, my new job thinks I am a total genius for knowing how to do pivot tables!

[@ExcelCampus]

That's awesome Paola (aka pivot table genius)! :-) Pivot tables really are Excel magic for anyone that has not seen them before.

[@KhaleelOfficialStudio]

Paola Lopez 09uu

[@THEVIRALSTORY]

How to set Auto Reply in Outlook kzbin.info/www/bejne/aanNqYp-Z8R4jbc

[@mandalampacki]

Me too.

[@add0n1]

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

[@tabashrafi9373]

Saying thank you seems to not be enough in regards to how informative and helpful this video is. We are extremely grateful!

[@ExcelCampus]

Wow! Glad it helped. 😀

[@queensarcastic6544]

You made excel seem 90% less intimidating. This is coming from someone with zero knowledge of excel.. Thanks! 😄

[@sreejithpnair8973]

kzbin.info/www/bejne/foDEZqVofsapiLs EXCEL SLICER FOR PIVOTS1

[@sbow3071]

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!!!

[@Infarlock]

The best tutorial on the internet, easy to follow and easy to understand Hope to pass this scary test tomorrow that I have

[@angelinaturner]

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!

[@sofiamartinez-taboada7646]

Amazing and easy-to-follow tutorial. Loved you provided the Excel template to follow along; helped a lot.

[@claudettejohnson9916]

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.

[@user-rf9xs2kn8n]

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!!!

[@kenlynch8414]

Uncomplicated and easy to follow, by far the best tutorial out there. Thank you very much for all your help

[@mgrnmgrn]

Mr.Jon I learned Pivot table through your channel.Its really amazing great work,continue it for career growth of people through out the universe.

[@ExcelCampus]

Great to hear that, mgrnmgrn! 😀

[@patriciachilton8401]

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!

[@margeperez7921]

Patricia Chilton agreed

[@isaqueoliveira4414]

Hi John. Thank you so much for your video. It was informational and very easy to follow.

[@123pokhara]

Jon, you made the Pivot table and PivotalPal so easier. I could catch in one go. Thank you so much!

[@ExcelCampus]

You're welcome, Indra! :)

[@peteromicioli1269]

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!

[@waynebaird6058]

This was one of the best tutorials I could find on the introduction to Pivot Tables. Thank you very much!

[@khadijamansoorali778]

Hi there, thank you so much for this wonderful video, I've studies pivot tables in my academic level. But, now I'm graduated and applying for jobs. That was a much needed videos to polish and review my excel skills. Thanks a lot :)

[@shivashankerb1433]

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!

[@gihcecconi]

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!

[@IJTutorial]

tutorial from indonesia

[@Zantetsukens]

I am migrating to your free course here from edX. The problem with most online Excel courses and lessons (paid or otherwise) is that they go very slow throughout the videos and rightly so because we are beginners. Then halfway through those videoes as they introduce something new, they suddenly go fast without explaining what it is or how it works. I was 60% done with my edX course and I was infuriated when the coordinator failed to provide a proper explanation on how he customized the syntax of a function, and also, not giving us a model answer or solutions to the exercises so that we can work backward and maybe figure it out. I have clicked and watched through a handful of your videoes and I must say you presented the information very well, in a way that new learners can understand. I was so thankful and appreciative of your work that I was looking for a donations tab on your website. Then I stumbled upon your "Elevate Excel Training Program" which is premium. If you end up replying to this, may I ask what is the benefit of signing up? Are there lessons in there which are not available on KZbin?? I would love to sign up however as I am currently unemployed I am being more prudent with my resources. Regardless. Thank you so much for your classes again.

[@ExcelCampus]

Hello Renzokuken, thank you for your interest in our Elevate course. 😀 The lessons we have in our Elevate course are not available here on KZbin, they are only exclusive to all active members. The step-by-step Elevate Excel tutorials will help you advance your Excel competency, so you can build upon your existing skills. Training includes video lessons (screencast videos), handouts, cheat sheets, and other resources. More information here www.excelcampus.com/join-elevate/

[@selvanaiyadurai8967]

Great presentation Jon. Your voice modulation and expertise is second to none. Many thanks for your service.

[@prakashnarain3036]

Learning Python along with this will make one a Data Scientist. Smart managers who know excel and Python will have competitive advantage.

[@evry1loveronica]

Jon's lessons are pretty awesome, I have pretty short attention span but I'm hooked on the tutorials.

[@roshondascaife2961]

This was great, haven’t used pivot tables in a very long time. Looking to incorporate this back into my daily life. Thank you

[@arlenehaworth6216]

Excellent video. One of the best lessons on Pivot Table I've seen. I was hoping that there was a Pivot Pal for the Mac, but I don't think so. Jon, you are a very good instructor. You make everything seems so easy.

[@TeamFarren]

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!

[@FPrimeHD1618]

Great tutorial! I really appreciate you supplying the excel file to work along with you.

[@sdurks3466]

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.

[@stephenojirimegha9854]

This is no doubt the best tutorial on Pivot table I've come across. I look forward to more videos. Nice job Jon.

[@denisesingh9996]

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.

[@luv_gh]

Thanks for your explanation it really helps ❤

[@comopowerbi]

Having the ability to create dashboards in excel will certainly bring you a great professional prominence within the company you work for. A well-designed dashboard is capable of impressing from the janitor to the CEO.

[@maximeverelst1356]

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!

[@Clips_phrases]

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.

[@ExcelCampus]

Much appreciated! 😀

[@soulfinder_2304]

I usually get the end product of excel reports and this video opened my eyes to a whole new world. Thank you

[@qutubranalvi203]

Tooooooooo Goooooooood. Have no words to express my happiness and in the end i would say God bless u always

[@michelleballard2276]

This was excellent! Very easy to follow along. I'm looking for additional videos!

[@pratiksawalkar1531]

Yesterday I did the same kind of task using python and its different libraries and today I'm watching this video and I burned, How easy it is in excel. Also, you explain it very precisely, Thanks for creating this video.

[@rishikumartyagi6778]

are you from india can you teach me python please

[@ruthnwofor7063]

This was actually pretty easy to understand. Thank you! 💗

[@hasinamaihan8971]

thanks sir, this was a very clear and positive effected lecture about pivot table

[@iamazalea9888]

Omgg!! I'm so happy found your video. I'm gonna be working and I was informed that the company use an old version so I wanna know how to use pivot table using the old version of excel. Thank you for attaching the file u use as well. Best regards!!

[@darnakuno]

A good Instructor could make his student understand better and are one of those.

[@teresagelegonya2238]

Thank you for creating these videos for Pivot Tables! Very very helpful.

[@kirstiecampbell4000]

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.

[@edithamalones6187]

this video is very informative, teaching us every single detail that I haven't seen from other video tutorial about excel. this is cool! thank you

[@CecilDSouza]

Very nicely explained. Just to the point and easy to follow. I wish there was a file to download and work with just to practice the features of pivot tables. Got it!. :-). Thank you for sharing your knowledge.

[@M87RigelAntaresM42]

create one or google sample excel data, select copy and paste

[@CecilDSouza]

Thanks. Actually, if you go to ExelCampus' website provided in the links below the video, Jon allows you to download all 3 sample files. He is a good teacher too.

[@avl231977]

Found it very easy to learn and understand compared to other video tutorials, highly recommended.

[@theresajones1167]

Thank you for the concise, informative video! The use of pivot tables will greatly enhance my productivity and impress my boss (I hope).