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: myonlinetraininghub.com/workbook-downloads

🎓 LEARN MORE
- Learn POWER QUERY here: myonlinetraininghub.com/excel-power-query-course
- Learn POWER PIVOT here: myonlinetraininghub.com/power-pivot-course

🔔 SUBSCRIBE to my free newsletter and get my 100 Tips & Tricks eBook here: myonlinetraininghub.com/sign-up-for-100-excel-tips-and-tricks

💬 Please leave me a COMMENT. I read them all!

🧟‍♀️ CONNECT with Mynda on LinkedIn: 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: myonlinetraininghub.com/excel-forum

⏲ 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 ( Download)
• NEW ADVANCED EXCEL HR DASHBOARD: Interactive Excel Hr Dashboard Free Download (part-1) ( Download)
• Interactive Excel Project Management Dashboard - FREE Download ( Download)
• How to build an Interactive HR Dashboard in Excel | HR Analytics in Excel [2024] ( Download)
• Create HR Dashboard in Excel - Free Dashboards and Templates ( Download)
• NEW ADVANCED EXCEL HR DASHBOARD: Interactive Excel Hr Dashboard free Download (part 2) ( Download)
• Excel Finance HR Dashboard ( Download)
• Excel Dashboard from start to end (Part 1) | HR Analytics Dashboard | Start to End Design ( Download)
• How to Make INTERACTIVE Excel Dashboards - Step by Step Guide ( Download)
• Build an interactive Human Resources Dashboard in Microsoft Excel - HR Dashboard ( Download)
• Interactive Dashboard Step by Step + FREE File Download ( Download)
• Interactive Excel Dashboard for BETTER Data Visualization (Free Download) ( Download)
• Make an Interactive Excel Dashboard in Just 12 Minutes ( Download)
• HR Dashboard Template Excel (dynamic and flexible) ( Download)
• NEW ADVANCED EXCEL HR DASHBOARD with Search bar: Interactive Excel Hr Dashboard part 3 ( Download)