Beginner's Guide to Excel Dashboards

แชร์
ฝัง
  • เผยแพร่เมื่อ 30 มิ.ย. 2024
  • My entire playlist of Excel tutorials: bit.ly/tech4excel This beginner's guide will help you get started creating a simple Excel dashboard. A dashboard brings all of the key information from a spreadsheet or workbook and displays it on a separate page in a way that is easily readable. This video is not meant to cover every aspect of making dashboards, but rather to introduce the idea and help you begin to build one. Here's the link to the Intermediate Guide to Excel Dashboards: • Intermediate Guide to ... #excel #exceltutorial #exceldashboards Join this channel to get access to perks:
    / @techteachersandstudents
    ***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa... Here's the practice file that goes with the video: bit.ly/dashboardinexcel
  • แนวปฏิบัติและการใช้ชีวิต

ความคิดเห็น • 203

  • @meekstylz9962
    @meekstylz9962 4 ปีที่แล้ว +139

    I hope you get enough interest to create the immediate and advanced videos.
    Thank you

  • @jovannikolic8032
    @jovannikolic8032 3 ปีที่แล้ว +12

    You are literally the best person on TH-cam to learn these from! The only thing I wish you did is that you upload these documents with data in them before you start working on them because it would help a LOT to have the same document and follow you step by step. Otherwise I am learning this and I have no documents, I just wanna learn it because I think I will need Microsoft office in the future. Thanks anyway

  • @kathyreese9373
    @kathyreese9373 4 ปีที่แล้ว +59

    I vote with the others. I would definitely like to see an Intermediate and Advanced lesson on Dashboards. Your tutorials are excellent!

  • @incinc9068
    @incinc9068 3 ปีที่แล้ว +7

    This is really great work - thank you so much. Very clear explanations and movements on the screen. You also have a good voice for teaching/narration.
    One thing I would have recommended in this case is to freeze the panes, at the header row so that when you scrolled/navigated to the bottom you could still see the headers of the data you were working with. In a small table, it doesn't matter so much. But when you have lots of columns, with similar looking data it comes in very handy!

  • @smoothpurehoney
    @smoothpurehoney 4 ปีที่แล้ว

    Loved this video this is exactly what I needed and more please create the intermediate and advance today please. I and many others would benefit from it greatly. What a fantastic teacher you are. Many thanks for your quality time. Priceless! Xxxxx

  • @allthingsknb
    @allthingsknb 3 ปีที่แล้ว +1

    What a wonderful Video! You pace things very well. This was easy to follow, and I feel like I can do this. I have never had to work with a lot of data in Excel until now, so I am starting from scratch.

  • @thatistruesophie
    @thatistruesophie 4 ปีที่แล้ว +3

    So good lessons! Thanks you so much, they are very helpful, cannot wait for your intermediate and advanced ones!

  • @odlinceanicet689
    @odlinceanicet689 3 ปีที่แล้ว +1

    You're pretty helpful with your tutorials I am studying Excel from 0 to where I am now. Thanks a lot.

  • @orion0923
    @orion0923 3 ปีที่แล้ว +1

    You my friend have the gift of teaching, God bless. Thank you for this tutorial.

  • @jeaninehaack1459
    @jeaninehaack1459 4 ปีที่แล้ว +2

    Yes! Please! More videos on this topic! I learn so much from you!

  • @jorgenieves4176
    @jorgenieves4176 3 ปีที่แล้ว

    I like how you explain things. Very straight forward. Thanks a lot. Look forward to watch other videos from you.

  • @jameshobbs9782
    @jameshobbs9782 4 ปีที่แล้ว +8

    Yes, I would interested in learning more about creating dashboards.

  • @Cruz0604
    @Cruz0604 4 ปีที่แล้ว +10

    Yea we want more videos spread sheets, advance, we always learn something new with your videos,
    Thanks

  • @stevensmith1448
    @stevensmith1448 4 ปีที่แล้ว +1

    As always great video, I would love an intermediate and advance video on dash boards, I’m already thinking of projects to use a dashboard ✅

  • @sparkygarrett
    @sparkygarrett 4 ปีที่แล้ว

    Really learned a lot watching this Beginners Guide to Dashboards. More, please!

  • @elenavaccaro339
    @elenavaccaro339 3 ปีที่แล้ว +1

    New subscriber, learning a lot.
    Whatever you are willing to teach, and willing to learn.

  • @lucyokolo-go6pl
    @lucyokolo-go6pl ปีที่แล้ว

    Have never understood excel in a simple way, like the way you teach....you are good

  • @axelace5136
    @axelace5136 3 ปีที่แล้ว

    I'm halfway with all of your videos with excel 🥰 I'm loving your videos thank you so much 🤩🤩🤩

  • @TheMercymerz
    @TheMercymerz 4 ปีที่แล้ว +2

    Thank you for this! Would love an intermediate then an advanced dashboard

  • @margaretdsouza3782
    @margaretdsouza3782 2 ปีที่แล้ว

    Thank you for sharing the practice file and the detailed information.

  • @Team8LA
    @Team8LA 3 ปีที่แล้ว +1

    Wow, all school teachers should be trained to teach like you. Thank you!

  • @anniewu4386
    @anniewu4386 4 ปีที่แล้ว

    Thank you for sharing!!! Super clear narratives!

  • @nahromusa6133
    @nahromusa6133 3 ปีที่แล้ว

    Dear Sir, Thank you with all my heart for your great video explaining the Dashboard. I would like to learn more from you Sir.

  • @jibdavidson1435
    @jibdavidson1435 4 ปีที่แล้ว

    Outstanding presentation. You have an excellent way of explaining the concepts. Simple, direct to the point, and no fluff.

  • @charmaleehoward4896
    @charmaleehoward4896 4 ปีที่แล้ว +2

    This was great! Please create an intermediate and advanced video. Thanks for being a great teacher.

    • @techteachersandstudents
      @techteachersandstudents  4 ปีที่แล้ว

      Here's the link to the brand new, Intermediate Guide to Excel Dashboards: th-cam.com/video/thmQ63nTn84/w-d-xo.html

  • @thandananiumlaw3428
    @thandananiumlaw3428 2 ปีที่แล้ว

    thank you. enjoyed this tutorial so simple so easy and appreciated the shortcuts too

  • @davepark1085
    @davepark1085 4 ปีที่แล้ว

    Many if these functions i never used. Thanks for sharing, i may need these in my next job.

  • @niallcolbert1815
    @niallcolbert1815 3 ปีที่แล้ว

    Thank you - very helpful from a "New to Dashboard" user!

  • @seandoc8463
    @seandoc8463 3 ปีที่แล้ว

    This is amazing!! So helpful, thank you! If you haven't already then please do upload intermediate and advanved dashboard tutorials. Will check through your channel now in case it's already there. Liked and subscribed

  • @excelworx8712
    @excelworx8712 4 ปีที่แล้ว +1

    Great intro to dashboards. Waiting for the intermediate and advanced level videos

  • @tanyafriedman7434
    @tanyafriedman7434 4 ปีที่แล้ว

    Very good! Yes, please post videos on more advanced dashboards.

  • @ivinarias4480
    @ivinarias4480 2 ปีที่แล้ว

    Awesome basics! you make it look so easy. I see the comments are a year old and wonder if you have Intermediate and Advanced lesson on Dashboards yet

  • @benjaminnoine9246
    @benjaminnoine9246 9 หลายเดือนก่อน

    Yu are the Best Trainer in this area. Very sharp & clear.

  • @Sparky48236
    @Sparky48236 4 ปีที่แล้ว +2

    Your tutorials are amazing. Your teaching skills are flawless: just enough material to be readily absorbed, presentation organized with no detours or irrelevant fluff, and a delivery that is calm, engaging and inspiring. Thank you for all that you bring to us.

  • @somewhereupthere
    @somewhereupthere 2 ปีที่แล้ว

    This was awesome, you're a fantastic teacher!

  • @chandrachester2149
    @chandrachester2149 4 ปีที่แล้ว

    Definitely interested in the intermediate and advanced dashboard. I have been thrown in a position where I need to be able to create them.

  • @jamiebennett3402
    @jamiebennett3402 3 ปีที่แล้ว

    This was so helpful!! Thank you.

  • @quentindaniels7460
    @quentindaniels7460 4 ปีที่แล้ว +43

    You know your a “nerd”, when you literally get giddy over learning something new in Excel. Great video! 👍

    • @giulianamatamoros9349
      @giulianamatamoros9349 4 ปีที่แล้ว +1

      This is LITERALLY how I’m feeling right now

    • @msabedra1
      @msabedra1 3 ปีที่แล้ว +1

      Nerds rule the world

    • @jaynetaylor5208
      @jaynetaylor5208 3 ปีที่แล้ว

      Since covid I’ve found Excel tutorials increasingly comforting?!

  • @findingtina7967
    @findingtina7967 4 ปีที่แล้ว +75

    Definitely interested in more advanced dashboards.

    • @captainfancypants1877
      @captainfancypants1877 4 ปีที่แล้ว +5

      Yes. Please make a video for more advanced dashboards.

  • @saradhurgham7557
    @saradhurgham7557 4 ปีที่แล้ว

    crystal clear! great efforts!

  • @serdartrawelco615
    @serdartrawelco615 3 ปีที่แล้ว

    Hello. Simple and clear explanation. Thanks a lot.

  • @TheMkelley25
    @TheMkelley25 2 หลายเดือนก่อน

    Thank you, this was VERY helpful!

  • @arwaazayem9280
    @arwaazayem9280 4 ปีที่แล้ว +3

    youre a hero! thank you

  • @theophilusdada1222
    @theophilusdada1222 3 ปีที่แล้ว

    Thanks for the simple and precise vedio. It's really helping

  • @adrianvivas4953
    @adrianvivas4953 3 ปีที่แล้ว

    Hi from Argentina! Great video, greater teacher!!!

  • @b.l.w.2136
    @b.l.w.2136 3 ปีที่แล้ว

    Thank you for this it’s going to help me in a big way

  • @darreledunbar3661
    @darreledunbar3661 4 ปีที่แล้ว

    Great video! So clear

  • @jayachandram4611
    @jayachandram4611 2 ปีที่แล้ว

    This is just wonderful for beginners..
    Thanks alot..

  • @sourabhsharma3110
    @sourabhsharma3110 2 ปีที่แล้ว

    Thank you so much for this informative video.

  • @MotorjockMike
    @MotorjockMike 4 ปีที่แล้ว +1

    Very easy to understand!

  • @oseiantwienoch8949
    @oseiantwienoch8949 ปีที่แล้ว

    I’m loving this❤it is really teaching me alot😊

  • @luthfysetyawan4606
    @luthfysetyawan4606 2 ปีที่แล้ว

    Thank you for the tutorial!

  • @breenr2020
    @breenr2020 3 ปีที่แล้ว +62

    you could be the reason for me graduating college

  • @ramchandramotilal6186
    @ramchandramotilal6186 2 ปีที่แล้ว

    Very clearly put together

  • @niketarb
    @niketarb 4 ปีที่แล้ว

    Hi,
    Please create intermediate and advance guides for Macros...... love the content sir you are doing a great job, your videos are very helpful. Thank you so much!!!!!!

  • @yoshanfernando4806
    @yoshanfernando4806 3 ปีที่แล้ว

    really helpful to do my assignments 👌🏾

  • @meha1233
    @meha1233 3 ปีที่แล้ว

    That was great. Thank you. I’ll go to watch other videos👍

  • @adeolaadeyanju1606
    @adeolaadeyanju1606 4 ปีที่แล้ว

    Thanks this was short and very useful

  • @zaksav
    @zaksav 3 ปีที่แล้ว

    Looking forward to the intermediate and advanced videos on these

  • @josephbarredo3
    @josephbarredo3 4 ปีที่แล้ว

    very clear, easy to understand watching dubai thank you so much

  • @walkerjames4348
    @walkerjames4348 3 ปีที่แล้ว

    This is great. Bring on the next level

  • @scottolson4541
    @scottolson4541 4 ปีที่แล้ว +9

    This is awesome! I never learned how to do this! Can you use a dashboard on data in Pivot Tables? Because this is a really good Idea and could bring all my pivot tables together.

  • @libertypingul9773
    @libertypingul9773 3 ปีที่แล้ว

    Thanks a lot for sharing your knowledge. :)

  • @exwhyz33
    @exwhyz33 3 ปีที่แล้ว

    Joy to watch !

  • @anikchowdhury9708
    @anikchowdhury9708 ปีที่แล้ว

    Very informative,thanks.

  • @mevartson164
    @mevartson164 4 ปีที่แล้ว

    Good tutorial. God bless you

  • @raviaggarwal529
    @raviaggarwal529 3 ปีที่แล้ว

    It was very helpful. Thanks

  • @hamidmghazi
    @hamidmghazi 4 ปีที่แล้ว

    Great video. Thanks

  • @noritamamita2774
    @noritamamita2774 4 ปีที่แล้ว

    Thanks man as usual your thé best . Cheers

  • @nermeenragab1055
    @nermeenragab1055 3 ปีที่แล้ว

    Great start!

  • @rogerwillis7692
    @rogerwillis7692 2 ปีที่แล้ว

    Fantastic! I can do this!

  • @johnmoore9330
    @johnmoore9330 2 ปีที่แล้ว

    put your totals on top of the column and freeze top rows, good videos thx

  • @azanabbas4758
    @azanabbas4758 4 ปีที่แล้ว

    very helpful video thank you.

  • @techsuplk2340
    @techsuplk2340 4 ปีที่แล้ว

    Well explained. Good luck.

  • @nojeno6
    @nojeno6 2 ปีที่แล้ว

    Thank u so much so easy to undurstand you

  • @mohammeddauda2372
    @mohammeddauda2372 2 ปีที่แล้ว

    I am good to go for my first Excel dashboard! Thanks a lot>

  • @johnrivera890
    @johnrivera890 4 ปีที่แล้ว +2

    Thank you.

  • @ndafanangolo5840
    @ndafanangolo5840 2 ปีที่แล้ว

    I loved this!!!

  • @deronyika5245
    @deronyika5245 4 ปีที่แล้ว

    Thank you for the video. Would appreciate very much to get a guide to the intermediate and advanced dashboards.

    • @techteachersandstudents
      @techteachersandstudents  4 ปีที่แล้ว

      Here's the link to the brand new, Intermediate Guide to Excel Dashboards: th-cam.com/video/thmQ63nTn84/w-d-xo.html

  • @Rosesofmoon12
    @Rosesofmoon12 6 หลายเดือนก่อน

    Thank you ❤

  • @merter2004
    @merter2004 4 ปีที่แล้ว

    Nice video thank you!

  • @CocoBVisuals
    @CocoBVisuals 3 ปีที่แล้ว

    Amazing !! Thank you

  • @trudie8341
    @trudie8341 3 ปีที่แล้ว

    This is Excellent, thanks

  • @amgadmigo2788
    @amgadmigo2788 4 ปีที่แล้ว

    i'm interested in an advanced dashboard
    in fact everything u show us is no short from absolute awesomeness no matter what content it is

    • @techteachersandstudents
      @techteachersandstudents  4 ปีที่แล้ว

      Here's the link to the brand new, Intermediate Guide to Excel Dashboards: th-cam.com/video/thmQ63nTn84/w-d-xo.html

  • @doloresmundee7783
    @doloresmundee7783 4 ปีที่แล้ว

    please make another video on this , I would like to know more about these functions

  • @EKSBahrain
    @EKSBahrain 4 ปีที่แล้ว

    I'm loving Excel more!

  • @rutuparnaray7590
    @rutuparnaray7590 2 ปีที่แล้ว

    Thank you so much

  • @suleimanshaik
    @suleimanshaik 3 ปีที่แล้ว

    Thanks a million. Hope there will be more Dashboard videos. :-)

  • @MdAlam-br8te
    @MdAlam-br8te 4 ปีที่แล้ว

    very nice to learn this

  • @jaypeeramos6173
    @jaypeeramos6173 4 ปีที่แล้ว

    I love it.... thank you so much for sharing...0

  • @zero112
    @zero112 3 ปีที่แล้ว

    Love it!

  • @ciptalestari9555
    @ciptalestari9555 4 ปีที่แล้ว

    Thank you, really help me!
    But evolving technologies let me to use accessible google sheet simultaneously. Could you makes video about G-Sheet?
    I think G-Sheet is more powerful than Excel

  • @kayodeadesina1276
    @kayodeadesina1276 3 ปีที่แล้ว

    Insightful!

  • @Cris-hk4cn
    @Cris-hk4cn 3 ปีที่แล้ว

    Very good presentation.

  • @eminentandmodest
    @eminentandmodest 3 ปีที่แล้ว

    Very helpful.

  • @DROIDFARM
    @DROIDFARM 3 ปีที่แล้ว

    GREAT JOB!

  • @Fatihah-the-Swiftie
    @Fatihah-the-Swiftie 10 หลายเดือนก่อน

    Good Work.

  • @andrematthews8730
    @andrematthews8730 3 ปีที่แล้ว

    Thank you so much.

  • @johnztech1651
    @johnztech1651 3 ปีที่แล้ว

    i have lyked this man coz is creates it a fun. well its fun and am understanding everything he is teaching

  • @wentzel812
    @wentzel812 3 ปีที่แล้ว

    I love this 💝 . How is the data being updated though? Is it manually or automated? If it is automated where is the data pulling from?