Make an Awesome Excel Dashboard in Just 15 Minutes

Подписаться 526 тыс.

Просмотров 1,1 млн

50% 1

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.

Опубликовано:

19 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 220

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

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

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

@dakesim 3 месяца назад

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

@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 9 месяцев назад

never stop learning new things :)

@rgarlinyc Год назад

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

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

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

@paulmandiomaii2449 Год назад

Really simple and clear. Thank you !!

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

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

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

Love watching your videos, Kenji. Great work!

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

@hunterburns Год назад

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

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

@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

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

@grantm9905 27 дней назад

Incredible work and excellent pace of teaching. Thank you!

@Veer_tales Год назад

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

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

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

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

@justinwduff Год назад

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

@snapperhead6256 11 месяцев назад

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

@levchikharev8512 Год назад

Awesome videos Kenji! Thank you!

@pr.loremarguimaraes7284 3 месяца назад

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

@BerkleyBuilds 7 месяцев назад

You make it look so simple! Thanks

@Blue-sh3jq 3 месяца назад

This is beautiful, thanks for sharing!

@jwhite1202 Год назад

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

@Denimreovlutions Год назад

Simple to the point well done dude

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

@endthefed9937 Год назад

Thank you for sharing your knowledge with the rest of us

@KenjiExplains Год назад

Thank you for watching :)

@jneum33224 Год назад

Excellent video. You explained things very well

@mahmoudibrahim3535 Год назад

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

@camlex6310 Год назад

These dashboards look so polished!!

@KenjiExplains Год назад

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 😁

@m.ssharma535 10 месяцев назад

Super useful dashboard creation steps.

@christinembuti9318 Год назад

Good, love it. Will practice on it.

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

@neerajtiwari4261 12 часов назад

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

@yinkaonaolapo3715 Год назад

Awesome Video, i like the calmness and steps

@mastour722 Год назад

Great info..many thanks 😊 🙏

@McCabecadePorco Год назад

Kenjiiiii This was awesome! Thank you so much

@ellanesiewlal7584 Год назад

Fantastic, so effective!

@ThuanNguyen-jf2ej 9 месяцев назад

Thanks Kenji :) It's much helpful!!

@Datainsightsacademy Год назад

Awesome Dashboard! You are a good teacher

@dominatorgaming2980 Год назад

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

@englishwithpae1921 Год назад

Thanks, it’s very helpful

@MrDhunpagla Год назад

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

@mirnaedisa 11 месяцев назад

First try..sucessfull. Thanks a lot Kenji

@alfredyt Год назад

Thank you, looking for more power bi content

@masoumekheradmand171 3 месяца назад

It was amazing! thank you

@avengersstudios8190 Месяц назад

Thanks Man!! Great Video!!!

@YouTubeChannel2296 Год назад

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

@wencirculado9733 Год назад

Thanks for your videos.

@quiqueenrikx3992 Год назад

Thanks mate!! Always awesome!!!

@KenjiExplains Год назад

Appreciate it!

@rachel9859 Год назад

Thank you this is nice to learn

@simonoganga9535 Год назад

Amazing dashboards Kenji

@creativarevolutions Год назад

Great! Thank you !

@user-rs1id9ww8o 11 месяцев назад

Thank you from Houston, Texas!

@KenjiExplains 11 месяцев назад

thank you for watching! From London UK :)

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

This is simply amazing.

@r6burn-357 3 месяца назад

These videos teach me more than the classes I pay for

@INAdnyana Год назад

Great explanation Kenji.

@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 6 месяцев назад

You can make it your choice brr

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

@Mullajonov Год назад

thanks brother !

@tun-tunninc.6492 10 месяцев назад

Holy sweet good lord above this is gorgeous!!

@ANAS201122 21 день назад

U r the best thank u

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

@KshitijKV Год назад

Extremely Useful

@AlessandroScaltritti Год назад

beautiful

@solomonbhandari-young4154 Год назад

Amazing material

@seang2012 Год назад

Dude we need you doing this in Power BI!

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

Awesome man!

@tiddlesismyname4314 Год назад

excellent video Kenji

@CustAndCode Год назад

really impressive! 😀🤗

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

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?

@venkatsandeepsr 3 месяца назад

Great explanation

@pradipbhatta4986 Год назад

Awesome Short class

@gowthams2613 Год назад

This is pretty cool 😊

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

thank you so much.

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

You are the best. I love you.

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

@goonie79 Год назад

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

@user-sv1qw5dv3i 8 месяцев назад

thanks alots kenji

@sakibahmed1815 Год назад

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

@rosseve333 3 месяца назад

you are awesome!!!

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

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

Awesome videos!

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

Just Awesome

@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

@paulchau0203 Год назад

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

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

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.

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

@user-lc3ig9yn4z 11 месяцев назад

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

@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