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/w...
🎓 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: / 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/e...
⏲ 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
Watch video Interactive Excel Dashboards with Power Query and Power Pivot - FREE Download online without registration, duration hours minute second in high quality. This video was added by user MyOnlineTrainingHub 10 May 2018, don't forget to share it with your friends and acquaintances, it has been viewed on our site 661,564 once and liked it 10 thousand people.