Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Advanced Excel for HR Managers | Automation & Analytics
Rating: 4.4 out of 5(2,759 ratings)
8,620 students

Advanced Excel for HR Managers | Automation & Analytics

This course is NOT for Beginners.
Created byYoda Learning
Last updated 3/2022
English

What you'll learn

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

Course content

1 section • 7 lectures • 51m total length

  • Analyzing Expense Claims - Part 113: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 22: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)10:15

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

  • Data Cleaning for Email and Attendance4: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 Spellings5:47

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

  • Allocating Hours to Co-Facilitators8:12

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

  • Reporting - 360 Degree Feedback6:51

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

  • Quiz

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

Report abuse