Build This Excel Dashboard from Scratch in 30 MINUTES

Download the Excel file used in the video: https://www.excelcampus.com/charts/ex... Building an Excel dashboard from scratch can feel overwhelming, but this step-by-step tutorial shows you how to create a professional interactive dashboard using pivot tables and pivot charts with no complex formulas required. You will learn how to build KPI cards, a sales trend line chart, a customer mix bar chart, and a top five items column chart, then connect them all with a slicer for dynamic filtering. Along the way you will pick up practical tips on working with shapes, icons, chart formatting, and how to refresh your dashboard when new data arrives. Additional Resources: 📰Subscribe to our free Excel Pro Tips Newsletter: https://www.excelcampus.com/free 🧠Latest Free Masterclass on Excel & AI: https://www.excelcampus.com/blueprint... ▶️Related Videos: How to Design Dashboards with AI:    • This AI Prompt Designs Your Excel Dashboar...   Introduction to Pivot Tables and Dashboards:    • Introduction to Pivot Tables, Charts, and ...   Pivot Tables: Automatically Update & Refresh When Source Data Changes:    • Pivot Tables: Automatically Update & Refre...   0:00 Creating an Interactive Dashboard 0:41 Understanding the Source Data 1:24 Starting with Sales by Team Member 1:55 Building the First Pivot Table 3:26 Creating a Pivot Bar Chart 4:33 Analyzing Top Rental Items 8:07 Visualizing Sales Trends Over Time 10:21 Examining Customer Type Mix 12:41 Setting up KPI Card Data 15:16 Dashboard Design and AI Tools 16:40 Building Dashboard KPI Cards 17:47 Linking Shapes to Data 18:30 Efficient Object Selection 19:46 Adding Icons to Cards 22:21 Advanced Chart Formatting 24:33 Customizing Data Labels and Bars 25:35 Organizing Dashboard Layout 27:36 Adding and Linking Slicers 29:00 Creating a Slicer Styling Hack 29:53 Designing Custom Shapes for Headers 32:23 Applying Branding and Theme Colors 33:46 Updating the Dashboard with New Data 35:17 Data to Dashboard Workflow 35:34 Resources and Conclusion