Tutorialspoint
Subscription Includes
$ 130   9.99

HR Analytics using MS Excel for Human Resource Management

Created by Abhishek And Pukhraj, Last Updated 11-Oct-2020, Language:English

HR Analytics using MS Excel for Human Resource Management

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

Created by Abhishek And Pukhraj, Last Updated 11-Oct-2020, Language:English

What Will I Get ?

  • 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

Requirements

  • You will need a PC with any version of Excel installed in it

Description

You're looking for a complete course on understanding HR Analytics using Excel to drive business decisions, right?

You've found the right HR Analytics using MS Excel course! HR analytics provides scientific support to decision-making concerning a firm's human resources. This course addresses the topic of HR analytics with a practical focus, focusing especially on demystifying analytics for HR managers, from both statistical and computing point of view.

After completing this course you will be able to:

  • 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

  • Implement predictive ML models such as simple and multiple linear regression to predict outcomes to real world HR problems

  • Use pivot tables filtering and sorting options in Excel to summarize and derive information out of the HR data

  • create appealing data summaries and dashboards to present the HR story in the most effective way

How this course will help you?

A Verifiable Certificate of Completion is presented to all students who undertake this HR Analytics: Strategies & Models in Excel course.

If you are an Human Resources manager or an executive, or a student who wants to learn and apply analytics techniques to real world problems of the HR business function, this course will give you a solid base for that by teaching you the most popular HR analytics models and how to implement it them in MS Excel.

Why should you choose this course?

We believe in teaching by example. This course is no exception. Every Section’s primary focus is to teach you the concepts through how-to examples. Each section has the following components:

  • Theoretical concepts and use cases of different HR models

  • Step-by-step instructions on implementing HR models in excel

  • Downloadable Excel files containing data and solutions used in each lecture

  • Class notes and assignments to revise and practice the concepts

The practical classes where we create the model for each of these strategies is something which differentiates this course from any other course available online.

Course Content

Abhishek And Pukhraj

Start-Tech Academy is a technology-based Analytics Education Company and aims at Bringing Together the analytics companies and interested Learners.
Our top quality training content along with internships and project opportunities helps students in launching their Analytics journey.

Founded by Abhishek Bansal and Pukhraj Parikh.

Working as a Project manager in an Analytics consulting firm, Pukhraj has multiple years of experience working on analytics tools and software. He is competent in  MS office suites, Cloud computing, SQL, Tableau, SAS, Google analytics and Python.

Abhishek 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.