Turn Your Messy Spreadsheet Into an Interactive Dashboard
From MyOnlineTrainingHub · · 22 min

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.
If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.
Description
Turn a fragile Excel report into an interactive dashboard that updates with one click. ⬇️ Download the example file here and follow along: https://bit.ly/fixes26file 👩🏫 Take my Excel Reporting Analyst program: https://bit.ly/fixes26course
👩🏫 Master Excel & Power BI with my courses: https://bit.ly/fixes26courses
In this Excel tutorial, I rebuild a spreadsheet that breaks whenever new rows are added or data is moved.
You’ll learn how to organize your Excel data correctly, prevent formulas and totals from breaking, and create an interactive dashboard that is easy to update.
I also show you how to use an Excel Table, PivotTables, charts, and a slicer to turn a time-consuming report into a reliable reporting system.
This tutorial is useful for anyone who creates recurring reports, maintains large spreadsheets, or spends too much time fixing Excel files after the data changes.
LEARN MORE ===========
📰 EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/excel-newsletter-sign-up
🎯 FOLLOW me on LinkedIn: https://www.linkedin.com/in/myndatreacy/
💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS ============== 0:00 Why the spreadsheet keeps breaking 1:11 Restructure data into a tabular layout 5:52 Convert data into an official Excel Table 7:54 Plan the interactive dashboard 9:53 Link summary cards with PivotTables & GETPIVOTDATA 12:25 Build a dynamic Donut KPI chart 15:35 Build a timeline Column chart 16:43 Build a ranked Bar chart by project 19:21 Connect Slicers to all charts 21:45 Test the 1-click Refresh All 22:13 Build Excel dashboards in under 15 minutes
#Excel #ExcelReport #ExcelDashboard