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: https://bit.ly/3weTzPo
🆓 DOWNLOAD Free Excel file for this video: https://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: https://bit.ly/3PvjJUV
SOCIALS:
📸 Instagram - https://www.instagram.com/careerprinc...
🤳 TikTok - / career_principles
🧑💻 LinkedIn - / careerprinciples
GEAR:
📹 My Favorite Books & Gear: https://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.
Watch video Build the ULTIMATE Excel Dashboard from Scratch online without registration, duration hours minute second in high quality. This video was added by user Kenji Explains 21 August 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 424,920 once and liked it 9.4 thousand people.