- Introduction
- Data Analytics
- Course Resources
- This is a milestone!
- What is HR analytics
- 4 steps of HR analytics
- HR metrics - Introduction
Online
₹ 649 1,299
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 11 hours of detailed learning materials along with 96 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
- 11 hours of pre-recorded video content
- 4 articles
- 96 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
certificate availability
certificate providing authority
What you will learn
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.
Who it is for
The syllabus
HR Analytics -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