How to Create a Dashboard Using Pivot Tables and Charts in Excel (Part 3)
Вставка
- Опубліковано 29 вер 2024
- Sign up for our Excel webinar, times added weekly: www.excelcampu...
www.excelcampus...
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...
Please subscribe to my free email newsletter to get your tutorials like this and get updated about PivotPal.
Get PivotPal: www.excelcampus...
WATCH PART 1: • Introduction to Pivot ...
WATCH PART 2: • Introduction to Pivot ...
Subscribe to my free newsletter: www.excelcampus...
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.
Thank you Jon, I'm returning to work after a 2 year hiatus and needed a refresher, that was absolutely perfect.
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.
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!🙏
Thanks for your feedback! 😀
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.
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
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!
Jon, thanks for an easy to understand Excel tutorial, I have picked up a few tricks already!
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.
which company?
Incredibly Useful Tutorial. Will save me tons of time. I work with excel every day.
Extremely useful tutorial videos. I managed to grasp a firm concept of how to use pivot tables and pivot charts thanks to your simple yet informative explanations. Thank you.
Learning from you is a real eye opener. . . . . I am going to work on Pivot dashboards and wow my colleagues. . .
Thank you. Very useful
Jon, thank you for taking the time to explain pivot tables and dashboards in such detail and for providing the files! You explain concepts in excel better than anyone I've ever known. You're amazing!!!
I used to use Crystal Reports to make interactive dashboards - thank you so much for showing us how to do it in Excel. Great series - learned a ton. Colour me happy.
New to pivot tables and watched all three videos! Thank you Jon
Hi Jon, I must say that your three Pivot Tutorial videos are super amazing and easy to understand. Thank you a lots.
i only wish i can like this video more than once. very helpful, thank you good sir!!!
I am about to start internship as junior business analyst,
all your videos on pivot table are very useful.
Thank you so much. :)
You are such a genius.... and I am definitely tapping from the abundance of your knowledge.
All three videos under this headline has been extremely helpful. They are clear, concise, and easy to comprehend. Thanks a lot for the tutorial.
Thank you for all 3 videos. Very very instructional, informative and powerful. I am grateful for your time and knowledge and willingness to teach.
Easy to understand - the best excel tutorial series to follow along i have come across!
Thank you very much for such a nice, methodical tutorial on pivot tables, pivot pal and their benefits Jon. I will be looking for more of your videos.
AMAZING series of excel videos regarding Pivot Tables!!!!!! Amazing effort, really good examples... Conrats for your work and REALLY thank you for saving our time trying find out this info on the internet!!!!! I really appreciate it !!!!!
Thank you Jon for this informative and easy learning video series on pivot table. It is going to help me out at my work and interviews.
Thank you Ivan! :-)
This channel is awesome.I am learning and understanding excel easily. Thank you Excel Campus - Jon.
Very good video, from a very good series (this is part 3/3 of the series). Helped me a lot in understanding wha'ts Pivot Tables and how to use them. Thx John!
Great Job Jon really easy to follow and looking forward to playing with pivot tables... really well presented... thanks
Awesome Work Jon!! Really enjoyed watching your Pivot Tables tutorials! Your effort is greatly Appreciated!! Thank YOU!
This is an amazing tutorial and I love your presentation (very detail and concise). It helps me a lot for financial reporting. Thank you so much. You are our hero.
I found out it is not for free, but you absolutely deserve it. You have done a great job. Thanks.
Thank you, this series on Pivot tables, Charts and Dashboard was excellent. I certainly learnt a lot.
Hey Jon, pretty good, easy comprehensively covered the top for new starter
Thank you, your video helped me so much and i have created exactly the same dashboard which u taught in the video. i am your big fan now...today you were the life saver and yes i am happy Andy today....thank you
Awesome! Thanks for the nice feedback Nabila! :-)
Valuable and to the point - great tutorial Jon! Liked the keyboard short cuts, grouping and slicers - especially grouping the slicers and seeing multiple options within the select options. Thanks.
Thanks for making it more simple.
Thanks Jon, I have learned a lot from you.
Jon, your work and contributions are clear and concise and allow further platform to build upon. Thank you for your efforts.
Thank you for your sharing!!! I truly learned a lot from your video
Many thanks for this tutorial. Learned a lot from Part 1 to here.
I am little late entrant to this channel, but it easy to understand and can be implemented quickly, million thanks.
Precise,clear and very informative presentation.well done.
very simple and clear. thanks Jon
Hi Jon, your video tutorial has been tremendously helpful, very easy to understand and remember as well. God bless you and your family. Thanks a ton.
Very helpful! Your teaching style really works for me.
Thanks for the tutorial on Pivot Tables; it has helped me a great deal.
Thank you very much for the 3 videos. Very informative and easy to apply
An old dog is learning new tricks; and enjoying it! Thank you for these instructive videos. I'm from the Lotus 123 days!!!
Awesome!
Thank you for this valuable lesson!
Thank you for these 3 videos. Very nicely done.
Jon, OMG! I love you. This was so simple, unbelievable. I can say that because I tried learning this via my company's learning tutorial and it was so difficult. And your soothing voice made it so much better. Thank you. Do you do other tutorials?
best video i have ever seen on dashboard using pivot table
You are awesome! Thanks so much for making this information available and so clear and well taught!
You are so welcome! 😀
This is very useful too me. I thought 2 my IT colleagues were doing wonders, but I could do mine after 2 days of playing and watching it.
Thanks Jon! I saw all the videos about Pivot Table & Charts... they're awesome! Thanks a lot man!
Thanks Paolo! ;-)
Amazing. . Definitely one of the best tutorials on Pivot Tables.
Thanks much.
Dear Jon, thank you very much for the excellent videos, they are very helpful in getting started with pivot tables and are definitely an important tool to have!
Hey Jon, these videos are so amazing, today I knew nothing about Excel. Now I know a lot about =vlookup, pivot charts, slicers, filters, how to make a dashboard. You have taken me to another level. Just subscribed, will be checking more of your channel soon. :)
Thank you for subscribing. 😀
Excellently Explained, thanks
awesome overview on Pivot Tables
Amazing and a very well-explanatory video. Thanks Jon!
very professional..crisp and clear..thanks for sharing!
Hey John, Thank u for your simple explanation, it was very easily to understand...!
Bro you are amazing thanks for such high quality content
I appreciate that, Azfar! 😀
Great, clear & easy to follow. Best tutorial I've seen.
Thanks Ulkar! :)
Thank you very much for your videos, it is very clear and helpful! I have learnt a lot from your videos. Keep up the great work!
Thanks a lot Jon. Your way of presentation and the content together were simply awesome. Please keep up the good work you have been doing so far.
I am so excited to learn this new skill from your video, very useful! Million thanks, Jon!
Very useful. Nicely explained.
This is so helpful. Thank you Jon
Thanks a lot for this helpful tutorial!
Thank you so much for your clear and informative presentation. You're going to make me look like a rock star!
Hi Jon, Thanks for sharing a brilliant video. Very well explained.
Waw waw! all i can say im ready to be the next M & E Specialist...my dashboard is done for profiling small scale farmers!! thank you Jon
Thank you!!!!!! Very very very informative and well explained video.
excellent presentation - enjoy all the parts. thanks for sharing
Thank you so much Jon..because of you i got appreciated by my boss
Have you thought of making any interactive challenges? I think your videos are fantastic but I think I would learn even more if I was given a task and had to figure out how to do it myself! Thanks
Thanks Jon! helped remove the pivot-fear!
Thank you for the best tutarial on dashboards!
I enjoyed watching this video and recommend others to watch
Thanks for educating the community and appreciate your volunteership.
Keep posting some more videos.
Thanks a bunch
Hi Jon. thank you for producing this great video, easily understood, and doesn't took longer time as compared to other youtube vids. Sometimes it is so exhausting to listen to a 1 hr vid. but yours, everything is explained in a very short time. I'm looking for your next vid.
Thank you for your feedback! 😀
Really good stuff!!! Thanks for sharing.
This is a GREAT series Jon! Thanks
Thanks very much for sharing your knowledge. It was a great tutorials. I have learnt a lot.
Thanks its great learning on Pivot Table..
Thanks Jon. Learning new stuff.
Very helpful. Great work Jon.
Amazing work John, thanks for sharing!
Pure gold! Thank you for sharing!
Great Video! Very powerful & informative. Thanks a lot!
learned a lot and easy to understand....thanks Jon
Great video! I'd love to share your work with my students/subscribers.
This is wonderful! Thanks!
Very informative and useful. Well done.
very informative. Thanks Jon
Awesome video,it's really helpful
Thank you Jon.
Thanks so much!! Haven’t had to build this out in a while and this was so helpful!