Advanced Excel For Hr Analytics

  1. Home
  2. Hr-analytics
  3. Advanced Excel For Hr Analytics

Tags: HR Analytics

This course is NOT for Beginners.

Last updated 2022-01-10 | 4.6

- Analyzing Expense Claims
- Analyzing Google Forms Survey
- Data Cleaning for Emails

What you'll learn

Analyzing Expense Claims
Analyzing Google Forms Survey
Data Cleaning for Emails
Fuzzy Lookup

* Requirements

* VLOOKUP Basics
* Pivot Table in Depth

Description

The job of HR is not an easy task. One has to manage a huge number of employees - From acquiring good people to retain them is an intricate task.

This course will help them to perform their mundane tasks and analyze data well.

Simply gathering data on excel sheets would not be helpful. This is when HR analytics comes, it helps lets businesses to make data-driven decisions in a meaningful way. This course will help you create a powerful analysis of HR data.

You will also learn how to create and use a Pivot table and charts effectively. Real-life business problems are used as case studies to understand different tools.

This online course is self-paced to learn effective & interactive creation of Human Resource (HR) dashboards.

Who this course is for:

  • Intermediate to Advanced Excel Users

Course content

1 sections • 7 lectures

Excel Automation and HR Analytics 7 lectures

Analyzing Expense Claims - Part 1 Preview 13:31

In this video, we will learn to analyse the expense claims of employees, as follows:

  • Find out who has spent beyond their expense limit

  • Fill appropriate documentation based on the excess% spent

Analyzing Expense Claims - Part 2 Preview 02:43

This is the continuation of the video on Analyzing Expense Claims - Part 1. In this video, we will be performing an analysis on our data using the Pivot table.

Analyzing HR Survey (Google Forms) Preview 10:15

In this video, we will learn to analyze HR Survey using Google Forms

Data Cleaning for Email and Attendance Preview 04:14

In this video, we will learn the following:

  • Converting email Id from invitation email to attendance sheet

  • Convert names to email ID

  • Extract Bank A/c no. from mixed data

Reconcile Names of Different Spellings Preview 05:47

In this video, we will learn how to reconcile names of different spellings

Allocating Hours to Co-Facilitators Preview 08:12

In this video, we will learn to allocate hours to co-facilitators

Reporting - 360 Degree Feedback Preview 06:51

In this video, we will be analyzing data of 360 degree feedback