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

Поделиться
HTML-код
  • Опубликовано: 17 янв 2025

Комментарии • 1,3 тыс.

  • @zoemeanslife
    @zoemeanslife 4 года назад +181

    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
      @Pkgreat 8 месяцев назад

      which company?

  • @Damian-lu8sx
    @Damian-lu8sx 3 года назад +47

    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!

  • @wadeweisman4745
    @wadeweisman4745 8 лет назад +10

    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
      @ExcelCampus  8 лет назад +2

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

  • @BigBigVideos
    @BigBigVideos 7 лет назад +1

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

  • @maggiemae3825
    @maggiemae3825 4 года назад +3

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

  • @AnalyticsInDetails
    @AnalyticsInDetails 7 лет назад +2

    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.

  • @ba8e
    @ba8e 7 лет назад +12

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

  • @billphair8169
    @billphair8169 4 года назад +1

    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.

  • @Gha6i
    @Gha6i Год назад +5

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

    • @ExcelCampus
      @ExcelCampus  Год назад

      Thanks for the feedback @Gha6i 😀

  • @abhijeetmore2769
    @abhijeetmore2769 7 лет назад

    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.

  • @IheartmeandL
    @IheartmeandL 2 года назад +4

    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.

  • @issatomusakamara4417
    @issatomusakamara4417 7 лет назад

    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

  • @sgroiberry
    @sgroiberry 7 лет назад +8

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

  • @allan-5141
    @allan-5141 7 лет назад +1

    The Pivot Table videos are great. I am in the process of searching for a new job and anytime a job posting requires
    'advanced" Excel skills, they always put Pivot Tables and Macros in parentheses as the two things that separate the men from the boys. Whether it be fixing a leaky faucet or learning a software package, I really appreciate the people like you who take the time to share their expertise.

  • @achrafemami328
    @achrafemami328 9 лет назад +73

    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
      @ExcelCampus  9 лет назад +1

      +Achrafe Mami Thank you Achrafe!

  • @leobonnes5143
    @leobonnes5143 Год назад

    Still relevant in 2023 with Office 365. Sure some of the menus have changed but I was able to replicate everything that was done in these 3 videos 8 years after this was uploaded. Well done Jon!

    • @ExcelCampus
      @ExcelCampus  Год назад

      Thanks so much! I am planning to update the videos. I can't believe it's been 8 years! 🙂

  • @lazoqaradaxi5254
    @lazoqaradaxi5254 8 лет назад +144

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

  • @vslingam000
    @vslingam000 7 лет назад +2

    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.

  • @kodjohounnake6099
    @kodjohounnake6099 7 лет назад +8

    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!

  • @ramya3928
    @ramya3928 4 года назад +1

    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.

  • @oliviajones3753
    @oliviajones3753 6 лет назад +4

    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!

  • @fahimakhan9443
    @fahimakhan9443 4 года назад +1

    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

  • @alivelizade7377
    @alivelizade7377 9 лет назад +40

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

  • @Q8illusions
    @Q8illusions 8 лет назад

    Jon, in mid September the head of the department I worked out requested I created a dashboard for a MASSIVE data file, to be handed in at the end of this month, and I honestly did not know what I was going to do. Your tutorial is excellent and you are a HERO man! I cannot wait to go to work tomorrow and start working on it.
    Thank you

    • @ExcelCampus
      @ExcelCampus  8 лет назад

      That's awesome! Thanks so much for letting me know. I love to hear that you are excited to go to work and work with Excel. I am the same way, and pivot tables are an amazing tool with a lot of possibilities. They really allow us to be more creative with our work. Thanks again!

  • @winniewaudo5662
    @winniewaudo5662 4 года назад +5

    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.

  • @tammiefrancisque8182
    @tammiefrancisque8182 8 лет назад

    Jon, I've shopped around through lots of Excel tutorials. Yours is by far the easiest to follow and simplest to digest. Its not so intimidating with you at the helm! Thank you so very much. I've bookmarked your page.

    • @ExcelCampus
      @ExcelCampus  8 лет назад

      Thank you so much for the nice feedback Tammie! I really appreciate your support and am excited you are here. :-)

  • @PK-ms5fb
    @PK-ms5fb 9 лет назад +26

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

  • @naseema1982
    @naseema1982 Год назад +1

    I watched other videos on the pivot tables and charts but they are not as good as your videos. All 3 series of videos are really helpful and easy to understand. Thank you.

  • @elizabethkrenke
    @elizabethkrenke 7 лет назад +16

    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
      @gslvqz8812 6 лет назад +1

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

  • @jindapornasairat2087
    @jindapornasairat2087 8 лет назад

    I am about to start internship as junior business analyst,
    all your videos on pivot table are very useful.
    Thank you so much. :)

  •  7 лет назад +6

    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.

  • @vcast525
    @vcast525 8 лет назад +1

    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!

  • @NHYarris
    @NHYarris 7 лет назад +3

    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!

  • @lmanguerra4025
    @lmanguerra4025 8 лет назад

    This is the best video I've ever watched on dashboards and slicers. Your explanation is very clear and fluent. There's no stammering to get distracted with. thanks for sharing!

  • @qwenda11
    @qwenda11 9 лет назад +4

    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
      @ExcelCampus  9 лет назад

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

  • @jacksontucker1868
    @jacksontucker1868 7 лет назад

    New job starting Monday. You sir deserve a medal. Very helpful, informative, and down right kick ass. Not all hero's wear capes

  • @AnonymousAnonymous-hh6uj
    @AnonymousAnonymous-hh6uj 7 лет назад +3

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

  • @sandypie2832
    @sandypie2832 4 года назад +2

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

  • @amkiap2715
    @amkiap2715 8 лет назад +3

    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!

  • @ChrisTaylor-xk3hc
    @ChrisTaylor-xk3hc 8 лет назад

    Thanks Jon - I've always been considered good at Excel but didn't realize how many extra 'features' had been snuck in such as these Pivot Tables. 3 videos giving exactly the introduction I need with a hint of how deep the rabbit hole runs. Thank you. [Now I need to go away and play :) ]

  • @natashadavis9817
    @natashadavis9817 7 лет назад +3

    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)

  • @cycleSCUBA
    @cycleSCUBA 3 года назад +2

    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.

  • @sidraines
    @sidraines 8 лет назад +15

    Amazing 3 part video. Learnt so much from these!

  • @mitfreude1677
    @mitfreude1677 4 года назад +1

    Thank you Jon for the Tutorial, I got my first online job because of your Pivot Table and VlookUp series. Everything is understandable. You earn a subscriber!!!

  • @Lilishkaleyla
    @Lilishkaleyla 7 лет назад +4

    Thank you for the best tutorial about dashboards!

  • @Isaactibenkana
    @Isaactibenkana 4 года назад +1

    You are an excellent instructor. Your demonstrations were simple and professionally presented. Thank you for sharing the knowledge.

  • @m.arsalanhassan5365
    @m.arsalanhassan5365 7 лет назад +3

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

  • @ferrao1970
    @ferrao1970 Год назад +2

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

  • @robertc2121
    @robertc2121 7 лет назад +10

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

  • @maryannholt1287
    @maryannholt1287 7 лет назад +1

    I had never seen a Pivot table created and I just appplied what you demonstrated and I created a pretty nice Pivot table and dashboard for a beginner! Thanks!

  • @peterbell3199
    @peterbell3199 8 лет назад +14

    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
      @netrom371381 6 лет назад

      did anyone find a solution for this problem?

    • @ma.margaritacopon5464
      @ma.margaritacopon5464 5 лет назад

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

  • @aladinzahran
    @aladinzahran 5 лет назад

    I found out it is not for free, but you absolutely deserve it. You have done a great job. Thanks.

  • @farougosmanabdelmukaram3173
    @farougosmanabdelmukaram3173 7 лет назад +3

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

  • @speedytan1402
    @speedytan1402 5 лет назад

    All three videos under this headline has been extremely helpful. They are clear, concise, and easy to comprehend. Thanks a lot for the tutorial.

  • @youngterk2101
    @youngterk2101 7 лет назад +5

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

  • @SamSam-ky8wp
    @SamSam-ky8wp 4 года назад

    Hi Jon,
    I'd like to thank you for sharing your knowledge to millions of viewers around the world. Nothing is more precious that someone make a compliment and appreciate your effort after few years from the time you released this video. That means, good deed will last for ever no matter what.
    Cheers!

  • @docofsoil
    @docofsoil 7 лет назад +5

    Thank you. Very useful

  • @altagraciasantaana6031
    @altagraciasantaana6031 4 года назад +1

    This tutorial is very helpful!!! I've watched the three videos and I have now a clearer understanding of pivot tables and doing a dashboard. THANKS!!

  • @mukundjoshi598
    @mukundjoshi598 7 лет назад +3

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

  • @RolyVento
    @RolyVento 6 лет назад +1

    Thank you Jon, I learned a lot from this particular video. The way you explain things and your soothing voice makes the video enjoyable. Please don't stop teaching.

  • @Chaseaction-outdoor-activities
    @Chaseaction-outdoor-activities 7 лет назад +5

    excellent!!!

  • @donks5306
    @donks5306 7 лет назад +1

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

  • @HolyQuran0992
    @HolyQuran0992 7 лет назад +4

    nice... thanks

  • @lyip4382
    @lyip4382 6 лет назад

    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.

  • @ExcelCampus
    @ExcelCampus  8 лет назад +171

    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
      @jitendernegi4846 8 лет назад +2

      Excel Campus - Jon
      great and easily understand.
      thanks

    • @Ayieiyak86
      @Ayieiyak86 7 лет назад +2

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

    • @maimaparker500
      @maimaparker500 6 лет назад +1

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

    • @AmerIndianWarrior
      @AmerIndianWarrior 6 лет назад +1

      Excel Campus - Jon Thanks for sharing.

    • @gungurung36
      @gungurung36 6 лет назад +1

      Excel Campus - Jon #

  • @suraksha7841
    @suraksha7841 7 лет назад +1

    the pivottable and the dashboard is just a great tool... thank you so much for sharing this in such a easy way..

  • @knng2008
    @knng2008 3 года назад +1

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

  • @TrevorDsouza7
    @TrevorDsouza7 7 лет назад +1

    Awesome series of tutorials, really appreciate you adding the PivotPal section towards the end. It's generally a turn off when you come across one of those "salesy" tutorials that solely intend to sell a product. You on the other hand have been genuinely helpful even to those who are in a hurry looking for quick answers. Brief, concise and simple.

  • @brunolourenco462
    @brunolourenco462 7 лет назад +2

    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.

  • @phenyomolefe4162
    @phenyomolefe4162 6 лет назад +2

    Jon, I have watched your videos several times over, and there is always something I learn. Your content is clear, steps are logical and fitting to the tasks accounted for. Thank you.

  • @reneebailie8098
    @reneebailie8098 3 года назад

    I have watched and purchased other tutorials/certifications, this is by far the best! Excellent way of breaking it down to be understandable to all levels of learners! Thank you!

  • @shanai5711
    @shanai5711 3 года назад +1

    Definition of excellent teaching

  • @pizzolattomarcelo
    @pizzolattomarcelo 7 лет назад +1

    Hello, I'm from Brazil, and I'm learning a lot with your explanations, thank you

  • @happymckroblox3235
    @happymckroblox3235 8 лет назад

    I mean i know something about Pivot Table but i don't know it has so many useful functions, like "reporting connections" ! Awesome! Thanks for sharing your knowledge on this! Definitely VERY useful in my work!

    • @ExcelCampus
      @ExcelCampus  8 лет назад

      That is so great to hear. Thank you Weiyi! :-)

  • @quoctringuyen4709
    @quoctringuyen4709 4 года назад +1

    I watched 3 parts of your video. It's very useful and helps me so much when I begin 1st time with Pivot Tables.

  • @jamesc6357
    @jamesc6357 2 года назад +1

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

  • @martinkiongo447
    @martinkiongo447 6 лет назад +1

    2 years later and I have found these tutorials very helpful for a work project. Very well explained. Thank you John

  • @shaharyarchagani5035
    @shaharyarchagani5035 8 лет назад

    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.

  • @anilpradhan885
    @anilpradhan885 6 лет назад

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

  • @kubannaidoo3914
    @kubannaidoo3914 6 лет назад

    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.

  • @madhukarpoddatoori6686
    @madhukarpoddatoori6686 5 лет назад

    I am little late entrant to this channel, but it easy to understand and can be implemented quickly, million thanks.

  • @TheIrisiris
    @TheIrisiris 7 лет назад +2

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

  • @OliverDanielSJ
    @OliverDanielSJ 8 лет назад

    Thank you for the check list. I've downloaded all the 3 parts regarding Pivot tables and will go through them thoroughly at leisure to make sure I understand them completely.

  • @eatph5050
    @eatph5050 4 года назад +1

    Thanks for this! I was looking for a simple and easy-to-understand pivot table and dashboard tutorial months ago for work. Wish I stumbled upon this back then. Really helpful in my next projects.

  • @Dlwk0508
    @Dlwk0508 5 лет назад +1

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

  • @deepac1046
    @deepac1046 3 года назад +1

    All the three tutorials were very well explained. Awesome way of explaining and very comprehensive.

  • @AEARArg
    @AEARArg 6 лет назад

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

  • @yumyes6272
    @yumyes6272 4 года назад +1

    Super simplified, very easy to understand, excellent presentation, you nailed it. Thank you so much

  • @douglascapozzalo
    @douglascapozzalo 5 лет назад

    Truly a thing of beauty, Jon. Well done. Lot's of context in Andy's story. We've all been there. Specifically, though, I didn't know what a distribution chart was. I do now! But before you jump into what is clearly the most useful chart, please give us some context. Same applies for Slicers -- I didn't now what they are before you started explaining how to make them. Again, I loved it and will recommend you channel to everyone.

  • @seraidrakgoasi5974
    @seraidrakgoasi5974 3 года назад +1

    Thanks, this is so helpful, well paced and easy to follow. you have expanded my excel horizon 300% over!!

  • @OsaroOyegun
    @OsaroOyegun 8 лет назад

    These 3 videos have been the best on Excel that I have come across. Clear and concise instruction. I knew bits and pieces of excel iro pivot tables but the videos brought it all together with dashboards. Thank you and keep up the great work!!

  • @leebranch8067
    @leebranch8067 7 лет назад +1

    This set of three videos has been the best explanation I have seen. Thank you for taking the time to put these together.

  • @faddtayo
    @faddtayo 3 года назад +1

    i watched all three videos. thanks alot Jon. these videos are amazing. i have a presentation at work tomorrow. i know from the dashboard i am finishing up that i am going to totally rock. thanks so much for so much clarity.

  • @GbengaOkubadejo
    @GbengaOkubadejo 8 лет назад

    most simplified explanation so far! I'm recommending this right away.

  • @sv4nye
    @sv4nye 5 лет назад +1

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

  • @OfficeTrainingLady
    @OfficeTrainingLady 8 лет назад

    This was an amazing Video and very professionally done. Thank you for putting in the time and effort to explain things so clearly. Your voice is also very easy to listen to and your mouse movements are very concise, slow, and direct. I don't lose track of what part of the spreadsheet you are focused on.
    It is very common in computer training videos that the instructor makes unnecessary mouse movements (circles and swirls as they speak). It can get visually confusing. Again, thanks for such an amazing learning experience.

    • @ExcelCampus
      @ExcelCampus  8 лет назад

      Thanks for the nice feedback! It definitely took a lot of trial and error to get here, and I'm always looking to improve and enhance my videos. I appreciate your comments and will keep that in mind for future videos. I try to limit mouse movements, but sometimes I do the swirls. This is a good reminder to keep me conscious of it in the future. Thanks again!

  • @slgpotter
    @slgpotter 6 лет назад +1

    Thank you, Jon. I found your whole video series on Pivot tables very enlightening, informative, and highly educational.

  • @dhemson45
    @dhemson45 6 лет назад

    Much appreciated; steady and slow enough to stop, review my work on a spreadsheet, initiate tables/graphs and then start the video again.

  • @MrMrlosteruk
    @MrMrlosteruk 5 лет назад +2

    This is the series that inspired me to get better in excel. Watching it again, loads of tip bonuses too. This is why I subscribed. Awesome. Thank you 👍👍