Make an Interactive Excel Dashboard From Scratch (Full Tutorial)

Make an interactive Excel Dashboard using Pivot Tables from scratch. 🚀 Get 20% OFF our Data Analyst Program: https://www.careerprinciples.com/career-track/the-data-analyst-program 🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/bzsj26qt0h In this video, you’ll learn how to build a fully interactive sales dashboard in Excel using a European sales dataset for an outdoor company. We’ll start by designing the dashboard layout, then use Pivot Tables to calculate key KPIs such as revenue, gross profit, average revenue, and units sold. From there, we’ll create visuals including a monthly revenue and profit trend, a sales heatmap of Europe, product category performance, and the top five best-selling products. Finally, we’ll make the dashboard interactive by adding slicers and a timeline for filtering by customer type, region, sales channel, and date. We’ll connect these controls to all of the Pivot Tables so every KPI and chart updates automatically, then add navigation buttons to move between the dashboard, dataset, and analysis sheets. You’ll also see how to refresh the dashboard when the original data changes, plus several useful Excel dashboard tricks you can apply to your own projects. LEARN: 👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance 📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course 🔥 AI for Business & Finance: https://www.careerprinciples.com/courses/ai-for-business-finance 🚀 All our courses: https://www.careerprinciples.com/all-courses ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Chapters: 0:00​ -​ Overall Layout 2:00​ - Adding Shapes 4:07​ - Pivot Table Analysis 10:46​ - Adding KPIs 13:53​ - Charts, Maps & Visuals 22:14​ - Interactive Elements (Slicers & Timeline) 26:40​ - Navigation