Make an Awesome Excel Dashboard in Just 15 Minutes

Build an awesome interactive Excel dashboard in just 15 minutes.
👉 Take our Excel for Business & Finance Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
🆓 DOWNLOAD Free Excel file for this video: view.flodesk.com/pages/63dd44...
In this video we'll build a dynamic Excel dashboard from scratch in just 15 minutes. This will be a sales dashboard for McDonald's South America region. First, we'll make the dashboard dynamic using hyperlink to navigate to the different tabs. Then we'll build the overall structure using shapes and icons. Next we'll create all of the charts and visuals which include a map chart, radar chart, line chart, doughnut chart, KPIs, and more. Finally, we'll customize the visuals and add them to the dashboard.
LEARN:
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑‍💻 LinkedIn - / careerprinciples
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00​ -​ Making the Dashboard dynamic
2:11​ - Dashboard Structure
4:15​ - Creating the charts and visuals
9:34​ - Customising the visuals and putting it all together
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.

Пікірлер: 218

  • @KenjiExplains
    @KenjiExplains Жыл бұрын

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

  • @dakesim
    @dakesim3 ай бұрын

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

  • @dfjama
    @dfjama9 ай бұрын

    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

  • @TryhardNation
    @TryhardNation Жыл бұрын

    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

    Жыл бұрын

    They prbl did it 1000 times

  • @johantode6910

    @johantode6910

    Жыл бұрын

    So many Excel professionals obtained their skills by copy,paste

  • @Sarah-db3lz

    @Sarah-db3lz

    11 ай бұрын

    I’m here for this too lol

  • @popasergiudaniel9204

    @popasergiudaniel9204

    9 ай бұрын

    never stop learning new things :)

  • @rgarlinyc
    @rgarlinyc Жыл бұрын

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

  • @judithbredy5985
    @judithbredy59859 ай бұрын

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

  • @ibrahimallahbaksh7720
    @ibrahimallahbaksh772029 күн бұрын

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

  • @paulmandiomaii2449
    @paulmandiomaii2449 Жыл бұрын

    Really simple and clear. Thank you !!

  • @hunterburns
    @hunterburns Жыл бұрын

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

  • @JayO-lo8kr
    @JayO-lo8kr Жыл бұрын

    Love watching your videos, Kenji. Great work!

  • @nanettereyes
    @nanettereyes Жыл бұрын

    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.

  • @nerdygirljen
    @nerdygirljen18 күн бұрын

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

  • @KaamilNaicker
    @KaamilNaickerАй бұрын

    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

    18 күн бұрын

    Where do people get this data from?

  • @davinsingh5296
    @davinsingh5296 Жыл бұрын

    Awesome vid as always Kenji! Would love to see a Precedent Transactions Valuation video to complement the other relative valuation vids (Comps, etc) - thanks!

  • @Curricullum101
    @Curricullum101 Жыл бұрын

    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

    Жыл бұрын

    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.

  • @snapperhead6256
    @snapperhead625610 ай бұрын

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

  • @Veer_tales
    @Veer_tales Жыл бұрын

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

  • @lilyfullery4779
    @lilyfullery4779 Жыл бұрын

    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

  • @queenirithyll
    @queenirithyll10 ай бұрын

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

  • @jacktoddy9783
    @jacktoddy9783 Жыл бұрын

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

  • @grantm9905
    @grantm990515 күн бұрын

    Incredible work and excellent pace of teaching. Thank you!

  • @justinwduff
    @justinwduff Жыл бұрын

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

  • @jwhite1202
    @jwhite1202 Жыл бұрын

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

  • @curtislabitue977
    @curtislabitue977Ай бұрын

    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

    Ай бұрын

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

  • @levchikharev8512
    @levchikharev8512 Жыл бұрын

    Awesome videos Kenji! Thank you!

  • @hansasare4078
    @hansasare4078 Жыл бұрын

    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

    Жыл бұрын

    Thank you for the comment Hans! Made my day 😁

  • @endthefed9937
    @endthefed9937 Жыл бұрын

    Thank you for sharing your knowledge with the rest of us

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Thank you for watching :)

  • @camlex6310
    @camlex6310 Жыл бұрын

    These dashboards look so polished!!

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Thank you!

  • @Blue-sh3jq
    @Blue-sh3jq3 ай бұрын

    This is beautiful, thanks for sharing!

  • @Denimreovlutions
    @Denimreovlutions Жыл бұрын

    Simple to the point well done dude

  • @mahmoudibrahim3535
    @mahmoudibrahim3535 Жыл бұрын

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

  • @yinkaonaolapo3715
    @yinkaonaolapo3715 Жыл бұрын

    Awesome Video, i like the calmness and steps

  • @McCabecadePorco
    @McCabecadePorco Жыл бұрын

    Kenjiiiii This was awesome! Thank you so much

  • @BerkleyBuilds
    @BerkleyBuilds6 ай бұрын

    You make it look so simple! Thanks

  • @pr.loremarguimaraes7284
    @pr.loremarguimaraes72843 ай бұрын

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

  • @r6burn-357
    @r6burn-3573 ай бұрын

    These videos teach me more than the classes I pay for

  • @jneum33224
    @jneum33224 Жыл бұрын

    Excellent video. You explained things very well

  • @m.ssharma535
    @m.ssharma53510 ай бұрын

    Super useful dashboard creation steps.

  • @Datainsightsacademy
    @Datainsightsacademy Жыл бұрын

    Awesome Dashboard! You are a good teacher

  • @ThuanNguyen-jf2ej
    @ThuanNguyen-jf2ej9 ай бұрын

    Thanks Kenji :) It's much helpful!!

  • @avengersstudios8190
    @avengersstudios819024 күн бұрын

    Thanks Man!! Great Video!!!

  • @ellanesiewlal7584
    @ellanesiewlal7584 Жыл бұрын

    Fantastic, so effective!

  • @mastour722
    @mastour722 Жыл бұрын

    Great info..many thanks 😊 🙏

  • @donaldlehwidi3944
    @donaldlehwidi3944 Жыл бұрын

    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.

  • @MrDhunpagla
    @MrDhunpagla Жыл бұрын

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

  • @simonoganga9535
    @simonoganga9535 Жыл бұрын

    Amazing dashboards Kenji

  • @christinembuti9318
    @christinembuti9318 Жыл бұрын

    Good, love it. Will practice on it.

  • @mirnaedisa
    @mirnaedisa11 ай бұрын

    First try..sucessfull. Thanks a lot Kenji

  • @wencirculado9733
    @wencirculado9733 Жыл бұрын

    Thanks for your videos.

  • @quiqueenrikx3992
    @quiqueenrikx3992 Жыл бұрын

    Thanks mate!! Always awesome!!!

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Appreciate it!

  • @masoumekheradmand171
    @masoumekheradmand1713 ай бұрын

    It was amazing! thank you

  • @dominatorgaming2980
    @dominatorgaming2980 Жыл бұрын

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

  • @englishwithpae1921
    @englishwithpae1921 Жыл бұрын

    Thanks, it’s very helpful

  • @INAdnyana
    @INAdnyana Жыл бұрын

    Great explanation Kenji.

  • @tiddlesismyname4314
    @tiddlesismyname4314 Жыл бұрын

    excellent video Kenji

  • @rachel9859
    @rachel9859 Жыл бұрын

    Thank you this is nice to learn

  • @akin-ojoayotomide8909
    @akin-ojoayotomide8909 Жыл бұрын

    This is simply amazing.

  • @user-rs1id9ww8o
    @user-rs1id9ww8o11 ай бұрын

    Thank you from Houston, Texas!

  • @KenjiExplains

    @KenjiExplains

    11 ай бұрын

    thank you for watching! From London UK :)

  • @alfredyt
    @alfredyt Жыл бұрын

    Thank you, looking for more power bi content

  • @creativarevolutions
    @creativarevolutions Жыл бұрын

    Great! Thank you !

  • @KshitijKV
    @KshitijKV Жыл бұрын

    Extremely Useful

  • @Mullajonov
    @Mullajonov Жыл бұрын

    thanks brother !

  • @chaminsankalpa
    @chaminsankalpa9 ай бұрын

    Awesome man!

  • @solomonbhandari-young4154
    @solomonbhandari-young4154 Жыл бұрын

    Amazing material

  • @tun-tunninc.6492
    @tun-tunninc.649210 ай бұрын

    Holy sweet good lord above this is gorgeous!!

  • @YouTubeChannel2296
    @YouTubeChannel2296 Жыл бұрын

    Hey Kenji, Love the content! Can you please make a video on ratio analysis on excel?

  • @gowthams2613
    @gowthams2613 Жыл бұрын

    This is pretty cool 😊

  • @davemason2604
    @davemason2604 Жыл бұрын

    Great video as always and well explained. I love excel and been looking at learning dashboards. How do you decide what visualisationsd to use...i mean deciding if something looks better in a bar chart and not a column chart. I am thinking of doing a dashboard on info of countries of the world but not sure what visualisations to use to make it look good

  • @vatsal715

    @vatsal715

    Жыл бұрын

    Hi, you will gradually get the purpose behind each visual used. Other way, you can always learn for different visuals and their dataset usage from research. :)

  • @seang2012
    @seang2012 Жыл бұрын

    Dude we need you doing this in Power BI!

  • @xaviergrewal
    @xaviergrewal8 ай бұрын

    Awesome videos!

  • @CustAndCode
    @CustAndCode Жыл бұрын

    really impressive! 😀🤗

  • @ANAS201122
    @ANAS2011229 күн бұрын

    U r the best thank u

  • @pradipbhatta4986
    @pradipbhatta4986 Жыл бұрын

    Awesome Short class

  • @venkatsandeepsr
    @venkatsandeepsr2 ай бұрын

    Great explanation

  • @AlessandroScaltritti
    @AlessandroScaltritti Жыл бұрын

    beautiful

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

  • @BNLien
    @BNLien5 ай бұрын

    You are the best. I love you.

  • @schubertpeter79
    @schubertpeter79 Жыл бұрын

    Hi Kenji, love your videos, u create awesome content. I got 2 questions. If i receive new figures into my data table, will the pivot tables automatically update, or do i have to refresh manually? Do u think its a good idea to keep all my pivot tables on the same sheet, or each one on a separate. Thank you in advance!

  • @user-xr8dv2sr3q

    @user-xr8dv2sr3q

    6 ай бұрын

    You can make it your choice brr

  • @rosseve333
    @rosseve3333 ай бұрын

    you are awesome!!!

  • @michaelquach6655
    @michaelquach6655 Жыл бұрын

    Sweeet color coded map 👍

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Cheers!

  • @iRandom_Thoughts
    @iRandom_Thoughts3 ай бұрын

    Good guide

  • @christophheinz2544
    @christophheinz25448 ай бұрын

    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?

  • @user-sv1qw5dv3i
    @user-sv1qw5dv3i8 ай бұрын

    thanks alots kenji

  • @ricardoagnelo2995
    @ricardoagnelo29959 ай бұрын

    Just Awesome

  • @diabolikhunter
    @diabolikhunter14 күн бұрын

    amazing

  • @flourishwithMJ
    @flourishwithMJ9 ай бұрын

    thank you so much.

  • @B-RaD5oh5
    @B-RaD5oh5 Жыл бұрын

    Pretty awesome. Your videos have helped a lot! Could you show us how to make a CRM using Excel?

  • @johnnyparsons2372

    @johnnyparsons2372

    Жыл бұрын

    Mate you can't this has no database this isn't app. Watching this stuff will just lead you down the garden path to things you want/need that this can''t do

  • @yin8914
    @yin891411 ай бұрын

    Awesome!!

  • @candycandy319
    @candycandy3193 ай бұрын

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

  • @enriqueponce1410
    @enriqueponce1410 Жыл бұрын

    Hi Kenji, how did you enter the data in that format? Multiple tables in the same spreadsheet

  • @paulchau0203
    @paulchau0203 Жыл бұрын

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

  • @sakibahmed1815
    @sakibahmed1815 Жыл бұрын

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

  • @goonie79
    @goonie79 Жыл бұрын

    Excellent tutorial, thank you! Is there a chance these courses are on Udemy?

  • @randomgray1
    @randomgray1 Жыл бұрын

    Awesome stuff as usual Kenji - I followed one of your dashboard videos and built one that is great! I now ask as one of my slicers is Week 1, Week 2 etc, how do I stop Week 10 appearing between them?

  • @ams4252
    @ams425211 ай бұрын

    Nice 👍

  • @method341
    @method341 Жыл бұрын

    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.

  • @sagittarius7762
    @sagittarius7762 Жыл бұрын

    Hi Kenji, really great video.. impressive how you can all that easily together. Can you please make same Dashboard for Logistics and supply chain (container, ETA, dates, between arrival and dispatch... demurrage.. ) please

  • @jennifergribbins4560

    @jennifergribbins4560

    Жыл бұрын

    Yes, that would help me at my work

  • @sd4837

    @sd4837

    Жыл бұрын

    @@jennifergribbins4560 yes please

  • @SothearithKONGMrMuyKhmer
    @SothearithKONGMrMuyKhmer Жыл бұрын

    That’s awesome

  • @imran.shah5
    @imran.shah5 Жыл бұрын

    Hello Kenji, appreciate the informative video. Can you please make same Dashboard for Logistics and supply chain (container, ETA, dates, between arrival and dispatch, sales, profit... demurrage.. ) much appreciated!

  • @We4redev0

    @We4redev0

    Жыл бұрын

    He just taught you, so why don't you make a video doing that?

  • @user-lc3ig9yn4z
    @user-lc3ig9yn4z10 ай бұрын

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