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

Created by: Start-Tech Academy
5,000,000+ Enrollments | 4.5 Rated | 160+ Countries

What Will I 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

Target audience

• 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