HR Analytics Using Excel For Beginners

Name: HR Analytics Using Excel For Beginners
Rating: 4.2 (384 reviews)

This course is a Beginners guide to HR Analytics Using Excel

Created bySegun Akiode

Last updated 8/2024

English

English [Auto],

What you'll learn

Acquire the fundamental knowledge of HR Analytics.
Gain both a conceptual understanding of the HR Analytics universe and process.
Learn how to collect, process and analyze HR data using Excel
Learn how to create various HR reports using Excel.
Learn about descriptive statistics in human resources.

Course content

7 sections • 46 lectures • 2h 35m total length

READ ME: Important Notes for New Students2:18
Introduction1:29
What is HR Analytics?4:29
Why HR Data Analysis?5:33
Generative AI & HR Data Analytics7:40
Discover how generative AI enhances HR data analytics by automating repetitive tasks, accelerating talent search, and integrating with Excel for data analysis and policy inquiries.
Analytics Maturity Stages4:50
Explore analytics maturity stages in HR analytics, moving from descriptive insights of the past to predictive and prescriptive guidance, using data-driven questions and multiple metrics.
Concept of HR Data4:40

HR Data Analysis and Excel2:27
Formatting HR Data in Excel2:11
Clean and format HR data in Excel by revealing headers, formatting date columns to day, month, and year, and improving readability for clearer analysis.
Grouping HR Data Using Excel Table5:04
Group HR data in Excel by converting to a table and using a pivot table. Derive counts, averages, and min/max values for employee age and length of service.
Excel TEXT Functions for HR Data Analysis - Part 15:26
Excel TEXT Functions for HR Data Analysis - Part 24:20
Learn to clean HR data in Excel using trim and clean functions, remove spaces and unprintable characters, and nest functions for efficient data cleaning.
Excel DATE & TIME Functions for HR Data Analysis - Part 16:21
Excel DATE & TIME Functions for HR Data Analysis - Part 28:12
Excel AGGREGATE Functions for HR Data Analysis - Part 16:16
Demonstrate using Excel's aggregate functions: sum, average, count, and conditional variants like countifs and sumifs, for HR data analysis, including creating a named table (hr_data) and counting headcount by department.
Excel AGGREGATE Functions for HR Data Analysis - Part 27:30
Excel AGGREGATE Functions for HR Data Analysis - Part 35:27
Master aggregate functions in Excel for HR analytics by applying sumif and sumifs to calculate total salaries by department and marital status.

Key Functions of HR Report1:52
Explore the key functions and types of HR reports, and learn steps to create data-driven documents that monitor workforce trends and support informed, data-backed decisions.
Common Types of HR Reports1:57
Explore common HR reports in Excel, including recruitment, turnover and retention, diversity and inclusion, training and development, and employee engagement, with metrics like cost per hour and ROI.
Tips on How to Create HR Report2:05
Why Excel for HR Reports?0:55
Explore how Excel simplifies HR data analysis and reporting by leveraging accurate, well-organized data from recruitment through exit, enabling meaningful HR reports.
Common Excel Charts for HR Reports1:23
HR Reports Using Excel Column Chart3:21
HR Reports Using Excel Bar Chart1:51
HR Reports Using Excel Pie and Doughnut Chart2:23
HR Reports Using Excel Line Chart2:13
Illustrate attrition rate from 2013 to 2018 with a line chart to show the turnover trend, and use the recommended charting option in Microsoft 365 to select a suitable visualization.
Transferring Excel Charts To PowerPoint0:49
Copy charts from Excel and paste them into PowerPoint slides or a Word document to build a presentation that fits into a report, with multiple visuals.

Statistics and Human Resources0:20
Measures of Central Tendency2:06
Measures of Dispersion1:16
The Excel Analysis Toolpak2:11
Activate the Excel analysis Toolpak to access tools for mean, median, mode, range, and standard deviation. Follow steps from File to Add-ins, then enable Toolpak to reveal the Data tab.
Descriptive Statistics Using The Excel Analysis Toolpak7:21
Master descriptive statistics in Excel using the Analysis Toolpak to summarize employee age data. Copy values, set input and output ranges, and interpret mean, median, mode, standard deviation, and range.

HR Reports and Excel PivotTable0:22
Explore how reports display metrics, statistics, and insights to support business decisions, and learn advanced Excel functionality with pivot tables to create a child report.
What is PivotTable in Excel?0:31
HR Reports Using PivotTable - Question0:53
Analyze data with pivot tables in Excel to create three visual reports: workforce age distribution, workforce gender distribution, and workforce length of service distribution.
HR Report: Workforce Age Distribution6:48
HR Report: Workforce Gender Distribution1:36
Learn to build an employee gender distribution chart in Excel by placing gender in rows, using a donut or pie chart, enabling legends, displaying percentages, and adjusting labels.
HR Report: Workforce Length of Service Distribution2:36
Learn to build a pivot table and bar chart for length of service distribution, grouping ranges, removing gender, and comparing gender and age distributions in Excel.

Bonus Lecture: HR Report on Workforce Generation Distribution5:41
Bonus Lecture: HR Report on Top Recruitment Sources3:12
Bonus Lecture: HR Report on Performance Scores Summary2:22
How To Create An HR Dashboard Using Excel1:14
Click on the resources section to access the Udemy course on "HR Analytics: How To Create An HR Dashboard Using Excel"
"HR Analytics: How To Create An HR Dashboard Using Excel"0:10
HR Analytics: How To Create An HR Dashboard Using Excel

Requirements

Basic knowledge of Human Resources
Basic knowledge of Microsoft Excel

Description

“Without data you’re just another person with an opinion.” ~ W. Edwards Deming

In layman’s terms Analytics can be defined as ‘the analysis of data to draw hidden insights to aid decision-making.’

As HR professionals, it is time to learn a skill that will transform the way you work. This course will get you trained on basic analytics techniques and help you uncover data-driven insights that will aid in HR decision-making and reporting.

HR analytics gives organizations the capacity to leverage data in order to address challenges faced not only by HR, but also by the core business. It provides organizations the ability to develop and implement a people strategy in line with its business strategy, thereby improving performance across a broad range of metrics.

HR analytics does not just deal with gathering data on employee efficiency. Instead, it aims to provide insight into each process by gathering data and then using it to make relevant decisions about how to improve these processes. The key aspect of HR analytics is to conclusively show the impact the HR department has on the organization as a whole. Establishing a cause-and-effect relationship between what HR does and business outcomes - and then creating strategies based on that information - is what HR analytics is all about.

This course is aimed to help participants receive both a conceptual understanding of the HR Analytics universe and process. It is specifically tailored for those people that have little or no experience in processing and analyzing data.

Who this course is for:

This course is specifically tailored for those people that have little or no experience in processing and analyzing HR data.

HR Analytics Using Excel For Beginners

What you'll learn

Explore related topics

Course content

HR Analytics For Decision Making7 lectures • 31min

HR Data Analysis Using Excel10 lectures • 53min

How To Create HR Reports Using Excel10 lectures • 19min

How To Calculate HR Metrics in Excel3 lectures • 14min

Statistics in Human Resources5 lectures • 13min

How To Make HR Reports Using Excel PivotTable and PivotCharts6 lectures • 13min

Bonus Lecture5 lectures • 13min

Requirements

Description

Who this course is for: