Build an awesome interactive Excel dashboard in just 15 minutes.
Take our Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
All our courses: https://www.careerprinciples.com/courses
🆓 DOWNLOAD Free Excel file for this video: https://view.flodesk.com/pages/63dd44d5781752946ff2af78
In this video we'll build a dynamic Excel dashboard from scratch in just 15 minutes. This will be a sales dashboard for McDonald's South America region. First, we'll make the dashboard dynamic using hyperlink to navigate to the different tabs. Then we'll build the overall structure using shapes and icons. Next we'll create all of the charts and visuals which include a map chart, radar chart, line chart, doughnut chart, KPIs, and more. Finally, we'll customize the visuals and add them to the 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
All our courses: https://www.careerprinciples.com/courses
SOCIALS:
Instagram - https://www.instagram.com/careerprinciples/?hl=en
🤳 TikTok - https://www.tiktok.com/@career_principles
🧑 LinkedIn - https://www.linkedin.com/company/careerprinciples/
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Making the Dashboard dynamic
2:11 - Dashboard Structure
4:15 - Creating the charts and visuals
9:34 - Customising the visuals and putting it all together
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.