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
Смотрите видео Interactive Excel HR Dashboard - FREE Download онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь MyOnlineTrainingHub 21 Февраль 2019, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 1,256,674 раз и оно понравилось 18 тысяч людям.