Make a Dynamic Excel Dashboard in 4 simple steps.
Take our Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance

🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/p56vpzn1mu

In this tutorial, we'll make this beautiful, interactive Excel dashboard in four simple steps in just 20 minutes. First, we'll set up the dashboard structure using Excel shapes and images. Then, we'll look at the dataset and analyze it with pivot tables to get the relevant numbers. Third, we'll build the right charts and visuals. These include some KPIs (key performance indicators), tables, and charts such as a combo chart. Finally, we'll create pivot table slicers to make the whole dashboard dynamic.

LEARN:
Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics
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​​ - Step 1: Dashboard Structure
4:17​ - Step 2: Data Analysis
9:08​ - Step 3: Visuals (Charts, KPIs and Tables)
16:14​ - Step 4: Make the Dashboard Dynamic with Slicers

Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.