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

Anyone curious to master HR Analytics from beginner to Advanced in short span of time
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

ENROL NOW