Modern Excel Dashboard
Most Excel dashboards rely heavily on Pivot Tables and slicers. What if you could build a clean, fully interactive dashboard without using either of them? In this video, you’ll see a modern approach to dashboard design that gives you more flexibility, better performance, and complete control over how your data behaves.
I’ll walk you through how to structure your data, apply dynamic formulas, and use charts that respond instantly to user input. You’ll learn how to create interactivity using simple lists, making your dashboards feel more like a custom solution than a spreadsheet.
This method is useful if you want lighter files, custom layouts, or dashboards that are easier to maintain and customize.
You’ll have a repeatable framework you can use to build professional, modern Excel dashboards with confidence.
🕙 You can use these timestamps in case you are looking for something specific
00:00 - Introduction
00:09 - Sneak Peak at the Dashboard
01:18 - Creating self growing lists or dropdowns
04:16 - Creating a simple list
05:18 - Filtering data based on Category and Region
07:55 - Choosing the data based on metric
10:35 - Creating the dashboard summary data
12:15 - Creating charts for the dashboard
13:57 - Creating KPIs
▶️ Other videos that may interest you
SORT Function in Excel
FILTER Function in Excel
UNIQUE Function in Excel
INDEX & MATCH Functions in Excel
The # Symbol in Excel
GROUPBY Function in Excel
VSTACK Function in Excel
Creating Names in Excel
CHOOSE Function in Excel
Tables or Structured References in Excel
Dashboard in Excel using Pivot Tables and Slicers
✅ Subscribe to our Channel to level up your Excel and Power BI skills faster
⬇️ Download the file used in the video
💻 Courses offered by us
Learn more about our Excel Masterclass course
Explore all courses
📘 Download our E-Book on Excel Shortcuts (Windows and Mac)
🗂️ Access all our templates and E-Books
🤝 Connect with us
#analyticssuccess #dashboard #excel #ExcelDashboard #excelhacks #exceltips #msexcel #sheets