HR Analytics using MS Excel for Human Resource Management

BY
Udemy

Get a thorough understanding of the principles associated with HR analytics using Microsoft Excel.

Mode

Online

Fees

₹ 499 3099

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based

Course overview

HR Analytics using MS Excel for Human Resource Management online certification is created by Start-Tech Academy - an educational organization that provides its certification in over 160 countries - and delivered by Udemy for candidates who want to expand their skills associated with concepts and strategies in HR analytics using Excel to drive business decisions to explore career opportunities in the field of human resource management.

HR Analytics using MS Excel for Human Resource Management online classes incorporates 9.5 hours of detailed learning materials along with 88 downloadable resources and 4 articles that focus on providing scientific justification to human resource decision-making in a company or organization. HR Analytics Using MS Excel for Human Resource Management online course focuses on HR analytics with a practical approach, particularly on explaining analytics for human resource managers from both statistical and computing perspectives.

The highlights

  • Certificate of completion
  • Self-paced course
  • 9.5 hours of pre-recorded video content
  • 4 articles 
  • 88 downloadable resources
  • Case studies

Program offerings

  • Online course
  • Learning resources
  • 30-day money-back guarantee
  • Unlimited access
  • Accessible on mobile devices and tv

Course and certificate fees

Fees information
₹ 499  ₹3,099
certificate availability

Yes

certificate providing authority

Udemy

What you will learn

Knowledge of excel Human resource management

After completing the HR Analytics using MS Excel for Human Resource Management certification course, candidates will gain a foundational understanding of human resources and will develop an in-depth understanding of the concepts involved with MS excel to create and automate the calculation of HR metrics and HR dashboards for HR analytics and human resource management. In this HR analytics course, candidates will explore the functionalities of excel including excel charts, excel formulas, and lookup functions. In this HR analytics certification, candidates will learn about strategies involved with sorting data, filtering data, data validation, and data importing as well as will acquire the knowledge of the techniques utilized to work linear regression and machine learning models.

The syllabus

HR Analytics -Introduction

  • Introduction
  • Data Analytics
  • Course Resources
  • This is a milestone!
  • What is HR analytics
  • 4 steps of HR analytics
  • HR metrics - Introduction

Essential Formulas

  • Basic Formula Operations
  • Mathematical Functions - part 1
  • Mathematical Functions - part 2
  • Difference between RANK, RANK.AVG and RANK.EQ
  • Textual Functions
  • Logical Functions
  • Date-Time Functions
  • Lookup Functions ( V Lookup, Hlookup, Index-Match )
  • Data Tools

Types of HR Metrics

  • Staffing Metrics
  • Training and Development Metrics
  • Performance Metrics
  • Other Metrics

HR Metrics - Case Study

  • Data and Problem statement
  • Solution

HR Charts and Dashboards - Introduction

  • HR Charts - Introduction

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
  • Sparklines
  • Quiz

Case Study 2 - HR Dashboard

  • Hr Dashboard - Introduction
  • Hr Dashboard - Age Distribution
  • Hr Dashboard - Hiring source
  • Hr Dashboard - Gender distribution
  • Hr Dashboard - Department distribution

Pivot Tables, Formatting data and tables

  • Pivot Tables
  • Pivot Charts
  • Formatting data and tables
  • Named Ranges
  • Indirect Function
  • Shortcuts

Case Study 3 - HR Dashboard

  • HR Dashboard - Pivot chart
  • HR Dashboard - Formatting

Predictive Analytics - Introduction

  • Linear Regression - Introduction

Basics of Statistics

  • Types of Data
  • Types of Statistics
  • Describing data Graphically
  • Measures of Centers
  • Measures of Dispersion

Machine Learning -Introduction

  • Introduction to Machine Learning
  • Building a Machine Learning Model

Getting Data Ready for Regression Model

  • 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

Creating Regression Model

  • 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

Case Study 4 - Linear Regression

  • 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

Bonus Section

  • Income Tax calculation - Slabs based tax
  • The final milestone!
  • Bonus Lecture

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books