HR Metrics & Analytics using MS Excel

Description:

THE COURSE

HR Metrics & Analytics using MS Excel (+Free Template & Work Tools)

CLIENT NAME 

Bet9ja

COURSE OVERVIEW 

You’re looking for a complete course on understanding HR Analytics using Excel to drive business decisions, right?

You’ve found the right HR Analytics using MS Excel course! HR analytics provides scientific support to decision-making concerning a firm’s human resources. This course on HR analytics addresses the topic of HR analytics with a practical focus, focusing especially on demystifying analytics for Human Resource managers, from both statistical and computing point of view.

LEARNING OUTCOME 

  • 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

TARGET PARTICIPANTS

HR Managers & Executives

COURSE DATE & DURATION

Tuesday, 4th & Wednesday, 5th October, 2022.

 

Call Us