Build This Excel Dashboard from Scratch in 30 MINUTES @ExcelCampus
Build This Excel Dashboard from Scratch in 30 MINUTES  @ExcelCampus
Uploaded June 2026 | Updated November 2026, 15 hours ago
Download the Excel file used in the video: excelcampus.com/charts/excel-dahsboard-tutorial-full-buildout

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:
excelcampus.com/free

🧠Latest Free Masterclass on Excel & AI: excelcampus.com/blueprint-masterclass

▶️Related Videos:
How to Design Dashboards with AI: youtu.be/IWeJwQxgZMo
Introduction to Pivot Tables and Dashboards: youtu.be/9NUjHBNWe9M
Pivot Tables: Automatically Update & Refresh When Source Data Changes: youtu.be/NI1UQcYtl1A


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
Build This Excel Dashboard from Scratch in 30 MINUTESHidden Excel Menu Saves Hours of Work #exceltips #dataanalysis #hacksUse Copilot to Find Hardcoded Values in FormulasHow to Add a Real-Time Digital Clock in Excel ⏰Stop Writing Christmas Lists on Paper 🎄 Use FREE Excel Instead17 Ways to Use Excel’s New COPILOT Function (🤯 Data Cleanup)Create an Eye-Catching Star Rating Chart in Excel ⭐️ | Fast & Easy TutorialCreate a Clickable Gallery in Excel Dashboard! ✨Recover Deleted Data in Excel in Seconds! 😱How to Transpose Data in Excel (2 Easy Ways) 🔄This Excel Chart Updates Automatically! ⚡📈Excel Copilot vs Google Sheets AI — The Ultimate Date Cleanup Test! 🧹📅
Excel Campus - Jon |

Build This Excel Dashboard from Scratch in 30 MINUTES

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER