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)
- How To Create Your Own Asset Manager With Check-In/Check-Out & Depreciation In Excel [Free Download] ( Download)
- How To Create DocuWare Merge Forms Part 2: Creating the Form ( Download)
- Templated Export for Google Spreadsheet: Publishing data from other sources ( Download)
- Google Spreadsheet Formula's ( Download)
- Winning New Business with the fi360 Toolkit ( Download)
- Dynamic Planning in Planful, from Excel to the Cloud ( Download)
- Creating a Google Site ( Download)
- Project Management Webinar #12- Standard Plans Update ( Download)
- Easy Pre-configured Document Management for Finance ( Download)
- Getting Your GIS Data from Here to There: Processes and Best Practices for ETL ( Download)
- A Deep Dive into Execution Plans & How to Use Them! - Janis Griffin ( Download)
- Study Design: Developing a Monitoring Program that Delivers Results ( Download)
- How automated invoice processing works ( Download)
- SAS Programming Training Full Course | Learn SAS Classes Free | SAS Tutorial | Great Online Training ( Download)
