Build the ULTIMATE Excel Dashboard from Scratch

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.

Пікірлер: 253

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

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

  • @solomonbhandari-young4154

    @solomonbhandari-young4154

    Жыл бұрын

    YES

  • @belfama852

    @belfama852

    Жыл бұрын

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

  • @pragyanvaishnav1834

    @pragyanvaishnav1834

    11 ай бұрын

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

  • @Jonathan_iykee

    @Jonathan_iykee

    4 ай бұрын

    Please how do I get the data set

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

    @user-ii4ts8eg9f

    8 ай бұрын

    ❤ love it

  • @user-xr8dv2sr3q

    @user-xr8dv2sr3q

    7 ай бұрын

    Are u sure sirr???

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

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

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

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

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

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

  • @mohamedabdo-xg6tw
    @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.

  • @The-Hungry-Glut
    @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

    @KenjiExplains

    Жыл бұрын

    Glad it was helpful!

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

    production value 100%. Loved this!!

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

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

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

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

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Hope you enjoyed it!

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

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

  • @muhammaduseram9405
    @muhammaduseram94059 ай бұрын

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

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

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

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

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

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

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

  • @josab8966
    @josab89664 ай бұрын

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

  • @felipecardenas1233
    @felipecardenas123320 күн бұрын

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

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

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

    Love your tutorials, excellent work

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

    One of the best video of dashboard so far thanks !

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

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

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

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

  • @user-vm7hv4rs6i
    @user-vm7hv4rs6i10 ай бұрын

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

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

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

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

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

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

    Beautiful and simple explaination to create a interactive dashboard

  • @jamesarchieodena4107
    @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... 💗💗💗😍😍😍

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

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

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

    @KenjiExplains

    Жыл бұрын

    Awesome to hear best of luck!

  • @romelciptoadi4200

    @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

    @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

    @dorisenyingone550

    Жыл бұрын

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

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

    Great Video. Thanks a lot for your knowledge sharing!

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

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

  • @AlexanderShapaka-jv4wh
    @AlexanderShapaka-jv4wh7 ай бұрын

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

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

    Excellent video and walk-through tutorial.

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

    Such a brilliant work 👏

  • @beriliandokusnadianto2205
    @beriliandokusnadianto220511 ай бұрын

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

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

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

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Great to hear!

  • @kanisha188
    @kanisha18810 ай бұрын

    Thank you! This=is has been extremely helpful!

  • @victorbegnini5754
    @victorbegnini57547 ай бұрын

    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

    @oluwasogoabbey4269

    7 ай бұрын

    Please were you able to use the data

  • @victorbegnini5754

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

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

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

  • @nasirhalimah7021
    @nasirhalimah70215 ай бұрын

    Your are indeed a life saver. Job well done bro

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

    Thank you.. this was very instructive

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

    Thank you for this great tutorial.

  • @vanassarinputtasan8125
    @vanassarinputtasan81259 ай бұрын

    Thank you so much Kenji

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

    This is really helpful and well detailed ..kudos

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

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

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Thank you Diego!

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

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

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

    Wow makes it super easy and straight forward !

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Great to hear!

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

    Your awesome im going to try this over the weekend

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

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

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Thank you for supporting! 😁

  • @areebagul8107
    @areebagul810710 ай бұрын

    Very well explained thanks❤

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

    super super awesome. Thank you

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

    Amazing, beautiful dashboard. My inspiration chanel. 👍

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

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

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

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

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

    It's an awesome video. Thank you.

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

    Amazing. Thanks!

  • @GidongLinog
    @GidongLinog8 ай бұрын

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

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

    Thanks for inspiration, looks really good!

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Thanks for watching!

  • @VijayKumar69
    @VijayKumar6911 ай бұрын

    Thank you for such a nice video!

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

    Such an amazing video you made. Thank you

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Thank you for watching!

  • @rileygla23
    @rileygla232 ай бұрын

    Ur a legend Kenji

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

    Amazing video thank for presentation

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

    finally something worth the time.

  • @siponsgoodness2507
    @siponsgoodness25079 ай бұрын

    Excellent thanks

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

    Thanks for your videos Kenji.

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Glad you like them!

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

    Thanks Kenji, this helps me a lot.

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Glad to hear it!

  • @user-cy1eo9jh3v
    @user-cy1eo9jh3v7 ай бұрын

    Thank you 🎉

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

    You're the BEST!

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

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

    Such a good video Kenji!

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Thank you!

  • @letslearnwithpc6064
    @letslearnwithpc606410 ай бұрын

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

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

    Well done keep it up 🤝👌🏾👌🏾

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

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

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

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

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Love to hear it!

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

    Great work on this video! 😀

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Thanks Grace!

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

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

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Glad to hear that!

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

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

  • @monku1487
    @monku14876 ай бұрын

    Thank you, sir

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

    Thanks !!!

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

    Love you sir ❤

  • @Vu.ng1411
    @Vu.ng14119 ай бұрын

    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

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

    amazing!!!

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

  • @raad133
    @raad1339 ай бұрын

    Nice. Thnx

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

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

  • @ruitavares3792
    @ruitavares37926 ай бұрын

    thank you

  • @TaufiqCandra
    @TaufiqCandra5 ай бұрын

    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

    @KenjiExplains

    5 ай бұрын

    Welcome aboard!

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

    Thank youuu!

  • @dennisogsomer7426
    @dennisogsomer742610 ай бұрын

    thanks 😍😍😍

  • @bonginkosigoodwillndhlovu6776
    @bonginkosigoodwillndhlovu677611 ай бұрын

    Awesome video

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

    this video best thank you!

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

    Great video 😃👍🏼,

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

    Perfect!

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

    Thank you so much

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Thanks for watching Mateo!

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

    its really helpul,, Thanks

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Awesome to hear that!

  • @KR-ln5qw
    @KR-ln5qw8 ай бұрын

    Niccceee! 💯🙏🏾

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

    @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

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

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

    Great Video sir .

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Thanks 👍

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

    I will use it 100%!!

  • @KenjiExplains

    @KenjiExplains

    Жыл бұрын

    Great to hear!