HR Analytics using MS Excel

Data Analytics
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
Data Tools
Staffing Metrics
Training and Development Metrics
Performance Metrics
HR Metrics - Case Study
Other Metrics
Data and Problem statement
HR Charts and Dashboards - Introduction
Solution
Excel Charts
HR Charts – Introduction
1 of 5
Previous Lesson
Next Lesson

Mathematical Functions

HR Analytics using MS Excel Mathematical Functions
Previous Lesson
Back to Course
Next Lesson
Login
Accessing this course requires a login. Please enter your credentials below!

Lost Your Password?
Register
Don't have an account? Register one!
Register an Account

Registration confirmation will be emailed to you.