HR Analytics using MS Excel for Human Resource Management
Use Excel for HR Analytics, calculate HR metrics, build HR dashboards & ML models for Human Resource & People Analytics
What you'll learn
- Use MS Excel to create and automate the calculation of HR metrics
- Make HR Dashboards and understand all the charts that you can draw in Excel
- Become proficient in Excel data tools like Sorting, Filtering, Data validations and Data importing
- Use pivot tables filtering and sorting options in Excel to summarize and derive information out of the HR data
- Implement predictive ML models such as simple and multiple linear regression to predict outcomes to real world HR problems
- Knowledge of all the essential Excel formulas required for HR Analytics
- Master Excel's most popular lookup functions such as Vlookup, Hlookup, Index and Match
Requirements
- You will need a PC with any version of Excel installed in it
Description
This course you will cover:
- Use MS Excel to create and automate the calculation of HR metrics and devise HR analytics techniques in your workplace
- Make HR Dashboards as per HR analytics standards and understand all the charts that you can draw in Excel
- Implement predictive ML models such as simple and multiple linear regression to predict outcomes to real-world HR problems using HR analytics techniques
- Use HR analytics tools like pivot tables filtering and sorting options in Excel to summarize and derive information out of the available HR data
- create appealing data summaries and dashboards to present the HR story in the most effective way
- Theoretical concepts and use cases of different HR analytics models
- Step-by-step instructions on implementing HR analytics models in excel
- Downloadable Excel files containing data and solutions used in each lecture on HR analytics and Human Resource Management
- Class notes and assignments to revise and practice the concepts on HR analytics and Human Resource Management
Who this course is for
- Anyone curious to master HR Analytics from beginner to Advanced in short span of time
- A student who wants to have a career in the field of HR/ HR Analytics
- HR manager/ executive who wants to expand on the current set of skills
This course includes
- 10 hours on-demand video
- 3 articles
- Full lifetime access
- Access on mobile and TV
- Certificate of completion
.png)
Posts
.png)
