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.

[@KenjiExplains]

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

[@solomonbhandari-young4154]

These are really good

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

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

[@dfjama]

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

[@judithbredy5985]

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

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

Where do people get this data from?

[@rgarlinyc]

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

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

Samedt 😂

[@BostelD]

They prbl did it 1000 times

[@johantode6910]

So many Excel professionals obtained their skills by copy,paste

[@Sarah-db3lz]

I’m here for this too lol

[@popasergiudaniel9204]

never stop learning new things :)

[@paulmandiomaii2449]

Really simple and clear. Thank you !!

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

[@ibrahimallahbaksh7720]

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

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

[@JayO-lo8kr]

Love watching your videos, Kenji. Great work!

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

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

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

[@hunterburns]

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

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

[@Veer_tales]

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

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

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

[@jacktoddy9783]

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

[@nerdygirljen]

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

[@camlex6310]

These dashboards look so polished!!

[@KenjiExplains]

Thank you!

[@queenirithyll]

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

[@snapperhead6256]

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

[@endthefed9937]

Thank you for sharing your knowledge with the rest of us

[@KenjiExplains]

Thank you for watching :)

[@Denimreovlutions]

Simple to the point well done dude

[@justinwduff]

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

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

Thank you for the comment Hans! Made my day 😁

[@levchikharev8512]

Awesome videos Kenji! Thank you!

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

[@grantm9905]

Incredible work and excellent pace of teaching. Thank you!

[@BerkleyBuilds]

You make it look so simple! Thanks

[@jwhite1202]

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

[@mahmoudibrahim3535]

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

[@Blue-sh3jq]

This is beautiful, thanks for sharing!

[@pr.loremarguimaraes7284]

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

[@jneum33224]

Excellent video. You explained things very well

[@r6burn-357]

These videos teach me more than the classes I pay for

[@McCabecadePorco]

Kenjiiiii This was awesome! Thank you so much

[@yinkaonaolapo3715]

Awesome Video, i like the calmness and steps

[@Datainsightsacademy]

Awesome Dashboard! You are a good teacher

[@m.ssharma535]

Super useful dashboard creation steps.

[@ellanesiewlal7584]

Fantastic, so effective!

[@MrDhunpagla]

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

[@christinembuti9318]

Good, love it. Will practice on it.

[@quiqueenrikx3992]

Thanks mate!! Always awesome!!!

[@KenjiExplains]

Appreciate it!

[@user-rs1id9ww8o]

Thank you from Houston, Texas!

[@KenjiExplains]

thank you for watching! From London UK :)

[@mastour722]

Great info..many thanks 😊 🙏

[@mirnaedisa]

First try..sucessfull. Thanks a lot Kenji

[@dominatorgaming2980]

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

[@ThuanNguyen-jf2ej]

Thanks Kenji :) It's much helpful!!

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

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. :)

[@wencirculado9733]

Thanks for your videos.

[@INAdnyana]

Great explanation Kenji.

[@englishwithpae1921]

Thanks, it’s very helpful

[@neerajtiwari4261]

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

[@simonoganga9535]

Amazing dashboards Kenji

[@alfredyt]

Thank you, looking for more power bi content

[@Mullajonov]

thanks brother !

[@akin-ojoayotomide8909]

This is simply amazing.

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

You can make it your choice brr

[@masoumekheradmand171]

It was amazing! thank you

[@YouTubeChannel2296]

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

[@seang2012]

Dude we need you doing this in Power BI!

[@avengersstudios8190]

Thanks Man!! Great Video!!!

[@creativarevolutions]

Great! Thank you !

[@rachel9859]

Thank you this is nice to learn

[@tun-tunninc.6492]

Holy sweet good lord above this is gorgeous!!

[@CustAndCode]

really impressive! 😀🤗

[@michaelquach6655]

Sweeet color coded map 👍

[@KenjiExplains]

Cheers!

[@tiddlesismyname4314]

excellent video Kenji

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

[@KshitijKV]

Extremely Useful

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

[@solomonbhandari-young4154]

Amazing material

[@candycandy319]

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

[@chaminsankalpa]

Awesome man!

[@gowthams2613]

This is pretty cool 😊

[@pradipbhatta4986]

Awesome Short class

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

[@sakibahmed1815]

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

[@venkatsandeepsr]

Great explanation

[@AlessandroScaltritti]

beautiful

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

[@onkarkulkarni4129]

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

[@BNLien]

You are the best. I love you.

[@B-RaD5oh5]

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

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

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

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

[@paulchau0203]

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

[@goonie79]

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

[@ANAS201122]

U r the best thank u

[@xaviergrewal]

Awesome videos!

[@enriqueponce1410]

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

[@flourishwithMJ]

thank you so much.

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

Yes, that would help me at my work

[@sd4837]

@@jennifergribbins4560 yes please

[@user-sv1qw5dv3i]

thanks alots kenji

[@inacioms]

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.

[@rosseve333]

you are awesome!!!

[@ams4252]

Nice 👍

[@ricardoagnelo2995]

Just Awesome

[@wildgoose82667]

I would like to include data in a dashboard I am creating, but I'm not sure how to do what I envision. Imagine a sheet named "DATA". In col A, each cell contains either "Open" or "closed". In Col B are names that correspond to the data in Col A. The info in col B does not change once it is entered. However the status of the cells in Col A change regularly. Plus new inventory is added regularly, so the total number of items in A and B increases over time. I would like a dashboard that shows just Open names without any line spaces between them. The only solution I can think of is to simply mirror the info from the DATA sheet. However that could leave large numbers of lines between them. I don't know if I conveyed the problem I am having. I hope you can offer suggestions.

[@yin8914]

Awesome!!