HR Analytics using MS Excel for Human Resource Management

4.9 /5

(16 Ratings)

Offered byUDEMY

HR Analytics using MS Excel for Human Resource Management
at
UDEMY
Overview

Become proficient in Excel data tools like Sorting, Filtering and Data validations & learn the necessary knowledge and skills related to HR analytics and HRM

Duration	10 hours
Total fee	₹525
Mode of learning	Online
Credential	Certificate

HR Analytics using MS Excel for Human Resource Management
at
UDEMY
Highlights

Student will get the Certificate Of Completion
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
Get full lifetime access of this course

HR Analytics using MS Excel for Human Resource Management
at
UDEMY
Course details

Skills you will learn

Spark Human resource management Excel Vlookup Staffing HRM Training and Development Statistics

Who should do this course?

For HR manager/ executive or anyone interested in learning about HR Analytics from beginner to Advanced in short span of time

What are the course deliverables?

Essential MS Excel formulas and using them to calculate HR metrics
Visualization in Excel and HR Dashboarding
Data summarization using Pivot tables
Basics of Machine Learning and Statistics
Preprocessing Data for ML models
Linear regression model for predicting metrics
pivot tables filtering and sorting options in Excel to summarize and derive information out of the HR data

More about this course

The basic theory behind each concept without getting too mathematical about it so that you understand where the concept is coming from and how it is important
This course includes Essential MS Excel formulas and using them to calculate HR metrics
The necessary knowledge and skills related to HR analytics and human resource management
Step-by-step instructions on implementing HR analytics models in excel
This course covers topics like outlier treatment, missing value imputation, variable transformation, and correlation

HR Analytics using MS Excel for Human Resource Management
at
UDEMY
Curriculum

MODULE:1 HR Analytics-Introduction

Data Analytics

Course Resources

This is a milestone!

What is HR analytics

4 steps of HR analytics

HR metrics - Introduction

MODULE:2 Essential Formulas

Mathematical Functions

Difference between RANK, RANK.AVG and RANK.EQ

Textual Functions

Logical Functions

Date-Time Functions

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

Data Tools

MODULE:3 Types Of HR Metrics

Staffing Metrics

Training and Development Metrics

Performance Metrics

Other Metrics

MODULE:4 HR Metrics- Case Study

Data and Problem statement

Solution

MODULE:5 HR Charts And Dashboard

HR Charts

MODULE:6 Excel Charts

Excel Charts - Categories of messages that can be conveyed

Elements of charts

The Easy way of creating charts

Bar and column charts

Formating charts

Line Charts

Area Charts

Pie and Doughnut Charts

Why we should avoid Pie charts

Scatter plot or XY chart

Frequency Distribution and Histograms

Spark lines

Quiz

MODULE:7 Case Study 2- HR Dashboard

Hr Dashboard - Introduction

Hr Dashboard - Age Distribution

Hr Dashboard - Hiring source

Hr Dashboard - Gender distribution

Hr Dashboard - Department distribution

MODULE:8 Pivot Tables, Formatting Data and tables

Pivot Tables

Pivot Charts

Formatting data and tables

4.9/5

16 Ratings

4-5
14
3-4
2

Neha Sharma

HR Analytics using MS Excel for Human Resource Management

Offered by UDEMY

Learning Experience: It was great, the content, language, resources everything was on point.

Faculty: Faculty was great, way of teaching was very nice Course curriculum was very nice, it was easy to understand

Reviewed on 21 Jan 2023Read More

Shivangi Bhardwaj

HR Analytics using MS Excel for Human Resource Management

Offered by UDEMY

Learning Experience: The course was very well planned by the course administrator. And the way the faculty explained it was really helpful and easy to understand.

Faculty: The faculty apporach was very great. Faculty clears all the basic concept with delivery of in dept knowledge The sections and the way they are all planned keeping in mind the actual requirements of the metrics in different organizations

Reviewed on 9 Dec 2022Read More

Aparna B

HR Analytics using MS Excel for Human Resource Management

Offered by UDEMY

Learning Experience: The course was well structured, and easily understandable by me. Instructors were on point while teacbing various formulas. It is because of this course, that I could get many job opportunities. Thanks to Udemy

Faculty: The facultt's approach towards teaching was exceptional. It is individual study and there were no live sessions. But you get life-time access of this course which is a biggest advantage. Learning experience was absolutely good.course curriculum included various formulae used to calculate the ratios associated with the HR department of an organisation, formulas and functions how to use pivot table and how to create dashboards were highlights of the course. The course has 1 final test to get certificate and the course included assignments which has to be taken by yhe candidates simultaneously.

Course Support: I got many job opportunities after completing this course.

Reviewed on 29 Jul 2022Read More

Pratiksha Prabhu

HR Analytics using MS Excel for Human Resource Management

Offered by UDEMY

Learning Experience: Learning experience was good

Faculty: Instructors taught well Curriculum was relevant and comprehensive

Course Support: Career support was helpful

Reviewed on 21 May 2022Read More

Chandan Shenoy P

HR Analytics using MS Excel for Human Resource Management

Offered by UDEMY