
Advanced Excel For Hr Managers | Automation & Analytics
Last updated 3/2022
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 805.82 MB | Duration: 0h 52m
This course is NOT for Beginners.
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.
Intermediate to Advanced Excel Users