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
Instructor
- 4.4 Instructor Rating
- 14,719 Reviews
- 172,454 Students
- 21 Courses
20,000 Classroom Students | 100,000+ Students Online
ex-KPMG, ex-J.P. Morgan | Chartered Accountant
Taught 12k+ participants across PwC, EY and Deloitte over last 10 years
I am a Chartered Accountant from India. I have worked with KPMG (Audit) and J.P. Morgan (Debt Capital Markets) and Futures First (Proprietary Trading Desk) before venturing into Corporate Training (first part-time and then full-time)
After a decade of corporate training and winning multiple accolades in Office Productivity and Financial Modelling, in 2015, I created a mission to help 1 million people by 2020. I started creating high-quality video courses and helped people online to become faster-smarter-better at work. A lot of my students at PwC, EY, Deloitte, Amazon, Uber, Tata Group, Rio Tinto use these video courses to excel at work.
If I’m going to succeed in my mission of helping 1 million professional in the next five years, I NEED YOU to succeed… I can’t reach my goal without helping you reach yours!