Introduction to Pivot Tables, Charts, and Dashboards (Part 2) 

The key feature of this presentation is the slow pace of explanation. A good instructor.

Last quarter of 2024 found this very detailed and easy understanding his explanations and process. Thank you so much for your videos

I'm starting to my new job tomorrow and I don't have any clues about Pivot tables. I'm so glad that to find your training video. I learned a lot today. Thank you so much.

I hated pivot tables but watching your videos, I'm liking it now. Thank you so much

I realize the video is old, and it has a lot of great data. I hope that the material is updated to reflect the latest office versions. In this video you mentioned adding new data to the data tab and then you had to update where the pivot is pointing. If you'd just make the data list on the tab as a table, and point the pivot to the table as a whole, the data updates automatically when you click Refresh without having to continually update the pointers. I pull data through ODBC into Excel and the day I learned about data tables was a life saver. Thank you for the invaluable tips you've shared in this series.

This is going to save my life for years as a junior data analyst

I really appreciate that you take your time to explain everything at normal speed, Some people go too fast. This is the best video that I have seen on pivot tables.

I feel very confident after listening to your tutorial. Thank you for being so thorough and keeping it so simple.

You have no idea how grateful I am to your videos. I have been wanting to learn and become an Excel Guru like you. Thank you again. Peace

Wow! what a great tutor you are! I had NO clue what pivot tables were and have an interview next week that I was told I will be tested on this because the last person that they hired told them they were an Excel expert and were NOT! I am so confident that I will be able to ace the next interview! Thanks so much for this invaluable information!

I never had any formal excel training, with excel campus, Jon have help me improve my efficiency. No wonder then your videos are that popular. Thanks Sir.

These are excellent videos and you are helping hundreds of thousands of people around the world. THANK YOU..

Well, I am quite impressed by Jon's videos. I am much older than the majority of people who are watching these and a LOT less computer savvy, so I can say that, if I can learn how to manipulate these Excel files into a nice and easy-to-read data format, then anyone can.

I know this is a little outdated now but hands down the easiest video to follow! Thank you so much and thanks for all the short cuts! These series is AWESOME!!!!

Been using pivot tables for years, yet i still comeback to refresh on things you taught here.

This has been really useful to me so far- even 6 years later on a slightly newer Excel release- Thank you!

I feel so much better and less stressed after watching this step-by-step video. I love the way you teach, you are the first one that makes this less stressful for beginners like myself. Thanks for putting your knowledge out there.

I am learning this for a potential job and loving how detailed these lessons are. Thank you for sharing this with us

Being an undergrad student studying health data analysis and not understanding what I am even looking at, YOU have made EVERYTHING understandable in the utmost easiest way. I am SO grateful for your tutorial because I am learning incremental details on little things I haven't even understood yet or have yet to learn. Thank you so much

Host is a knowledgeable person and teaches very well Please keep post some more videos

Jon, this isn't my first time watching your videos and trying to learn, but this is the first time I'm doing it without being overwhelmed with anxiety. I need to develop these skills for a new job and I look forward to using them with confidence when called on and it's all because of you. Thank you!

Almost a decade and Excel Campus is saving lives. your tutorials makes me want to dive more into Data Analytics.to think that I almost gave up. Thank you so so much.

I've been putting off learning about pivot tables and playing around on my own, a lot of wasted time.... These are great tutorials and well thought out and presented. I'm going recommend to my staff that they take up some time to watch these.

Thanks so much, you are the first excel expert that can actually explain it!

I've been struggling to find an opportunity of data analyst in toronto for a year now- such clips calm me down in my frustration....,

Was able to get most of my dashboard done through listening to these two videos.

Amazing! Just what I needed for my interview tomorrow! Great pace, very easy to follow! Thank you!

You should consider teaching in colleges! Your instructions and method of teaching are great!!!!

Your lessons are very simple and interesting. It very easy to understand and the pace is great for explanation. Great help. Thanks a lot !

I just happen to run by this video by accident while searching for a quality learning video for pivot tables and was very pleased with this one. It clearly explained each step for setting up your pivot table and dashboards. Excellent learning tool.

This series is as good, if not better, as any college course I have taken. Nice pace, friendly, clear instructions-outstanding!

I have been looking for this kind of information for years! You make it so easy to understand and follow. I just got a large data set that I need to analyze and this is going to help me out HUGE! Thank you for posting this!

A video published in 2015 still found to be useful in 2022

Honestly, its absolutely genius to give a tutorial on how to manually do things in excel and offer a product with-in the tutorial that will help speed up the process. I would bet they have sold many copies of the Add-on. mad respect for the transparency and knowledge shared.

For anyone who gets a blank value for (blank) in count of quantity: when you change (blank) to shipping fees, make sure you also type in values of 0 for quantity. I noticed in my source data that these values were blank, but when I changed the blank values to 0 the count of quantity changed from nothing being there to 8.

These videos are a great resource for people in the trenches. Thank you, Jon. You take your time, don't race through what you are showing, and break everything down into understandable parses.

Clear, simple, and easy to understand. Perfectly matched my needs for a presentation. Best Tutorial on the web. Is there any other tutorial regarding Vlookups and Conditional Formatting (if, else if statements)? Thanks

Jon- You are wonderful. Had i checked your channel some years before, i would have gained so much knowledge.

amazing loved it. worked with pivot tables never knew these sort of options existed

Its funny the ads on your tutorials are for Pivot table courses. Your video blows away the need for the course. Great tutorial!

Thanks. Very helpful.. My Excel knowledge is very limited and I'm excited to apply some of this!

Jon, you rock. Within 30min you provided the insight necessary to use this Excel function. I can't even express how much it's increased my efficiency in analyzing large data sets as I manage multiple supply chains.

THIS IS SO GOOD, AM LIKE ANDY IN REAL LIFE, THANKS JON, GOD BLESS

It's been almost 5 years since i last used Pivot Tables. You've given great clarity to how I format the information. Thanks so much. Clear, concise and you know how to translate excel language to what we understand easily. Not everyone can do that! Thanks, again.

I have a interview and was asked do I have specifically; pivot tables, v-look up and concatenate filters. This was a great help. So, I would I be able to demonstrate on it interview?

Your videos are awesome. You really helped me understand how to make killer presentations.

Wow! Awesome info! Can't wait to watch video 3! bravo!

Thanks John.....your presentation on how to creat dashboard and pivot table is quite exciting. For the past 10 years in my career, I have never known how to create one.

Wow jon, youre such a good tutor In excel... Great job👍🏻

Thanks, a whole lot Jon, your videos are so well organized and the way you explain things is just so easy to grasp. You also foresee possible questions people could have and answer those questions without anybody asking.

Note: you can also double-click in the quantity/count area of the pivot table for "blanks' and it will redirect you to a new tab and list all the columns of data that the blanks refer to.

You are an amazing instructor! The ability to communicate your knowledge of the subject makes Pivot Tables easy to understand. You are tremendously helping me to do better at work. Thank you.

Hi. Many thanks for the help getting to grips with pivot tables. Do you know if there is any way of getting some data or a worksheet to play around with in around to help learn how to use?

I really like it how you only promote pivotpal at the end of the video, so that those who are not interested can just leave the video and not be bothered by it. these guides are very easy to understand and provide plenty of knowledge even for some more experienced users. thanks

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. Learn more about PivotPal: www.excelcampus.com/pivotpal Watch video #3: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-FyggutiBKvU.html Please leave a comment below with any questions, and hit the like button if you enjoy the video. Thanks again for your support!

You made me fall in love with Pivot Tables which I never thought was possible! Thank you for the excellent work Jon!

wow!what an explanation am blessed

Your are a great tutor. I have been checking all the videos that Lynda has to offer about Pivot Tables, they are good but they are too long, I always as well as my coworkers end up falling at sleep. I'm an analyst and I use data every day. Thank you so much.

Amazing coverage dear Jon. I am so more confident to use Pivot Tables and their features. Thank you very much!

Thanks for this Jon. You are a burning candle that lights others. Used to think I know Excel while doing everything manually and using formulae. Now am going back to kindergarten. See you in class!!

these videos have already made a significant improvement with how I work! Thank you. Well done.

I've tried variuos pivot table tutorials before. Jon's is the easiest and simplest to understand thus far.

Its very helpful. Thanks for explaining the best use of Pivot tables

Jon, you are my new superhero! I have an interview tomorrow and although I do know how to create a Pivot table just enough to be dangerous, you really helped me to remember some things and you also explained some things I didn't know!!! Thanks for this! I am now subscribed and will be coming back for a refresher as often as I can.. THANK YOU!!!!

This lesson has given me confidence in handling pivot tables and data analysis.

Please keep providing these type videos. Very helpful.

This just gives me another reason to live and work! I was thinking to retire early because I can't bear the boredom of working with Excel. But I guess I have been working the wrong way and spent too much unnecessary time doing things I could do within 15 minutes :) thanks Excel Campus, you just saved my life time :D

Simplicity is the key to smartness and you totally proved it in this video. Keep the great work.

Thanks Jon. The teaching is very helpful

Watched all three of the tutorials, thanks you so much, most useful and easily explained

This is really great and made Pivot table very very easy to use.

I am excited to go forward learning Pivot Table for my work through your kindness. Thanks for Excel Campus and to you sir Jon.

Excellent teacher and excellent information! I was intimidated by Pivot Tables in the past, but now, with some practice, will be able to do them with confidence. THANK YOU for a great video and the excellent information. Nicely done!

Really good tutorial for pivot table and dashboard than I had learned at university a while ago.

Your videos are great. Easy to follow. I have downloaded the data file and have been playing with various pivot tables. Thank you ! Chris K.

This is a fantastic tutorial! I had to do an Excel test which was quite advanced and I've never used Pivot Tables before, this is just so clear to understand so a massive THANK YOU!

The demos and explanations are par excellence! Need I say more? Thanks a lot.

Very simple, practical and quick. Thank you very much. Please make more videos for finance professional and analysis in your way.

you are awesome and just. no unnecessary word and to the point. i wanted to learn excel but lost motivation. but now i am inspired and once again thanks to u sir and wish you all the best

This is GREAT. I'd recommend to download the files to practice along with Jon. A few dates back I had no clue what dashboard was, now I can built one. Thanks Jon.

OMG! I know this video was made more than 3 years ago but I simply forgot about Pivot. The last time I made one was during my BPO days in the Philippines! Thank you Excel MVP for making these tutorials. It really brought back some memories again. I just subscribed and will watch Vid #3 after this then move on to VLookup and more of your tutorials! Thank you!

Your videos are BEST EXPLANATIONS ever!! thank you Excel Campus. Thank you Andy and MR Jon..

My husband just started a new position at his job and this is going to be a great tool!

An easy and straightforward way of teaching... Thank You!

Jon, you input has been immense, thank you for your contribution and sharing of that which you have found useful.

Thank you, thank you for these introductory videos.

gr8 work Jon. it helps me a lot to clear the myth that pivot table is complicated.

Very nice job of instructing how to use Pivot Tables! Thanks for your efforts!

Jon ,I like your lesson on pivot is awesome so easy .Thank you for sharing for few minutes time .I learn a lot nice and easy.

Honestly, this is the best Excel class I've ever seen!

bro i m soooooooooooooooo thankful to u, as ur video taught me so well i got job in a multinational company due to command on dashboard, thanks bro may God bless u for your doings

A worth to watch video.Each minute of this video is totally beneficial.

By far the best interactive video I have seen on Pivots. You help me a lot in my career, thank you very much!!

Will rewatch video's. It takes a bit to really wrap your head around pivot tables. But your video's are so helpful. Thank you Jon

Thank you and thank you. Your videos are so easy to follow.

This tutorial makes pivot tables so easy to understand. Looking forwards to the dashboard creation video next.

Hi Jon, I have been watching the pivot tables and dashboards, it's worth watching , thank you so much for providing these videos.

Awesome tutorial! You explain so much with in 15 minutes......this is fantastic! .

Great Videos - easy to understand. As a heavy user of Excel I used to wonder why people got so excited about pivot tables. Now I know!

Dear Jon, Thank you for sharing these beneficial videos. These videos help me to shorten the time I spend for pivot tables.