Make an Awesome Excel Dashboard in Just 15 Minutes

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

Комментарии • 271

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

  • @sheneenellis4530
    @sheneenellis4530 11 часов назад

    As someone who has consumed countless hours of RUclips 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  10 часов назад

      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.

  • @r6burn-357
    @r6burn-357 9 месяцев назад +4

    These videos teach me more than the classes I pay for

  • @dakesim
    @dakesim 8 месяцев назад +17

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

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

  • @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 :)

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

  • @endthefed9937
    @endthefed9937 Год назад +7

    Thank you for sharing your knowledge with the rest of us

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

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

  • @BackByDesign
    @BackByDesign Год назад +359

    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.

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

      Samedt 😂

    • @BostelD
      @BostelD Год назад +3

      They prbl did it 1000 times

    • @johantode6910
      @johantode6910 Год назад +3

      So many Excel professionals obtained their skills by copy,paste

    • @Sarah-db3lz
      @Sarah-db3lz Год назад +1

      I’m here for this too lol

    • @popasergiudaniel9204
      @popasergiudaniel9204 Год назад +6

      never stop learning new things :)

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

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

    These dashboards look so polished!!

  • @candycandy319
    @candycandy319 9 месяцев назад

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

  • @seyihelen
    @seyihelen 18 дней назад

    This is awesome and straight forward.
    Thank you!

  • @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 5 дней назад

      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

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

  • @grantm9905
    @grantm9905 6 месяцев назад

    Incredible work and excellent pace of teaching. Thank you!

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

  • @nerdygirljen
    @nerdygirljen 6 месяцев назад

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

  • @IsmaelGarza-k7m
    @IsmaelGarza-k7m Год назад

    Thank you from Houston, Texas!

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

      thank you for watching! From London UK :)

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

  • @lakbaylaboy2644
    @lakbaylaboy2644 4 месяца назад

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

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

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

  • @Techjunjun
    @Techjunjun 4 месяца назад

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

  • @paulmandiomaii2449
    @paulmandiomaii2449 Год назад +4

    Really simple and clear. Thank you !!

  • @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 18 дней назад

      Do you care to explain how to do that?

    • @gerbyherby1516
      @gerbyherby1516 18 дней назад

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

  • @gerbyherby1516
    @gerbyherby1516 Месяц назад

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

  • @leadmanalo6218
    @leadmanalo6218 Месяц назад

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

  • @Blue-sh3jq
    @Blue-sh3jq 8 месяцев назад

    This is beautiful, thanks for sharing!

  • @m.ssharma535
    @m.ssharma535 Год назад

    Super useful dashboard creation steps.

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

  • @abiodunbabalola451
    @abiodunbabalola451 Месяц назад

    Thank you so much for sharing this with us

  • @pr.loremarguimaraes7284
    @pr.loremarguimaraes7284 9 месяцев назад

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

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

    Awesome Dashboard! You are a good teacher

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

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

  • @rinaceballos4774
    @rinaceballos4774 4 месяца назад

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

  • @daxdasche6112
    @daxdasche6112 14 дней назад +1

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

  • @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! 😁
    👍🏻

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

    First try..sucessfull. Thanks a lot Kenji

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

    Kenjiiiii
    This was awesome!
    Thank you so much

  • @neerajtiwari4261
    @neerajtiwari4261 5 месяцев назад

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

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

    Simple to the point well done dude

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

    Awesome Video, i like the calmness and steps

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

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

  • @jhuggins76
    @jhuggins76 Месяц назад

    A million Thank Yous!!

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

    Dude we need you doing this in Power BI!

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

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

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

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

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

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

    Great explanation Kenji.

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

    You make it look so simple! Thanks

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

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

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

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

    Amazing dashboards Kenji

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

    I completed it (except the geographical area, cause my excel isn't showing that option) . Thank you so much .

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

    Awesome videos Kenji! Thank you!

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

    Thank you, looking for more power bi content

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

  • @michaelquach6655
    @michaelquach6655 Год назад +3

    Sweeet color coded map 👍

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

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

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

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

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

  • @syed_taha_ahmed
    @syed_taha_ahmed 8 месяцев назад

    Hello
    That's one of the most easiest way to develop the dashboard.
    Please post a video for Energy Sector.

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

  • @tun-tunninc.6492
    @tun-tunninc.6492 Год назад

    Holy sweet good lord above this is gorgeous!!

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

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

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

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

    Excellent video. You explained things very well

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

    Thank you this is nice to learn

  • @purple_scorp146
    @purple_scorp146 4 месяца назад

    Fantastic video. You are a great presenter. Can you create a button on a dashboard that shows a custom view of a filtered sheet?

  • @ThuanNguyen-jf2ej
    @ThuanNguyen-jf2ej Год назад

    Thanks Kenji :) It's much helpful!!

  • @masoumekheradmand171
    @masoumekheradmand171 8 месяцев назад

    It was amazing! thank you

  • @JayO-lo8kr
    @JayO-lo8kr Год назад

    Love watching your videos, Kenji. Great work!

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

    Extremely Useful

  • @Official_Debex
    @Official_Debex 25 дней назад

    Great piece

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

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

    Hi Kenji, your videos are great! I am trying to get a formula for the following. I have two columns, one with dates, and one with customer names. I would like to know for any one customer if they purchased something in the last 12 months. If they did, great! If they didn't I would like to know so I can contact them. Thank you for all your videos.

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

    Hi, Have you make a tutorial for making excel dashboars that we can update the data (add more colum) monthly?

  • @kaandogan2888
    @kaandogan2888 Месяц назад

    Is it possible to link graphs to dashboard instead of copy pasting them? That way when the data is updated the dashboard will have the updated graph immediately.

  • @avengersstudios8190
    @avengersstudios8190 6 месяцев назад

    Thanks Man!! Great Video!!!

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

    Thanks for this video. Please how can I get the dataset?

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

    Thanks for your videos.

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

    excellent video Kenji

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

    Thanks, it’s very 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 .

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

    Should we also use Radar chart when adding data to a data model and creating pivot charts?

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

    Great info..many thanks 😊 🙏

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

    Awesome Short class

  • @tejasbhandarkar1369
    @tejasbhandarkar1369 3 месяца назад

    Because KPIs is the main things to Identify, for any analysis

  • @akin-ojoayotomide8909
    @akin-ojoayotomide8909 Год назад

    This is simply amazing.

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

    Good, love it.
    Will practice on it.

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

    Good day Kenji
    I hope you are doing well Sir.
    I really do love how simple you make excel look.
    Could you please do a Risk Management dashboard.

  • @BNLien
    @BNLien 10 месяцев назад

    You are the best. I love you.

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

    Thanks mate!! Always awesome!!!

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

    Thank U... but I think u should show in the video how the dashboard works... many of us watch the video in our cellphones and cant download the file to test it