IIRF Online > Business > Human Resources > HR Analytics > HR Analytics using MS Excel for Human Resource Management
HR Analytics using MS Excel for Human Resource Management by Udemy
Use Excel for HR Analytics, calculate HR metrics, build HR dashboards & ML models for Human Resource & People Analytics
Course Highlights
- 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
Skills you will learn!
Curriculum
6 Topics
Introduction
What is HR analytics
Course resources
This is a milestone!
4 steps of HR analytics
HR metrics - Introduction
6 Topics
Basic Formula Operations
Important Excel Functions - Sum Average Concatenate Trim
Important Excel Functions- Vlookup If Count If Sum if
Sorting Filtering and Data Validation
Text-to-columns and remove duplicates
Quiz
5 Topics
Staffing Metrics
Training and Development Metrics
Performance Metrics
Other Metrics
Quiz
2 Topics
Data and Problem statement
Solution
1 Topic
HR Charts - Introduction
12 Topics
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
Scatter plot or XY chart
Frequency Distribution and Histograms
Sparklines
Quiz
5 Topics
Hr Dashboard - Introduction
Hr Dashboard - Age Distribution
Hr Dashboard - Hiring source
Hr Dashboard - Gender distribution
Hr Dashboard - Department distribution
3 Topics
Pivot Tables
Pivot Charts
Formatting data and tables
2 Topics
HR Dashboard - Pivot chart
HR Dashboard - Formatting
3 Topics
Problem Statement
Solution
Analysis
1 Topic
Linear Regression - Introduction
5 Topics
Types of Data
Types of Statistics
Measures of Centers
Measures of Dispersion
Quiz
2 Topics
Introduction to Machine Learning
Building a Machine Learning Model
15 Topics
Gathering Business Knowledge
Data Exploration
The Data and the Data Dictionary
Univariate analysis and EDD
Descriptive Data Analytics in Excel
Outlier Treatment
Identifying and Treating Outliers in Excel
Missing Value Imputation
Identifying and Treating missing values in Excel
Variable Transformation in Excel
Dummy variable creation: Handling qualitative data
Dummy Variable Creation in Excel
Correlation Analysis
Creating Correlation Matrix in Excel
Quiz
9 Topics
The Problem Statement
Basic Equations and Ordinary Least Squares (OLS) method
Assessing accuracy of predicted coefficients
Assessing Model Accuracy: RSE and R squared
Creating Simple Linear Regression model
Multiple Linear Regression
The F - statistic
Interpreting results of Categorical variables
Creating Multiple Linear Regression model
5 Topics
Case Study Linear Regression - Introduction
Case study Linear Regression - Data
Case study Linear Regression - Preprocessing
Case study Linear Regression - Results
Case study Linear Regression - Prediction
2 Topics
Importing tables from PDF - Excel 2021 and office 365
Importing data from websites - Excel 2019 and office 365
3 Topics
Income Tax calculation - Slabs based tax
The final milestone!
Bonus Lecture
HR Analytics using MS Excel for Human Resource Management
Related HR Analytics Courses
Thank You!
Your review has been submitted successfully.