Build the ULTIMATE Excel Dashboard from Scratch
418,173
2022-08-21に共有
📊 Get 25% OFF Financial Edge courses using code KENJI25: bit.ly/3weTzPo
🆓 DOWNLOAD Free Excel file for this video: view.flodesk.com/pages/62e6c1afc4d48aec3664b8e4
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 - www.instagram.com/careerprinciples/?hl=en
🤳 TikTok - www.tiktok.com/@career_principles
🧑💻 LinkedIn - www.linkedin.com/company/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
コメント (21)
-
📊 Get 25% OFF Financial Edge courses using code KENJI25: bit.ly/3weTzPo
-
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.
-
Your videos are ALWAYS top notch... thanks a million sir for adding values to our lives
-
Man this is very useful, I cant thank you enough for every knowledge I obtained by listening to your lessons.
-
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.
-
production value 100%. Loved this!!
-
"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,,,,
-
this was the first video I have watched of yours, full of value. Appreciated
-
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.
-
I like the simplicity of your style very interesting, No unnecessary force or pressure.
-
after watching tons of tutorial on dashboard, this was the most professional and cool looking. Thanks
-
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 👍
-
I have been watching many of your videos and you are very clear at explaining. I am really thankful for your content
-
Awesome boss! That's something I've been expecting from you and now you have finally done it. Take love 💖
-
What a nice dashboad! Thank you very much I learned a lot from this video Kenji!
-
Thanks Kenji. I believe I can go ahead to build my dashboard now Also, your videos are clean...video and sound
-
You make it look so easy. Whew. Thanks for this Kenji
-
I duff my heart for you. You are VERRRYYYYYY GOOD!
-
Love your tutorials, excellent work
-
You are the one I was looking for. Thank you!
