Build an interactive Excel dashboard from scratch using pivot tables.
📊 Get 25% OFF Financial Edge courses using code KENJI25: [ Ссылка ]

🆓 DOWNLOAD Free Excel file for this video: [ Ссылка ]

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: [ Ссылка ]

SOCIALS:
📸 Instagram - [ Ссылка ]
🤳 TikTok - [ Ссылка ]
🧑‍💻 LinkedIn - [ Ссылка ]

GEAR:
📹 My Favorite Books & Gear: [ Ссылка ]
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

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.

свернуть