Human Resources Analytics with Microsoft Excel

What you'll learn

How to apply essential Excel formulas (IF, COUNTIF, VLOOKUP, XLOOKUP) to real-world HR tasks
Techniques for cleaning, validating, and managing employee data efficiently
Methods for calculating and analyzing key HR metrics like turnover, absenteeism, and retention rates
How to design interactive HR dashboards for tracking recruitment, engagement, and performance
The use of conditional formatting and drop-down filters to highlight trends and insights

Step-by-step creation of automated HR templates for attendance, payroll, and leave management
How to build an Employee Master Data Model for centralized HR analysis
Visual storytelling using charts and HR reports tailored for stakeholders and decision-makers
Recruitment and diversity analytics to monitor gender balance and hiring equity

Description

Course Content

Reviews

Step into the future of Human Resource Management with Discourse HR Analytics with Microsoft Excel — a practical, hands-on course designed to help you become a data-savvy HR professional. Whether you're an HR manager, business owner, team lead, or analyst, this course gives you the tools to make smarter, data-driven decisions.

Course Highlights:
Excel Essentials for HR: Master core formulas like IF, COUNTIF, MAX, MIN, and logical operators to simplify tasks like calculating leave, tracking employee data, and measuring key performance indicators. 📈📅

HR Metrics Made Easy: Learn how to compute and interpret vital workforce metrics including turnover rate, retention, absenteeism, time-to-hire, and training ROI. 🧮💼

Data-Driven Recruitment: Build dashboards that track diversity, hiring timelines, and offer acceptance rates. Design engaging HR reports using Canva for professional presentation. 📋📊

Automated HR Templates: Save time with ready-to-use Excel templates like employee databases, leave trackers, recruitment sheets, and payment registers. Automate routine HR workflows with ease. ⚙️📂

Visualization & Dashboarding: Bring your data to life with conditional formatting, dropdown filters, and interactive dashboards that showcase workforce insights clearly and effectively. 📊✨

Who Should Take This Course?
HR Managers & Executives looking to modernize their workflow

Business Owners seeking data-backed people strategies

Excel Users transitioning into the HR space

Aspiring Data Analysts in HR

Anyone ready to embrace HR technology and analytics

This is more than just an Excel course — it’s your roadmap to becoming a strategic, data-driven HR leader. Let’s turn spreadsheets into solutions. 💼📊

KEY QUESTIONS:

What are the course requirements?

Access to a laptop or computer.

Will certificate be issued?

Yes, a certificate of completion will be issued at the end of the course.

Expand all

Introduction to HR Analytics in Excel

12 lectures

1.1 Introduction

19 minutes

1.2 Formatting

18 minutes

1.3 HR Formulas - SUM

11 minutes

1.4 HR Formulas - DATE

11 minutes

1.5 HR Formulas - COUNTIF

9 minutes

1.6 HR Formulas - MAX & MIN

5 minutes

1.7 HR Formulas - LOGICAL Functions

10 minutes

1.8 Data Validation

6 minutes

1.9 VLOOKUP

15 minutes

1.10 XLOOKUP

5 minutes

1.11 FILTERS

14 minutes

1.12 Searchable Drop Down

9 minutes

HR Workforce Analytics

3 lectures

2.13 Data Visualization

11 minutes

2.14 HR Analytics I

21 minutes

2.15 HR Analytics II

32 minutes

HR Routine Reports

3 lectures

3.16 Intro to HR Routine Reports

7 minutes

3.17 Kinds of HR Report

7 minutes

3.18 HR Reports with Canva

7 minutes

HR Metrics Analytics

12 lectures

4.19 Employees Turn Over Rate

6 minutes

4.20 Retention Rate

6 minutes

4.21 Absenteeism Rate

4 minutes

4.22 Time to Hire

4 minutes

4.23 Cost Per Hire

3 minutes

4.24 Employee Engagement Rate

4 minutes

4.25 Engagement Survey

17 minutes

4.26 Training ROI

5 minutes

4.27 Acceptance Rate

5 minutes

4.28 Employee Satisfaction Rate

5 minutes

4.29 Gender Pay Gap

6 minutes

4.30 Recruiting - Selection

13 minutes

Automated HR Templates & Dashboards

10 lectures

5.1 Automated Time Clock Register

9 minutes

5.2 Employee Database Template

11 minutes

5.3 Employee Scheduling Template

12 minutes

5.4 Training Matrix

7 minutes

5.5 Yearly Leave Tracker

9 minutes

5.6 Human Resources Matrix Template

11 minutes

5.7 Employee Time Sheet & Payment

12 minutes

5.8 Employee Appraisal Template

14 minutes

5.9 Payroll Management Template

13 minutes

5.10 Recruitment Management Template

15 minutes

Mary Okafor

Rating |

It was very insightful, educative and I learnt a whole lot with regards to excel. It was an eye opener to some functions I never know in excel. The tutor is also very detailed as well. It's an amazing course.

Udoma Ediomoabasi Isidore

Rating |

The lecture videos is very explainable in a layman's terms though more information should be added to help a novice around Microsoft excel like the creation of digital clock and various HR dashboards

DAISY

Rating |

Perfect tutorials, well explained and easy to follow procedures to be implemented in day to day workings of the HR department

Gideon Olusegun Remigius-Iwu

Rating |

Very detailed and expertly delivered by the course tutor. This is indeed greater value for far less cost. Thank you.

Amos Usoro Emmanuel

Rating |

Fantastic lecture. Easy to learn but there is no example template to practice with.

Sunny Ochekwu

Rating |

the course is well explained and keen attention is paid to details. kudos

Nsikak Ekanem

Rating |

Amazing stuff the raining seemless the information mind blowing

Mavis

Rating |

been insightful so far and will definitely apply it in my work

Abdulyekeen Lawal

Rating |

This has been very impactful. Looking forward for more courses

Blessing Gbarada

Rating |

I love how each subject is clearly explained and simplified

Are the videos downloadable ?

The videos are efficiently compressed for quick downloads at any time.

How do I access the course videos and materials?

Once your payment is complete, you will have full access to the course lessons and materials. You can download and watch them at your convenience, and our team will provide full support and assistance throughout your learning journey.

How can I obtain my certificate after completing the course?

Once you have completed the course, you can easily download your certificate directly from your dashboard.

Mary Okafor

Rating |

Udoma Ediomoabasi Isidore

Rating |

The lecture videos is very explainable in a layman's terms though more information should be added to help a novice around Microsoft excel like the creation of digital clock and various HR dashboards