Make an Awesome Excel Dashboard in Just 15 Minutes

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

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

[@pedroleite3529]

Was it worth it?

[@sheneenellis4530]

As someone who has consumed countless hours of KZbin 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]

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

[@dakesim]

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

[@r6burn-357]

These videos teach me more than the classes I pay for

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

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

[@waiphyotun7633]

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

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

[@BackByDesign]

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

[@judithbredy5985]

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

[@fahadsher230]

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

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

[@jakemello9121]

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.

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

[@endthefed9937]

Thank you for sharing your knowledge with the rest of us

[@KenjiExplains]

Thank you for watching :)

[@Untold_archives]

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

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

[@Veer_tales]

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

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

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

[@rgarlinyc]

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

[@hunterburns]

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

[@kellyharper2039]

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

[@grantm9905]

Incredible work and excellent pace of teaching. Thank you!

[@mahmoudibrahim3535]

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

[@pr.loremarguimaraes7284]

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

[@rafaeldejesus8494]

I fell in love with classes!

[@bennyluvs]

Very cool and informative presentation, thank you.

[@neerajtiwari4261]

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

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

[@lakbaylaboy2644]

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

[@snapperhead6256]

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

[@paulmandiomaii2449]

Really simple and clear. Thank you !!

[@jwhite1202]

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

[@mirnaedisa]

First try..sucessfull. Thanks a lot Kenji

[@HangNguyen-dk8cp]

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

[@carolinekendi7446]

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

[@seyihelen]

This is awesome and straight forward. Thank you!

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

[@Techjunjun]

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

[@jacktoddy9783]

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

[@McCabecadePorco]

Kenjiiiii This was awesome! Thank you so much

[@IsmaelGarza-k7m]

Thank you from Houston, Texas!

[@KenjiExplains]

thank you for watching! From London UK :)

[@DataSageAcademy]

Awesome Dashboard! You are a good teacher

[@gerbyherby1516]

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

[@JayO-lo8kr]

Love watching your videos, Kenji. Great work!

[@Denimreovlutions]

Simple to the point well done dude

[@Blue-sh3jq]

This is beautiful, thanks 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!

[@leadmanalo6218]

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

[@yinkaonaolapo3715]

Awesome Video, i like the calmness and steps

[@m.ssharma535]

Super useful dashboard creation steps.

[@gerbyherby1516]

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]

Do you care to explain how to do that?

[@gerbyherby1516]

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

[@ShakilSayyad-c6k]

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

[@dominatorgaming2980]

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

[@candycandy319]

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

[@abiodunbabalola451]

Thank you so much for sharing this with us

[@levchikharev8512]

Awesome videos Kenji! Thank you!

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

[@jneum33224]

Excellent video. You explained things very well

[@INAdnyana]

Great explanation Kenji.

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

[@ThuanNguyen-jf2ej]

Thanks Kenji :) It's much helpful!!

[@rinaceballos4774]

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

[@purple_scorp146]

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

[@purple_scorp146]

Oh, is it by creating slicers?

[@BerkleyBuilds]

You make it look so simple! Thanks

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

[@seang2012]

Dude we need you doing this in Power BI!

[@justinwduff]

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

[@tun-tunninc.6492]

Holy sweet good lord above this is gorgeous!!

[@mastour722]

Great info..many thanks 😊 🙏

[@syed_taha_ahmed]

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

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

[@jhuggins76]

A million Thank Yous!!

[@simonoganga9535]

Amazing dashboards Kenji

[@MrDhunpagla]

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

[@michaelquach6655]

Sweeet color coded map 👍

[@KenjiExplains]

Cheers!

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

[@alfredyt]

Thank you, looking for more power bi content

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

[@masoumekheradmand171]

It was amazing! thank you

[@rachel9859]

Thank you this is nice to learn

[@sakibahmed1815]

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

[@KshitijKV]

Extremely Useful

[@quiqueenrikx3992]

Thanks mate!! Always awesome!!!

[@KenjiExplains]

Appreciate it!

[@gbodytoys]

Thank you for this!!!

[@tiddlesismyname4314]

excellent video Kenji

[@wencirculado9733]

Thanks for your videos.

[@BNLien]

You are the best. I love you.

[@englishwithpae1921]

Thanks, it’s very helpful

[@Mullajonov]

thanks brother !

[@christinembuti9318]

Good, love it. Will practice on it.

[@avengersstudios8190]

Thanks Man!! Great Video!!!

[@francisayodele7132]

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.

[@paulchau0203]

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

[@akin-ojoayotomide8909]

This is simply amazing.

[@Official_Debex]

Great piece

[@CustAndCode]

really impressive! 😀🤗

[@onkarkulkarni4129]

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