Build an interactive Excel dashboard from scratch using pivot tables.
? Take our Excel Course: https://www.careerprinciples.com/courses/excel-for-business-finance
? DOWNLOAD Free Excel file for this video: https://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:
? The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course
? Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
? The Investment Banking Program: https://www.careerprinciples.com/career-track/the-investment-banking-program
? All our courses: https://www.careerprinciples.com/all-courses
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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.