Play Video
Preview this course

HR Analytics using Excel

Use Excel for HR Analytics, calculate HR metrics, build HR dashboards & ML models for Human Resource & People Analytics

0 / 5
Rating
0 +
Students
0 Hrs
Duration

499 375

Price

HR Analytics using Excel

What you'll learn

Introduction to HR metrics

Learn popular HR metrics and implementation of excel formulas to calculate and automate the HR metrics.

HR Dashboarding

Learn popular Excel charts. Then we will see the implementation of these charts to create visualize HR data

HR Data summarization

Learn Pivot tables, indirect functions, and data formatting to create beautiful summaries of HR Data

Application based Learning

Throughout the course we will discuss separate case study for each of the section to solidify your learning of the important concepts

Linear regression model

Complete guide to create Linear regression model from data preprocessing to model building on an HR dataset to predict the CTC of new hires

Our Happy Students!

Definitely! Human Resource management is a critical factor in Organisational efficiency. HR Analytics helps you identify the areas for improvement and implement.

5/5

Dr Sandeep

One of the best HR Analytics courses in crowded e-courses market. Concepts were explained in a very layman language and it proved that using excel only, majority of the projects can be completed

5/5

Ankur

This course is an eye opener. I was only able to apply charts, to training and outstation reports but now I can apply it to other aspects in the HR Metrics. Its a great course.

5/5

Ubong Ukpe

Course Instructors

Abhishek Bansal

Co-Founder, Instructor

Ex-Airtel, FMS Delhi, IIT Roorkee
Worked as an Acquisition Process owner in a leading telecom company before moving on to learning and teaching technologies like Machine Learning and Artificial Intelligence.

Pukhraj Parikh

Co-Founder, Instructor

Ex-EXL, IIM Ahmedabad, IIT Roorkee
Worked as a Project manager in an Analytics consulting firm. Pukhraj has multiple years of experience working on analytics tools and software.

Course Completion Certificate‚Äč

Once you successfully complete the course, Start-Tech Academy will provide you with an industry-recognized course completion certificate

Still confused? Download the complete course syllabus

HR Analytics using Excel - Desc

Course Content

Course Content

Introduction
Essential Formulas
Types of HR Metrics
HR Metrics – Case Study
HR Charts and Dashboards – Introduction
Excel Charts
Case Study 2 – HR Dashboard
Pivot Tables, Formatting data and tables
Case Study 3 – HR Dashboard
Predictive Analytics – Introduction
Basics of Statistics
Machine Learning -Introduction
Getting Data Ready for Regression Model
Creating Regression Model
Case Study 4 – Linear Regression
Bonus Section