In this video you will learn how to create an interactive HR 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
Learn POWER QUERY here: https://www.myonlinetraininghub.com/e...
Learn POWER PIVOT here: https://www.myonlinetraininghub.com/p...
SUBSCRIBE to my free newsletter and get my 100 Tips & Tricks eBook here: https://www.myonlinetraininghub.com/s...
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
1:02 Get Data with Power Query
6:09 Active Employess Column Chart
13:59 Ethnic Group Column Chart
20:51 Separations & Termination Column Charts
25:01 Headline Visuals
39:20 Slicers
44:23 Color Formatting
46:07 Dashboard Tabs
49:08 Automatica Updating
50:27 Icons
52:15 Outro