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:
▶️Related Videos:
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