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

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.

[justmeha]

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.

[ronaldmelendez]

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!

[sbow]

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

[JOHNCARLWILLIS]

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

[violynenguti]

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

[feelzie]

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!

[nicholasnorman]

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!

[rfxsknn]

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

[denisesingh]

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.

[williampalmer]

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!

[fotinivakalopoulou]

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

[leonardogranados]

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

[shivashankerb]

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!

[ronsimonsen]

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.

[feliciataylor]

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.

[selvanaiyadurai]

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

[anada]

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.

[charlessotis]

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

[kenlynch]

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

[kristinloehrmann]

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!