HR Analytics using MS Excel

Introduction

Welcome to the course – HR Analytics using MS Excel

Course Resources

What is HR analytics

4 steps of HR analytics

Essential Formulas

HR metrics – Introduction

Basic Formula Operations

Mathematical Functions

Difference between RANK, RANK.AVG and RANK.EQ

Textual Functions

Logical Functions

Date-Time Functions

Lookup Functions (V Lookup, Hlookup, Index-Match)

Types of HR Metrics

Staffing Metrics

Training and Development Metrics

Performance Metrics

HR Metrics - Case Study

Data and Problem statement

HR Charts and Dashboards - Introduction

1 of 5

Previous Lesson

Mathematical Functions

HR Analytics using MS Excel Mathematical Functions

Previous Lesson

Login

Accessing this course requires a login. Please enter your credentials below!

Username or Email Address

Password

Remember Me

Lost Your Password?

Register

Don't have an account? Register one!

Register an Account

Username

Email

Registration confirmation will be emailed to you.