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