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

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

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

[@fotinivakalopoulou9798]

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

[@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.

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

[@darnakuno]

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

[@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.

[@eleonoraminelli5264]

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

[@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.

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

[@selvanaiyadurai8967]

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

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

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

[@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

[@waynebaird6058]

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

[@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! 😀

[@expressiveworld]

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

[@teresagelegonya2238]

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

[@kenlynch8414]

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

[@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

[@swapneelchitale4122]

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!

[@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

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

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

[@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

[@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.

[@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.

[@shoshtube]

you are the benchmark for the best practices in Excel trainings

[@ExcelCampus]

Glad to hear that, Shosh! 😀

[@joudoml232]

Sir, I’m sure U’ve heard it before, you made this so much simpler, so much better than stumbling in the dark trying to figure it out.

[@jameskiawu4210]

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

[@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

[@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

[@akid4419]

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

[@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.

[@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! :-)

[@lolitachisholm3258]

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.

[@mirna-nahle]

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.

[@davidliao9861]

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

[@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

[@chandraoaks-garcia212]

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

[@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

[@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

[@theresajones1167]

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

[@jhp1303]

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

[@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

[@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.

[@FPrimeHD1618]

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

[@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

[@ruthnwofor7063]

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

[@Vincent-ou4bq]

Really good explanations and visualizations. I enormously benefit from it in terms of my business studies.

[@Penelopepitstop50]

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!

[@davida.taylor8444]

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!

[@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.

[@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.

[@cypresscitycomics1185]

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

[@RaviKumarCreativeCorner]

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

[@rwrw915]

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!

[@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

[@oluwabusayomakinde7000]

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

[@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.

[@lil12paws]

This was exactly what I was looking for, and the way you explained every step is very clear and so easy to understand.

[@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

[@michelleballard2276]

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

[@jenniferlogan-porter9788]

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

[@AL-fk9bh]

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!

[@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

[@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

[@cogwheelLearning]

Pure gold of a video. The quality in this video is what i'm striving for with my channel. Hats off to you, sir.

[@soulfinder_2304]

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

[@DebabrataPatnaik]

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

[@ExcelCampus]

Thanks Debabrata!

[@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 🤣🤣🤣

[@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

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

[@diviner2347]

I appreciate you showing added formatting

[@ankitrajput-qe1tg]

Hi

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

[@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. 😀

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

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

[@tonysheridan5359]

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.

[@frankdeangelo1208]

This series is significantly more professional than other Excel videos

[@cwray6768]

Hi Jon. I've taken many tutorials on Excel and Pivot tables, but your tutorial and exercises along with the worksheets are the best . Though I had a little trouble downloading the worksheet for this video, I was able to grab another data set from another one of your tutorials and practice along. I feel so much more comfortable in doing V lookups and pivot tables. Just what I needed as a refresher course. This was great!

[@ExcelCampus]

Thanks so much for your kind words and nice feedback. I really appreciate it. I'm sorry to hear you had trouble with the download. We'll take a look at what might be causing that. Thanks again and have a nice weekend! 🙂

[@susanclark8930]

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

[@ExcelCampus]

Thanks Susan! :-)

[@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.

[@SebsAviles]

Fantastic intro to Pivot Tables that really takes the anticipated bite away!

[@BuyoganExtendedStories]

This is what I need as an ICT Coordinator in our District. Thanks for sharing this and it's in my recommendation ☺️

[@sofiamartinez-taboada7646]

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

[@isaqueoliveira4414]

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

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

[@shegzb6875]

I already do some of these, albeit the hard way. this is simplified and demystified. Thanks a lot. Amazing tutorial. Good job man!!

[@sreejithpnair8973]

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

[@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

[@alekhya3676]

You explain it so well.. Whenever I need a refresher this is my go to list

[@alfredkaburuk6018]

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

[@ExcelCampus]

Thanks, @alfredkaburuk6018! 😀

[@margelynch]

I got so excited to learn deeply because you hit the lesson point by point for me to understand in systematic fashion. I would like to fall in line ahead to be your first student on your next instruction.

[@rock30]

Thank you so much this was very helpful and you didn't speed

[@SKU377]

Hello Jon, thanks for sharing, beautifully explained . Wonderful!!! Greetings from Germany.

[@joshcathie1719]

lol cool, you're from Germany :o no one cares :(

[@hariismail7737]

Greeting from Bikini Bottom

[@stephenojirimegha9854]

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

[@user-bj4ne8iy6k]

Useful, Didactic, Simple. Straight to the point. Well done

[@ExcelCampus]

Thanks, @user-bj4ne8iy6k 😀

[@REPUBLICOFRAILWAYS]

Thank you very much.........I have learnt very much about Pivot Tables now and now can face the interview uphead next week ......:P

[@shailjak3413]

ho gaye aap clear interview mein??

[@chansilliawhyms7772]

GAURAV ROHILLA good luck

[@abdulkareemhussein2823]

What happened with your interview ? :P

[@ProMovieAcc]

@@abdulkareemhussein2823 he got the job. Then 3 years later, he hates his job that much, he unsubscribed the channel, cuz all they hired him and ruined his life was because of that video.

[@abdulkareemhussein2823]

@@ProMovieAcc lol

[@clemerlontayaojr6515]

This tutorial video have taught me a lot. Appreciate it so much. Thanks for the big help. 😘

[@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! 😀

[@evry1loveronica]

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