HR Dashboard with Excel
Overview: HR dashboard is a dynamic overview of the most important HR metrics in one place. The HR dashboard provides a slice-and-dice overview of the workforce, their performance, absence, and turnover. It is key for strategic decision making in HR. The dashboard is used as the most powerful decision-making tool globally. Visualize, Track, Analyze, and make the Perfect Decision for your business. The course is designed to deliver fully automated reports and dashboards that will enable you to enhance productivity in the organization. Key Learnings: 1. Understanding Dashboard Architecture & Required Excel Tools for a Dashboard 2. Understand proper Data …
Curriculum
Curriculum
- 1 Section
- 16 Lessons
- 204 Weeks
- HR Dashboard with Excel16
- 2.1Introduction1 Minute
- 2.2Exercise Files
- 2.3Shortcuts32 Minutes
- 2.4Index10 Minutes
- 2.5Sums Part 111 Minutes
- 2.6Sums Part 26 Minutes
- 2.7Large & Smaill23 Minutes
- 2.8Form Controls37 Minutes
- 2.9Quick Overview2 Minutes
- 2.10Chart Tips29 Minutes
- 2.11Chart Customization5 Minutes
- 2.12SparkLines10 Minutes
- 2.13Quick Recap3 Minutes
- 2.14Dashboard Part 156 Minutes
- 2.15Dashboard Part 243 Minutes
- 2.16Dashboard Part 341 Minutes
Overview
Overview:
HR dashboard is a dynamic overview of the most important HR metrics in one place. The HR dashboard provides a slice-and-dice overview of the workforce, their performance, absence, and turnover. It is key for strategic decision making in HR. The dashboard is used as the most powerful decision-making tool globally. Visualize, Track, Analyze, and make the Perfect Decision for your business. The course is designed to deliver fully automated reports and dashboards that will enable you to enhance productivity in the organization.
Key Learnings:
1. Understanding Dashboard Architecture & Required Excel Tools for a Dashboard
2. Understand proper Data Set to develop highly effective reports
3. Learn the Essentials of Power Query to Automate Report
4. Discover highly productive ways of presenting Data with PivotTable and Custom Data Table
5. Learn Effective Visualization Techniques in Excel
6. Prepare Animated Dashboard on Real Life Case
7. Learn Data Storytelling Techniques for Dashboards
Note:
- After completing every lesson click on the “COMPLETE” button the go to the next lesson.
- Must set up your first name, last name, and display name from settings of your profile for your certificate.
- don’t click on the “FINISH COURSE” button.
- If you click on the “FINISH COURSE” button then the course will be finished and a Certificate will be generated.
- More details: https://thrivingskill.com/faqs/
Instructor:
Course and Training of this Instructor:
- Business Reporting with PivotTables
- Advance Excel Functions & Tools
- HR Analytics & Dashboard with Excel
- Tips & Tricks of Modern Dashboard
- Bring Data to Life Excel Dashboard
- Use Excel Like a Pro!
- PivotTable Basic to Pro
- Increase Office Productivity with MS Excel Lookup Series
- Power up Excel Report with Power Pivot & Power Query
- HR Analysis & Dashboard with Excel
- Essentials of Excel Business Intelligence Tool
- Automate HR Dashboard & Reporting with Excel