Advanced Excel for HR Managers Automation & Analytics

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

Homepage

https://www.udemy.com/course/advanced-excel-for-hr-analytics/