How to Create a Dashboard Using Pivot Tables and Charts in Excel (Part 3)

Sign up for our Excel webinar, times added weekly: www.excelcampus.com/blueprint...
www.excelcampus.com/charts/piv...
This is part 3 in the series on Pivot Tables and Dashboards. In this video we bring it all together to create the interactive dashboard.
You will learn how to:
- Group dates into months and years to create a time series trend chart.
- Group amounts to create a distribution (histogram) chart.
- Add slicers to your pivot tables and charts to make them interactive.
- Lots of tips and shortcuts for formatting your charts.
You can download the file to follow along at the following link.
www.excelcampus.com/charts/piv...
Please subscribe to my free email newsletter to get your tutorials like this and get updated about PivotPal.
Get PivotPal: www.excelcampus.com/pivotpal
WATCH PART 1: • Introduction to Pivot ...
WATCH PART 2: • Introduction to Pivot ...
Subscribe to my free newsletter: www.excelcampus.com/newsletter

[@zoemeanslife]

The VLOOKUP tutorial and this series heavily informed my work on a project for a job application, particularly the grouping and slicers, and ultimately elevated me above two other candidates -- I've just been invited to join the company! I don't see a donate option on the website. Jon, I would love to send a token of my gratitude. It's amazing you provide all this content for free.

[@Pkgreat]

which company?

[@Damian-lu8sx]

This video series is the definition of what a perfect training video looks like. Everything is clear and easy to follow step by step, you include small things that many people would forget about but are sometimes incredibly useful like keyboard shortucts. You also provide the materials to be practise along. Seriously, most productive 45 min of training I have watched in a very long time. Thank you!

[@username-dh4tq]

#freeport #portland_ @chevron :

[@username-dh4tq]

#united #federall @corporatte :

[@lindarobinson2104]

That was VERY informative. I use Excel all the time, but never learned how to use pivot tables, charts and dashboards. Thanks

[@khursheedahmad5954]

One of the best expalain tutorial. Thank you

[@lazoqaradaxi5254]

Very simple and professionally presented. very very informative. Thank you Jon.

[@jonathanmyers8447]

yes, thank you jon XD

[@ba8e]

I've been using Excel daily for years, but never heard of Slicers! Thanks for teaching me something new. So useful!

[@maggiemae3825]

This is the first time this information has made any sense. Thank you!

[@rajtrivedi5503]

The best learning video for excel beginners! Thanks!

[@Gha6i]

8 years later and it still a great reference... so many thanks!!!

[@ExcelCampus]

Thanks for the feedback @Gha6i 😀

[@wadeweisman4745]

I listened to all three videos on pivot tables; probably some of the clearest, easiest to follow training for Excel I have ever seen. Thanks for what you have provided. Excellent!

[@ExcelCampus]

Thank you so much Wade! I really appreciate the nice feedback. Have a happy new year. :-)

[@TheIrisiris]

Thanks John... your tutorial was clear and very much useful for me as I am new to Pivot tables... great tutorial...

[@oo1199]

i only wish i can like this video more than once. very helpful, thank you good sir!!!

[@achrafemami328]

I've seen a lot of excel tutorials and this is definitely one of the best for a quick understanding of Pivot tables! Thanks Jon!

[@ExcelCampus]

+Achrafe Mami Thank you Achrafe!

[@IheartmeandL]

This is by far the best tutorial I have ever watched. Your explanations are so easy to understand. This has helped me tremendously and I really appreciate that.

[@AnalyticsInDetails]

I watched almost 100 videos in a month for dashboard only but this is one of the best and Sir your explanation is appreciated. Thank you much.

[@shanai5711]

Definition of excellent teaching

[@sgroiberry]

I didn't fall asleep once! Thank you Jon, your teaching style is engaging, informative, concise and super helpful!

[@PK-ms5fb]

Awesome! I've watched all three. You made everything sound so simple and clear. Thank you very much!

[@ngocngalenguyen3525]

Very helpful and easy to understand. Thank you Jon.

[@sony170160]

It was new for me to learn pivot table and your tutorial is easy to understood

[@oliviajones3753]

The pivot table 3-part series is amazing! I've always been afraid to use the pivot table features, but now I'm actually excited to get started. Thanks, Jon, for breaking it down into layman's terms!

[@alivelizade7377]

Your way of explaining is clear and smooth. Thanks for great videos, Jon! Really helpful for accountants!

[@ExcelCampus]

+Ali Velizade Thanks Ali!

[@lifetube1960]

Excellent way of explanation and easy to understand. I liked it the most.

[@filipedutra3038]

Great tutorial. Completed three of them. Thanks for the content.

[@kodjohounnake6099]

This tutorial is simply brilliant. I was considering learning VBA and SQL to slice my data a certain way but I just realized pivot tables/charts are extremely qualified (and much simpler to implement) to do the job!

[@winniewaudo5662]

This is such an amazing tutorial. Very lucid language, well structured therefore easy to follow. I have been pulling my hair out trying to create pivot tables from my accounting journal. Many thanks for this. Now the hard work slicing and dicing and making sense of the data.

[@vslingam000]

I watched all 3 videos. Superb. Your explanations are very clear and easy to follow. You took a complex topic ie Pivot Tables and made it simple to understand. This is the way ALL tutorials must be conducted. Tks for the tutorial.

[@paramaladevi8217]

Tqvm Jon. Your presentation is very clear and easy to understand.

[@elizabethkrenke]

Wow, so glad I found your videos! I'm starting a new job and I have to get good with Pivot tables, and your tutorials are so easy to follow and informative that I'm much less stressed out. Thank you so much for sharing your knowledge!

[@gslvqz8812]

Same here... and getting ready for my new job. :)

[@robertc2121]

Thank you Jon this series is amazing delivered and a huge help!!!

[@sandypie2832]

Thank you Jon, I'm returning to work after a 2 year hiatus and needed a refresher, that was absolutely perfect.

[@alinabustinza8976]

Thank you! It is very clearly explained and easy to understand

[@sidraines]

Amazing 3 part video. Learnt so much from these!

Thanks for your informative presentation. I have used pivot table for a long time. You have helped me to recognize that I still have not totally taken advantages from this useful tool of excel. Thanks again.

[@JudithNwachukwu]

Thank you Jon! I have not used excel extensively in years and this is resourceful.

[@hashvara2879]

Thank you for the awesome tutorials. Easy to follow explanations. Awesome job. Look froward to more of these.

[@amkiap2715]

Thank you so much for this three part tutorial, Jon! Very informative and I feel comfortable doing pivot tables for my own data as well. Can't wait to check out your other videos!

[@Lilishkaleyla]

Thank you for the best tutorial about dashboards!

[@donks5306]

Jon, thanks for an easy to understand Excel tutorial, I have picked up a few tricks already!

[@BigBigVideos]

this is brilliant. i'm an advanced excel user of 15 years and this has blown my mind. Subscribe!!!

[@qwenda11]

thank you so much, now I feel much more confident to take my midterm in Excel. I was able to comprehend and take great notes, I have watched all three videos and enjoying creating dashboards and pivot charts!!!

[@ExcelCampus]

+qwenda11 Awesome! Good luck on your midterm! :-)

[@AnonymousAnonymous-hh6uj]

Amazing! I never learned how to use pivot tables before. I watched this video and was able to make an amazing report!

[@SG-uz9qo]

Thank you for making this easy to understand.

[@terryp5161]

Thank you. Very informative, helpful and fun to follow.

[@ExcelCampus]

Thanks for watching the video! You can download the file I use in the video at the following link. DOWNLOAD FILE: www.excelcampus.com/pivot-table-checklist-yt I will also send you the other videos in the series and lots of cool stuff to help you learn Excel. Please leave a comment below with any questions, and hit the like button if you enjoy the video. Thanks again for your support!

[@jitendernegi4846]

Excel Campus - Jon great and easily understand. thanks

[@Ayieiyak86]

Great thanks and appreciation from a friend in South Sudan-Africa

[@maimaparker500]

Thanks for helping us learn, you are awesome today and forever.......

[@AmerIndianWarrior]

Excel Campus - Jon Thanks for sharing.

[@gungurung36]

Excel Campus - Jon #

[@youngterk2101]

This help me a lot to improve my skills even i started from scratch. Thanks

[@ajaysherkhane8797]

Thanks for making it more simple.

[@LauraWestley-pm1kd]

You are awesome! Thanks so much for making this information available and so clear and well taught!

[@NHYarris]

Thank you so much for doing these! I had never heard of a pivot table before, but now I've practiced and created some! My only issue is that only have of my charts changed on my dashboard with the slicer, but I thought I had the information in each chart's filter. I will keep trying. Thanks!

[@natashadavis9817]

Immensely helpful Jon. Your delivery is really easy to follow and gets straight to the point. Appreciate your time putting these tutorials together, I'm much more confident now. Pivot tables here I come! :o)

[@lynna7844]

New to pivot tables and watched all three videos! Thank you Jon

[@ramya3928]

Jon.. thank you so much after these many years I got an excellent dashboard creation for my report, this is the 1st time I am watching your video and started to follow them from now on.

[@farougosmanabdelmukaram3173]

you have nice style of explaining, really I like it.

[@m.arsalanhassan5365]

Never seen something being explained in such owsome way//...keep it up..

[@billphair8169]

Extremely well done...especially for a generationally challenged 61 year old who grew up with VisiCalc and Lotus 123. Will be my major tool for tracking quality metrics. I will now pivot to practice. I'll let Bill Gates know what a great job your doing.

[@user-nx2yf6vk7d]

Thank you for this awesome course, a BIG thumbs UP!

[@docofsoil]

Thank you. Very useful

[@peterbell3199]

Finally I can make pivot tables and graphs that impresses my boss! Your videos are the best. Can you show how to make a bar chart with two rows of data? Sales by month for 2015 and behind it Sales by month for 2016? I still can't figure that part out.

[@netrom371381]

did anyone find a solution for this problem?

[@ma.margaritacopon5464]

@@netrom371381 i can do it but without the pivot table, just make two rows (row 1: 2015 data; row 2: 2016 data) then right click then insert double bar graph

[@shay8489]

You are the best, Jon!! Thank you!

[@samirbouaziz5916]

Thank you Jon. These videos were amazing.

[@mukundjoshi598]

This is so damn good man. i am loving your presentations. i am gonna rock at office using these tricks. thanks you :)

[@Chaseaction-outdoor-activities]

excellent!!!

[@kubannaidoo3914]

I seem to be in the same position of a few people. I use Excel but now at a new job I have to do reports.Brilliant tutorial. Thank you so much for the videos that you have created.

[@John-lo6ck]

You are an angel, my friend. Thank you so much for sharing your knowledge. My professors and I thank you.

[@MasterDesignss]

nice... thanks

[@video_banani_nahi_aati]

Most of the useful information is in this video..... Thank you.

[@samuelobure3074]

Once again Thank you very much. I can't believe I have all these in less than an hour. Thank You once more

[@anilpradhan885]

An old dog is learning new tricks; and enjoying it! Thank you for these instructive videos. I'm from the Lotus 123 days!!!

[@morsheda.chowdhury8119]

Thanks Jon, I have learned a lot from you.

[@AEARArg]

Incredibly Useful Tutorial. Will save me tons of time. I work with excel every day.

[@manoharraogopisetti5000]

Explained in simple terms. Very Informative. Thank you Jon

[@shaharyarchagani5035]

Very Very Informative. You covered all the things in an obvious way. As a beginner, I found this extremely helpful. God Bless You. Thanks Jon.

[@longhuynh36]

Great tutorials Jon. Thank you so much!

[@ezadin0516]

Thanks very much sir for uploading this video and helping us understand Pivot Tables

[@abhijeetmore2769]

The clarity in explanation makes it very easy to understand Pivot function. The probable questions that might pop up in viewer's head get covered in due course of video. Thank you John.

[@ferrao1970]

Hi Jon, I'd like to thank you for sharing your knowledge its probably the clearest and easiest training to follow that I have seen so far....One again THANK YOU very much!🙏

[@ExcelCampus]

Thanks for your feedback! 😀

[@danjiao5398]

Thanks a lot! So helpful! Make things easy and clear!

[@RafeeKaleel0773401352]

You rocked it Jon.. It helped me really a lot.. Thanks so much mate.

[@cycleSCUBA]

Excellent series of 3 videos. The slicer takes the dashboard to a different level. Steadily working through the 3 videos has been well worth it. 10/10.

[@fahimakhan9443]

i have gone through so many tutorials but none of them are as informative as your videos. They are so easy to understand very excellently presented

[@greggoriusevan5152]

I Wanna say Thank you so much for making this video, it's very helpful for my next presentation. i hope more videos like this coming up

[@donpablu]

thank you so much for this series. so helpful!!

[@eugeneboakyeyiadom9343]

it is best demonstration of pivot tables that I have come across. simple to follow and understand

[@knng2008]

Easy to understand - the best excel tutorial series to follow along i have come across!

[@evelynlavie9668]

very simple and clear. thanks Jon

[@issatomusakamara4417]

Honestly, I am very impressed and highly appreciated by the following; 1. You speak clearly and little bit slow compared to others 2. Your videos are quite visible 3.Your lectures were presented systematically and chronologically Recommendations please help make available more lectures in excel especially, the extensive use of excel in analyzing data. I am : General Issato Sierra Leone Freetown West Africa

[@vcast525]

You are so thorough in your explainations of pivot tables and dashboards that is is so easy to comprehend. Thank you so much for your videos Jon! This has been very helpful!

[@suleimanshaik]

Thank you very much for making Pivot tables a lot more approachable.

[@isaiahonyango444]

Learning from you is a real eye opener. . . . . I am going to work on Pivot dashboards and wow my colleagues. . .

[@marycain5232]

Very helpful and presented for easy understanding

[@sarahnguyen1564]

Your videos are very helpful. Thank you so much

[@mwilangambi5104]

You are such a genius.... and I am definitely tapping from the abundance of your knowledge.

[@epsynadar7149]

Thank u for the video!! Very well explained in simple way

[@stevedoyle1125]

Absolutely fantastic presentation.

[@andrewmenmuir2177]

Fantastic. Clear, concise and I appreciate that I can download the example - thanks Jon

[@mohamedyusufmohamed6288]

I dont know how to thank u man 😊😊😊 your videos helped me to become more important at my job. It’s easy understand your video, thank u man 🙌🙌🙌

[@ExcelCampus]

Happy to hear that! 😊

[@jamesc6357]

Excellent tutorials. I only had to watch these once to have a solid understanding. Thank you!

[@deepeshnair5936]

Excellent presentation and thank you so much for such an informative video.

[@kimsordyl]

Thanks so much! Love these videos. Perfect to refresh for my upcoming interviews!