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: https://www.myonlinetraininghub.com/workbook-downloads
🎓 LEARN MORE in my comprehensive courses: https://www.myonlinetraininghub.com/
🔔 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: https://www.linkedin.com/in/myndatreacy/
🎁 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: https://www.myonlinetraininghub.com/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