Make an Awesome Excel Dashboard in Just 15 Minutes

Поділитися
Вставка
  • Опубліковано 25 лис 2024

КОМЕНТАРІ • 273

  • @KenjiExplains
    @KenjiExplains  Рік тому +27

    👉 Take our Excel course: www.careerprinciples.com/courses/excel-for-business-finance
    🚀 See all our courses: www.careerprinciples.com/courses

    • @solomonbhandari-young4154
      @solomonbhandari-young4154 Рік тому

      These are really good

    • @jadedunia
      @jadedunia Рік тому

      I am very impressed by the quality of the content and especially by the consistency of the business model. I'm trying to create a business in the same niche in the French speaking world, but I'm struggling. I would have liked to have your support, advice, a youtube channel review or a website review to improve myself.

  • @waiphyotun7633
    @waiphyotun7633 8 годин тому

    This channel is such a gem for many employees and business owners

  • @sheneenellis4530
    @sheneenellis4530 4 дні тому

    As someone who has consumed countless hours of UA-cam content, I can confidently say that your channel stands out. Your no-nonsense approach and practical tips have significantly enhanced my skills in Excel. I'm particularly impressed by your concise explanations, real-world examples, and practice files. I'm currently exploring Data Analyst courses and appreciate your honest and informative content. Your channel has been invaluable in helping me navigate the sea of options. Thank you for being a great teacher!

    • @KenjiExplains
      @KenjiExplains  3 дні тому

      Thank you so much! Wish you the best of luck learning about data analysis!

  • @Curricullum101
    @Curricullum101 Рік тому +23

    As I wrote to you last month, I'm now enrolled in your Excel for Business course. I'm DK, enrolled on 02 Feb 2023. You can look me up in your database if you don't believe me. These video uploads have been instrumental in my decision. I'm very excited and looking forward to learning from you guys.

    • @slowmo8375
      @slowmo8375 Рік тому +1

      is there any information on the duration of the course in terms of the amount of time needed for completion?

    • @orlumbuseuw5646
      @orlumbuseuw5646 Рік тому

      @@slowmo8375 The course is designed for students to complete around 2 modules per week, for a total of 4-5 weeks until course completion. However, the course can be completed at your own pace (faster or slower) and you'll have unlimited access to the materials.

  • @dakesim
    @dakesim 9 місяців тому +17

    I absolutely love all the knowledge I'm getting from these videos. I never thought Excel could be so exciting!

  • @ibrahimallahbaksh7720
    @ibrahimallahbaksh7720 6 місяців тому +6

    Wow! This is best video on the topic I have see so far. Very minimalistic and visually appealing. Thank you so much for sharing.

  • @curtislabitue977
    @curtislabitue977 6 місяців тому +6

    Ask me how many videos I've watched to produce an Extraordinary dashboard without a difficult learning curve. You are an exceptional teacher. I'll keep attending class! Thank you for sharing your skills and knowledge.

    • @KenjiExplains
      @KenjiExplains  6 місяців тому

      Thank you for your lovely comment! Just trying to put together useful videos :)

  • @KaamilNaicker
    @KaamilNaicker 6 місяців тому +18

    I learnt more in the first five minutes than I did in the last 6 months of using Excel, Thank you for the video!

    • @Nitric_Beyond
      @Nitric_Beyond 6 місяців тому

      Where do people get this data from?

  • @r6burn-357
    @r6burn-357 9 місяців тому +4

    These videos teach me more than the classes I pay for

  • @endthefed9937
    @endthefed9937 Рік тому +7

    Thank you for sharing your knowledge with the rest of us

  • @judithbredy5985
    @judithbredy5985 Рік тому +2

    Kenji makes it look so easy. I love how he explains everything.

  • @fahadsher230
    @fahadsher230 2 місяці тому

    You are such a blessing for all the enthusiast learners ! I only can easily learn from your tutorials ...love from Pakistan.

  • @Untold_archives
    @Untold_archives 3 місяці тому +1

    kenji you are a legend, never thought id learn this so fast thankyou soooo much and yes keep em coming

  • @BackByDesign
    @BackByDesign Рік тому +360

    Nothing makes me suffer from imposter syndrome more than watching these videos and seeing how quick and effortlessly you do all of this. So impressive.

  • @camlex6310
    @camlex6310 Рік тому +1

    These dashboards look so polished!!

  • @jakemello9121
    @jakemello9121 3 місяці тому

    I just finished my project inspire with this video. Just want to say thank you for this knowledge. keep it up! you inspire lots of people.

  • @dfjama
    @dfjama Рік тому +7

    Thanks Kenji for this well done video. Your content is awesome, simple and to the point to understand from the rest. I love this one in particular

  • @seyihelen
    @seyihelen 22 дні тому

    This is awesome and straight forward.
    Thank you!

  • @Veer_tales
    @Veer_tales Рік тому +1

    Awesome explaination, have jut watched 4 mins of your video and enjoyed the explaination. Thanks for upskilling us for free

  • @hansasare4078
    @hansasare4078 Рік тому +2

    You are an awesome person...your level of understanding and the ease with which you teach these concepts amazes me..I have learnt a lot from you videos and am very grateful..God bless you for all your efforts to help others....another grate video..

    • @KenjiExplains
      @KenjiExplains  Рік тому +1

      Thank you for the comment Hans! Made my day 😁

  • @nerdygirljen
    @nerdygirljen 6 місяців тому

    I've watched dozens of dashboard videos, and this is definitely THE ONE! Thank you for this~

  • @lilyfullery4779
    @lilyfullery4779 Рік тому +2

    Hi Kenji, i have seen ur multiple videos and would like to appreciate your work and the major part that i like about you is very clean work You Present , as i have visited ur website too, for downloading excel file , it was super easy to download it and unlike other youtubers with their messy websites

  • @Techjunjun
    @Techjunjun 4 місяці тому

    This is a simple and exquisite dashboard, very cool!😊

  • @grantm9905
    @grantm9905 6 місяців тому

    Incredible work and excellent pace of teaching. Thank you!

  • @paulmandiomaii2449
    @paulmandiomaii2449 Рік тому +4

    Really simple and clear. Thank you !!

  • @lakbaylaboy2644
    @lakbaylaboy2644 4 місяці тому

    your the best Kenji
    this is by far the best dashboard i ever see

  • @kellyharper2039
    @kellyharper2039 5 місяців тому

    Thanks so much - this was amazing and exactly what I was looking for. Will be exploring more of your content and courses.

  • @mahmoudibrahim3535
    @mahmoudibrahim3535 Рік тому

    Your way is impressive!!! ..... I like all your videos and I really benefited from all the videos I have watched.

  • @Blue-sh3jq
    @Blue-sh3jq 8 місяців тому

    This is beautiful, thanks for sharing!

  • @IsmaelGarza-k7m
    @IsmaelGarza-k7m Рік тому

    Thank you from Houston, Texas!

  • @neerajtiwari4261
    @neerajtiwari4261 5 місяців тому

    explained very nicely and in effective manner. Awesome video and very very informative.

  • @DataSageAcademy
    @DataSageAcademy Рік тому

    Awesome Dashboard! You are a good teacher

  • @queenirithyll
    @queenirithyll Рік тому +1

    Subscribed. Now I have a go to channel for excel tutorials. Thank you! I am surprised how you made this look so easy. Great video! 😁
    👍🏻

  • @pr.loremarguimaraes7284
    @pr.loremarguimaraes7284 9 місяців тому

    Great video, I watched many times and got some cool ideas for my own charts, thanks a lot

  • @McCabecadePorco
    @McCabecadePorco Рік тому

    Kenjiiiii
    This was awesome!
    Thank you so much

  • @hunterburns
    @hunterburns Рік тому

    That's amazing ! Lots of love and many many good wishes for you, Kenji . 💖💖

  • @m.ssharma535
    @m.ssharma535 Рік тому

    Super useful dashboard creation steps.

  • @mirnaedisa
    @mirnaedisa Рік тому

    First try..sucessfull. Thanks a lot Kenji

  • @rgarlinyc
    @rgarlinyc Рік тому +4

    Great explanations - you Sur are a very effective teacher. I'll check out your courses in the next few days. Thanks a lot!

  • @leadmanalo6218
    @leadmanalo6218 Місяць тому

    Thank you! This helps me a lot in my work. 🎉

  • @abiodunbabalola451
    @abiodunbabalola451 Місяць тому

    Thank you so much for sharing this with us

  • @yinkaonaolapo3715
    @yinkaonaolapo3715 Рік тому

    Awesome Video, i like the calmness and steps

  • @jhuggins76
    @jhuggins76 2 місяці тому

    A million Thank Yous!!

  • @method341
    @method341 Рік тому +2

    Can you go through from scratch? i.e. how did you get rid of all the gridlines, how did you make the side banner, how did you clean and process all the data and make those data tables in the input tab.

  • @simonoganga9535
    @simonoganga9535 Рік тому

    Amazing dashboards Kenji

  • @Denimreovlutions
    @Denimreovlutions Рік тому +1

    Simple to the point well done dude

  • @INAdnyana
    @INAdnyana Рік тому

    Great explanation Kenji.

  • @daxdasche6112
    @daxdasche6112 18 днів тому +1

    But how did you get those dynamic icons in the dashboard in the first place?

  • @ThuanNguyen-jf2ej
    @ThuanNguyen-jf2ej Рік тому

    Thanks Kenji :) It's much helpful!!

  • @tun-tunninc.6492
    @tun-tunninc.6492 Рік тому

    Holy sweet good lord above this is gorgeous!!

  • @jacktoddy9783
    @jacktoddy9783 Рік тому

    Thanks Kenji - Excellent and very useful video - I appreciate your time making it.

  • @snapperhead6256
    @snapperhead6256 Рік тому

    Fantastic content! Some of the best I've seen on YT! Thank you. 👍

  • @levchikharev8512
    @levchikharev8512 Рік тому

    Awesome videos Kenji! Thank you!

  • @gbodytoys
    @gbodytoys 16 хвилин тому

    Thank you for this!!!

  • @jwhite1202
    @jwhite1202 Рік тому

    Great video. I love this style of learning. I will definitely watch more videos on this channel

  • @HangNguyen-dk8cp
    @HangNguyen-dk8cp 2 місяці тому +2

    Great although I didn’t get the Map work but will figure it out later. Thanks so much for the post!

    • @carolinekendi7446
      @carolinekendi7446 8 днів тому

      the darker the part of the map, the more sales it displays for example Argentina is darker. also, once you apply slicers, you will be able to filter the map dynamically also

  • @FrenchBulldogFacts-vk6ru
    @FrenchBulldogFacts-vk6ru Рік тому

    Thank you for this great content. I’m building out some of these dashboards at work for our Finance department starting with our cell phone bill which will be updated monthly. Should I use excel or power BI?

  • @JayO-lo8kr
    @JayO-lo8kr Рік тому

    Love watching your videos, Kenji. Great work!

  • @KshitijKV
    @KshitijKV Рік тому

    Extremely Useful

  • @wencirculado9733
    @wencirculado9733 Рік тому

    Thanks for your videos.

  • @BerkleyBuilds
    @BerkleyBuilds Рік тому

    You make it look so simple! Thanks

  • @dominatorgaming2980
    @dominatorgaming2980 Рік тому

    You always rock !, bring once video on Financial Modelling.

  • @avengersstudios8190
    @avengersstudios8190 6 місяців тому

    Thanks Man!! Great Video!!!

  • @masoumekheradmand171
    @masoumekheradmand171 8 місяців тому

    It was amazing! thank you

  • @jneum33224
    @jneum33224 Рік тому

    Excellent video. You explained things very well

  • @rinaceballos4774
    @rinaceballos4774 4 місяці тому

    Love this ! Beginner here … How did you get the icons ? Can this be done with the online version? Thanks

  • @tiddlesismyname4314
    @tiddlesismyname4314 Рік тому

    excellent video Kenji

  • @rachel9859
    @rachel9859 Рік тому

    Thank you this is nice to learn

  • @nanettereyes
    @nanettereyes Рік тому +1

    Thank you for this video. Your explanations are carefully put together. Your design concepts are truly professional as well. I will checkout your courses for sure.

  • @akin-ojoayotomide8909
    @akin-ojoayotomide8909 Рік тому

    This is simply amazing.

  • @inacioms
    @inacioms Рік тому +1

    Hello Kenji, I really liked your class, I'm a teacher and I would like to know if I can use this example in my classes, of course I will report the source used in classes.

  • @englishwithpae1921
    @englishwithpae1921 Рік тому

    Thanks, it’s very helpful

  • @mastour722
    @mastour722 Рік тому

    Great info..many thanks 😊 🙏

  • @gerbyherby1516
    @gerbyherby1516 Місяць тому +1

    Another tip may be to protect the dashboard sheet and uncheck all the checkboxes. This will of course prevent people from accidently ruiining things and as a bonus there will no longer be any cell selected.

    • @seyihelen
      @seyihelen 22 дні тому

      Do you care to explain how to do that?

    • @gerbyherby1516
      @gerbyherby1516 22 дні тому

      @@seyihelen No problem. Go to the Review tab > group Protect > command Protect Sheet and clear all checkboxes beneath "Allow all users of this worksheet to:". The password is optional. Hope this is clear...

  • @christinembuti9318
    @christinembuti9318 Рік тому

    Good, love it.
    Will practice on it.

  • @michaelquach6655
    @michaelquach6655 Рік тому +3

    Sweeet color coded map 👍

  • @gerbyherby1516
    @gerbyherby1516 Місяць тому

    Nice video. You could copy the layout of the first doughnut faster to the others by making it a template first.

  • @christophheinz2544
    @christophheinz2544 Рік тому

    This video really helped me. Thank you a lot! I just have one additional question. I want to viszualize one page of the sheet at a tv. Do you know which software I can use that it looks nice?

  • @candycandy319
    @candycandy319 9 місяців тому

    I was today years old when I realize you can dynamic reference a cell in the text box - wow!

  • @BNLien
    @BNLien 11 місяців тому

    You are the best. I love you.

  • @Official_Debex
    @Official_Debex 28 днів тому

    Great piece

  • @pradipbhatta4986
    @pradipbhatta4986 Рік тому

    Awesome Short class

  • @gerbyherby1516
    @gerbyherby1516 Місяць тому

    How do I put percentage data labels at a radar chart. You worked around it ;-) Found it: absolutely doable with "category name" and "value" and of course preferable over trickery that won't stick when the data changes.

  • @quiqueenrikx3992
    @quiqueenrikx3992 Рік тому

    Thanks mate!! Always awesome!!!

  • @enonamso616
    @enonamso616 2 місяці тому

    Very nice video
    I appreciate

  • @chaminsankalpa
    @chaminsankalpa Рік тому

    Awesome man!

  • @paulchau0203
    @paulchau0203 Рік тому

    Thank you, can you also tell how to express in the pie chart if the target has been reached and over 100%?

  • @Mullajonov
    @Mullajonov Рік тому

    thanks brother !

  • @gowthams2613
    @gowthams2613 Рік тому

    This is pretty cool 😊

  • @francisayodele7132
    @francisayodele7132 2 місяці тому

    Great video, Kenji!
    Can I replicate this for a project? Kindly recommend sources where I can get more data sources to work with? Thank you.

  • @ellanesiewlal7584
    @ellanesiewlal7584 Рік тому

    Fantastic, so effective!

  • @MrDhunpagla
    @MrDhunpagla Рік тому

    Good one Mr. Kenji... please bring more on this 🙂

  • @justinwduff
    @justinwduff Рік тому

    Really solid video, you made that look very easy. Thank you!

  • @wizdeasis9846
    @wizdeasis9846 Рік тому

    Thank you sir Kenji! This is great. Can this excel dashboard be uploaded in google sheet and would still work when shared with other users online?

  • @alfredyt
    @alfredyt Рік тому

    Thank you, looking for more power bi content

  • @seang2012
    @seang2012 Рік тому

    Dude we need you doing this in Power BI!

  • @randomgray1
    @randomgray1 Рік тому

    Kenji, Thanks for the video! I used an older tutorial of yours to build a dashboard but now I have ran into a problem in that my week slicer displays week 1, week 10, week 2! I know why it does this due to the a-z but can’t find a way to combat it so it is weekly 1,2,3 etc. Any suggestions or tutorials to help?

  • @ShakilSayyad-c6k
    @ShakilSayyad-c6k Рік тому

    Hello, I like your videos. Its more informative. Could please make one video on excel for beginners...It would be much helpful

  • @WilliamKyeremeh-d8w
    @WilliamKyeremeh-d8w 3 місяці тому

    Hi kenji , please which excel version did you use for this dashboard , I tried following the steps but my version looks different .

  • @xaviergrewal
    @xaviergrewal Рік тому

    Awesome videos!