Use Excel for HR Analytics, calculate HR metrics, build HR dashboards & ML models for Human Resources and People Analytics
What you’ll learn
- Use MS Excel to create and automate the calculation of HR metrics
- Make HR Dashboards and understand all the charts that you can draw in Excel
- Become proficient in Excel data tools like Sorting, Filtering, Data validations and Data importing
- Use pivot tables filtering and sorting options in Excel to summarize and derive information from the HR data
- Implement predictive ML models such as simple and multiple linear regression to predict outcomes to real-world HR problems
- Knowledge of all the essential Excel formulas required for HR Analytics
- Master Excel’s most popular lookup functions such as Vlookup, Hlookup, Index and Match
Top companies offer this course to their employees. This course was selected for our collection of top-rated courses trusted by businesses worldwide. Learn more
Requirements
- You will need a PC with any version of Excel installed in it
- Added a new video on how to import HR-related data from PDF format reports to Excel for analysis
- Added a new video on how to get data tables from websites into Excel
You’re looking for a complete course on understanding HR Analytics using Excel to drive business decisions, right?
You’ve found the right HR Analytics using MS Excel course! HR analytics provides scientific support to decision-making concerning a firm’s human resources. This course on HR analytics addresses the topic of HR analytics with a practical focus, focusing especially on demystifying analytics for Human Resource managers, from both statistical and computing point of view.
After completing this course you will be able to:
- Use MS Excel to create and automate the calculation of HR metrics and devise HR analytics techniques in your workplace
- Make HR Dashboards as per HR analytics standards and understand all the charts that you can draw in Excel
- Implement predictive ML models such as simple and multiple linear regression to predict outcomes to real-world HR problems using HR analytics techniques
- Use HR analytics tools like pivot tables filtering and sorting options in Excel to summarize and derive information from the available HR data
- create appealing data summaries and dashboards to present the HR story in the most effective way
How this course will help you?
A Verifiable Certificate of Completion is presented to all students who undertake this HR Analytics: Strategies & Models in Excel course.
If you are a Human Resources manager, an executive, or a student who wants to learn and apply HR analytics techniques to real-world problems of the HR business function, this course will give you a solid base for that by teaching you the most popular HR analytics models and how to implement HR analytics in MS Excel.
Why should you choose this course?
We believe in teaching by example. This course is no exception. Every Section’s primary focus is to teach you the concepts through how-to examples. Each section has the following components:
- Theoretical concepts and use cases of different HR analytics models
- Step-by-step instructions on implementing HR analytics models in Excel
- Downloadable Excel files containing data and solutions used in each lecture on HR analytics and Human Resource Management
- Class notes and assignments to revise and practice the concepts in HR analytics and Human Resource Management
The practical classes where we create the model for each of these strategies is something that differentiates this course from any other course available online.
Download Practice files, take Quizzes, and complete Assignments
With each lecture, there are class notes attached for you to follow along. You can also take quizzes to check your understanding of concepts on HR analytics and human resource management. Each section contains a practice assignment for you to practically implement your learning on HR analytics and human resource management.
Who this course is for:
- Anyone curious to master HR Analytics from beginner to Advanced in short span of time
- Student who wants to have a career in the field of HR/ HR Analytics
- HR manager/ executive who wants to expand on their current set of skills
Course content
HR Analytics -Introduction
- Introduction
- Data Analytics
- Course resources
- What is HR analytics
- 4 steps of HR analytics
- HR metrics – Introduction
Essential Excel Knowledge
- Basic Formula Operations
- Mathematical Functions – part 1
- Difference between RANK, RANK.AVG and RANK.EQ
- Textual Functions
- Logical Functions
- Lookup Functions ( VLookup, HLookup, XLookup, Index-Match )
- Data Tools
Types of HR Metrics
- Staffing Metrics
- Training and Development Metrics
- Performance Metrics
- Other Metrics
HR Metrics – Case Study
- Data and Problem statement
- Solution
HR Charts and Dashboards – Introduction
- HR Charts – Introduction
Excel Charts
- Excel Charts – Categories of messages that can be conveyed
- Elements of charts
- The Easy way of creating charts
- Bar and column charts
- Formating charts
- Line Charts
- Area Charts
- Pie and Doughnut Charts
- Why we should avoid Pie charts
- Scatter plot or XY chart
- Frequency Distribution and Histograms
- Sparklines
- Quiz
Case Study 2 – HR Dashboard
- HR Dashboard – Introduction
- HR Dashboard – Age Distribution
- HR Dashboard – Hiring source
- HR Dashboard – Gender distribution
- HR Dashboard – Department distribution
Pivot Tables, Formatting data and tables
- Pivot Tables
- Pivot Charts
- Formatting data and tables
Case Study 3 – HR Dashboard
- HR Dashboard – Pivot chart
- HR Dashboard – Formatting
Case Study 4 – Using the right KPI’s
- Problem Statement
- Solution
- Analysis
Predictive Analytics – Introduction
- Linear Regression – Introduction
Basics of Statistics
- Types of Data
- Types of Statistics
- Measures of Centers
- Measures of Dispersion
