Build the ULTIMATE Excel Dashboard from Scratch

Рет қаралды 415,922

Күн бұрын

Build an interactive Excel dashboard from scratch using pivot tables.
📊 Get 25% OFF Financial Edge courses using code KENJI25: bit.ly/3weTzPo
🆓 DOWNLOAD Free Excel file for this video: view.flodesk.com/pages/62e6c1...
In this video we'll create this interactive sales dashboard for adidas on Excel that's going to dynamically update based on the filters on the side which will allow us to select specific years, regions, products and more.
First, we'll go over the dataset and create pivot tables to show us the relevant data.
Second, we'll create the right charts and visuals for the dashboard.
Then, we'll begin the design of the actual dashboard from scratch.
And lasty we'll put everything together by dynamically linking the visuals and making them an interactive dashboard.
LEARN:
📊 Get 25% OFF Financial Edge Using Code KENJI25: bit.ly/3PvjJUV
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑‍💻 LinkedIn - / careerprinciples
GEAR:
📹 My Favorite Books & Gear: kit.co/kenjiexplains
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Pivot Table Analysis & Charts
6:52 - Designing the Dashboard
11:31 - Table format & Sparklines
16:19 - Making the Dashboard Dynamic
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.

Пікірлер: 254

@KenjiExplains Жыл бұрын

📊 Get 25% OFF Financial Edge courses using code KENJI25: bit.ly/3weTzPo

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

YES

@belfama852 Жыл бұрын

sir, may I request a tutorial video of personal income dashboard that can be interactive?

@pragyanvaishnav1834 Жыл бұрын

I am enjoying the journey with you 🥰🥰 But the excel file isn't downloading do you have another way to download it

@Jonathan_iykee 4 ай бұрын

Please how do I get the data set

@parshuramnangare8577 Жыл бұрын

Dear Kenji, I just can't stop thanking you for the value you have added in my life through your amazing excel knowledge. God bless you and thank you so much once again. love from India.

@YasinNabi Жыл бұрын

"Formal education will make you a living; self-education will make you a fortune." - Jim Rohn, This quote helped me to grow and hope it helps you too, a fellow creator,,,,

@user-ii4ts8eg9f 8 ай бұрын

❤ love it

@user-xr8dv2sr3q 7 ай бұрын

Are u sure sirr???

@ChasingMyLiberty Жыл бұрын

I know you’re the Obi-Wan Kenobi of explaining everything finance but I wanted to say I am proud of your progress and quick growth. Been following for a time long before 100k. Keep up the good work.

@seyisonade1194 Жыл бұрын

Your videos are ALWAYS top notch... thanks a million sir for adding values to our lives

@angelitojrgolimlim1841 Жыл бұрын

Man this is very useful, I cant thank you enough for every knowledge I obtained by listening to your lessons.

@mohamedabdo-xg6tw Жыл бұрын

WOW I just built a dashboard for my work using excel following this Tutorial. I am a python Fan but not having to deal with environment settings and deployment issues this approach is amazing. thank you for sharing the Knowledge.

@ragragrec1 Жыл бұрын

production value 100%. Loved this!!

@olukimkan3837 Жыл бұрын

I like the simplicity of your style very interesting, No unnecessary force or pressure.

@muhammaduseram9405 9 ай бұрын

after watching tons of tutorial on dashboard, this was the most professional and cool looking. Thanks

@qasimkazmi5913 Жыл бұрын

this was the first video I have watched of yours, full of value. Appreciated

@The-Hungry-Glut Жыл бұрын

This is something useful I can see many uses of it in the daily reports I create, this can up the notch a lot more than regular pivot data copied and pasted on emails Thanks Kenji 👍

@KenjiExplains Жыл бұрын

Glad it was helpful!

@hunterburns Жыл бұрын

Awesome boss! That's something I've been expecting from you and now you have finally done it. Take love 💖

@KenjiExplains Жыл бұрын

Hope you enjoyed it!

@yamilvogeld.2385 Жыл бұрын

What a nice dashboad! Thank you very much I learned a lot from this video Kenji!

@felipecardenas1233 Ай бұрын

I have been watching many of your videos and you are very clear at explaining. I am really thankful for your content

@abelguerrero6974 Жыл бұрын

I really appreciate your video and that you give us an example to work on while we are viewing the video. My example came out pretty good thanks to your instructions. My only critique is to add how to customize the slicers, since you went past that part. I was trying to make one to match yours and it left me with the question on how I can make one.

@josab8966 5 ай бұрын

You make it look so easy. Whew. Thanks for this Kenji

@aderojuabolaji9721 Жыл бұрын

I have always wondered how dope professional dashboards are built in excel. After watching this video, I stopped wondering 😎. Thank you ❤️

@aashishsharma6706 Жыл бұрын

One of the best video of dashboard so far thanks !

@michaelomosebi6374 Жыл бұрын

Thanks Kenji. I believe I can go ahead to build my dashboard now Also, your videos are clean...video and sound

@knowledgevoyage8828 Жыл бұрын

Love your tutorials, excellent work

@purple_scorp146 9 күн бұрын

Thanks Kenji, this is exactly what I needed to know

@narandarnanavati5449 Жыл бұрын

Thanks Kenji for such an amazing video. I thought we could only create dashboards in Power bi and tableau

@DrJohnPollard Жыл бұрын

Very present presenter. Get's right to it. Makes it look easy. Well done!

@sikanderkhan8383 Жыл бұрын

Beautiful and simple explaination to create a interactive dashboard

@jamesarchieodena4107 Жыл бұрын

Thank you so much kenji ... You are not just handsome but so helpful in making our lives better and easy... You are so cute... 💗💗💗😍😍😍

@fortune7399 Жыл бұрын

You are the one I was looking for. Thank you!

@emmanuelochulor3928 Жыл бұрын

I duff my heart for you. You are VERRRYYYYYY GOOD!

@user-vm7hv4rs6i 11 ай бұрын

Really great!!! Extremily efficient!! Thank you!!

@nasirhalimah7021 5 ай бұрын

Your are indeed a life saver. Job well done bro

@Thihgi Жыл бұрын

Awesome. Btw I would like to share my experience in the last step - report connections: I met an issue 'Report Connections Slicer Not Showing All Pivot Tables' because in the sheet Sales Trend I chose data as in the video, but I filled 'table1' for the 3 rest tables as I named the data as table 1. When I fill the data in the same way in 4 tables, it works

@BronsonKiprono Жыл бұрын

Great stuff. Thanks for doing this. I am learning a lot.

@AlexanderShapaka-jv4wh 7 ай бұрын

Thank you, really great content, delivered at a excellent pace, voice tone and language :)

@ali8bilal Жыл бұрын

Such a brilliant work 👏

@beriliandokusnadianto2205 11 ай бұрын

Thanks Kenji for the sharing! Very insightful and impactful. May God bless your career. From Indonesia. Wait for another video...

@dawnfelton8596 Жыл бұрын

This video was great! You got straight to the point! I love what I am able to do. I start a new data job next week and can't wait to demonstrate these new skills.

@KenjiExplains Жыл бұрын

Awesome to hear best of luck!

@romelciptoadi4200 Жыл бұрын

Wew, congratulation for your new position. May I ask how we can land a data job? I am struggling to get one, my main field is in healthcare since I am also a Physician, thank you

@dawnfelton8596 Жыл бұрын

@@romelciptoadi4200 I started by getting a Google Data Analytics Professional Certificate. After completing the course through Coursera, it took me a little under 5 months to get a data job.

@dorisenyingone550 Жыл бұрын

@@dawnfelton8596 Same for me .. took me 4months after getting the Google data Analytics certificate to get a data analyst position

@diegoaguilera4411 Жыл бұрын

This is quality dude, you make it look super easy!

@KenjiExplains Жыл бұрын

Thank you Diego!

@bipl8989 Жыл бұрын

Kool! That's exactly what I've been looking for. Thanks.

@mstark77 Жыл бұрын

Excellent video and walk-through tutorial.

@chilieu2621 Жыл бұрын

I do enjoy your videos. I am starting to build better excel skills and this tutorial is awesome.

@JamaicaFlores-mb1wq Жыл бұрын

Thank you so much sir.. A very big help.. God bless you sir abundantly.

@markatoe7074 Жыл бұрын

This is really helpful and well detailed ..kudos

@vanassarinputtasan8125 10 ай бұрын

Thank you so much Kenji

@kimams4588 Жыл бұрын

Great Video. Thanks a lot for your knowledge sharing!

@kanisha188 10 ай бұрын

Thank you! This=is has been extremely helpful!

@ghashanti Жыл бұрын

Thank you for this great tutorial.

@Vu.ng1411 10 ай бұрын

Thank you so much for your dedicate video above. Seem I'm no longer need Power BI anymore while I have excel to perform visual as well as Power Bi can did

@victorbegnini5754 7 ай бұрын

Awesome, Kenji! A good way to recap some concepts, expand knowledge and showcase our XP. All thanks to you and your efforts. Thanks a million!

@oluwasogoabbey4269 7 ай бұрын

Please were you able to use the data

@victorbegnini5754 7 ай бұрын

@@oluwasogoabbey4269 at first I wasn’t. But I downloaded the dataset from Kaggle , worked my way out, and followed along with the video 🙂

@taiwotitilope8332 Жыл бұрын

Best video of my life literally thumps up K👍🏽👍🏽👍🏽

@Joeyleander27 Жыл бұрын

This is really great content, learning how to use excel through your videos!

@KenjiExplains Жыл бұрын

Great to hear!

@carlacristine9338 Ай бұрын

super super awesome. Thank you

@emmanuelnwachukwu6071 Жыл бұрын

Thank you.. this was very instructive

@rileygla23 2 ай бұрын

Ur a legend Kenji

@dianemetzloff7993 Жыл бұрын

Your awesome im going to try this over the weekend

@philvuk Жыл бұрын

Wow makes it super easy and straight forward !

@KenjiExplains Жыл бұрын

Great to hear!

@aryanmanu5488 Жыл бұрын

finally something worth the time.

@areebagul8107 11 ай бұрын

Very well explained thanks❤

@siponsgoodness2507 9 ай бұрын

Excellent thanks

@md.sakerurrahmanauntor1389 Жыл бұрын

Thanks Kenji for making this tutorial.However By the help of your tutorial,I have learnt to make Dashboard.

@user-cy1eo9jh3v 7 ай бұрын

Thank you 🎉

@ey5644 Жыл бұрын

Thank you so much for taking the time and showing how to do this! Thanks!

@KenjiExplains Жыл бұрын

Thank you for supporting! 😁

@letslearnwithpc6064 10 ай бұрын

What a lovely session, brother. Beautiful. Pls do one HR dashboard .

@saidfawzy Жыл бұрын

A real great video .. Thanks so much for your kindness

@voiceofsoul7865 Жыл бұрын

It's an awesome video. Thank you.

@rhowson4838 Жыл бұрын

Such a good video Kenji!

@KenjiExplains Жыл бұрын

Thank you!

@dennisonyango2084 Жыл бұрын

Amazing. Thanks!

@GidongLinog 9 ай бұрын

You r the best dashboard Sifu on the planet .. thank you

@abdulsaidmkamara7305 Жыл бұрын

That Report Connections is a Powerful Tool That i am going to implement at work.

@thenewdataguy Жыл бұрын

Thanks for inspiration, looks really good!

@KenjiExplains Жыл бұрын

Thanks for watching!

@monku1487 6 ай бұрын

Thank you, sir

@Skippy24 Жыл бұрын

You're the BEST!

@ruitavares3792 7 ай бұрын

thank you

@AdeKaryadi Жыл бұрын

Amazing, beautiful dashboard. My inspiration chanel. 👍

@VijayKumar69 Жыл бұрын

Thank you for such a nice video!

@mohittripathi4026 Жыл бұрын

Such an amazing video you made. Thank you

@KenjiExplains Жыл бұрын

Thank you for watching!

@abhigyanbhatt5691 Жыл бұрын

I am so glad that I came across your channel❤❤

@KenjiExplains Жыл бұрын

Love to hear it!

@ibrahimibneismail9237 Жыл бұрын

Love you sir ❤

@zackymotovlogko104 Жыл бұрын

Thanks Kenji, this helps me a lot.

@KenjiExplains Жыл бұрын

Glad to hear it!

@jacintodaveiga1668 Жыл бұрын

Well done keep it up 🤝👌🏾👌🏾

@dougadiaby8815 Жыл бұрын

Amazing video thank for presentation

@graceifere3210 Жыл бұрын

Great work on this video! 😀

@KenjiExplains Жыл бұрын

Thanks Grace!

@jorgehenrique9248 Жыл бұрын

Thanks for your videos Kenji.

@KenjiExplains Жыл бұрын

Glad you like them!

@raad133 10 ай бұрын

Nice. Thnx

@maricelascinas5644 Жыл бұрын

thank you for sharing , its very helpful for my presentation and cost data analysis :-)❤❤❤😊😊😊

@Capturingthemoment Жыл бұрын

Hi kenji. Thanks for the awesome video. Super helpful. Looking forward to more videos and content. Side note: I am trying to build a dashboard as part of my academic project and plan to use this data. For the project, I would need to provide references to the origin of the data. Are you able to pls provide a bit of context on the data source? Pls and thank you!

@haopinandy Жыл бұрын

amazing!!!

@wel5072 Жыл бұрын

Thank youuu!

@dennisogsomer7426 10 ай бұрын

thanks 😍😍😍

@xiskagaming3374 Жыл бұрын

Thank you so much, I learnt a lot from you.

@KenjiExplains Жыл бұрын

Glad to hear that!

@bonginkosigoodwillndhlovu6776 Жыл бұрын

Awesome video

@draganal2214 Жыл бұрын

Perfect!

@issamelsayd Жыл бұрын

Thanks !!!

@TaufiqCandra 5 ай бұрын

I'm your new subscriber, thanks a lot for providing me very insightful video. I totally love it. It means a lot for me. Keep up the good work!

@KenjiExplains 5 ай бұрын

Welcome aboard!

@MohammadIfam1 Жыл бұрын

Thank you for this. Quick Q - If we make any new edits to the data sheet, will the dashboard automatically recognize the changes and update accordingly?

@DavidGomez-le7if Жыл бұрын

Great video 😃👍🏼,

@user-cf1rx9zy2z Жыл бұрын

this video best thank you!

@KR-ln5qw 9 ай бұрын

Niccceee! 💯🙏🏾

@mateobanda6808 Жыл бұрын

Thank you so much

@KenjiExplains Жыл бұрын

Thanks for watching Mateo!

@vikramadityarathore97 Жыл бұрын

Hey Kenji enjoyed your previous video when you shared facts about yourself. Congrats for 100k subs and many more to come. If possible could you make a video on mergers and acquisitions and concept of synergy.

@KenjiExplains Жыл бұрын

Thank you! I don't think that's a topic I'll be covering soon as I don't know it too well sorry

@vikramadityarathore97 Жыл бұрын

@@KenjiExplains no problem mate , if you can do interview related videos for different profiles apart from your insightful excel videos it would be great.