In this video you will learn how to create an interactive Excel dashboard from scratch using Excel's Power Query and Power Pivot tools. Applies to Excel 2010 onward for Windows only. 🔻 DOWNLOAD file used in the video with step by step instructions and links to more tutorials: 🎓 LEARN MORE in my comprehensive courses: 🔔 SUBSCRIBE if you’d like more tips and tutorials like this. 💬 Please leave me a COMMENT. I read them all! 🧟‍♀️ CONNECT with Mynda on LinkedIn: 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 💬 EXCEL QUESTIONS: Get help on our Excel Forum: ⏲ TIMESTAMPS 0:00 Introduction 2:46 Dashboard File Setup & Get Data 10:47 Get Dimension Tables (Power Pivot) 16:21 Build PivotTables & Charts 33:07 Sparklines 42:46 Slicers 49:29 Automatic Updates 51:49 Outro