Skip to main content

Microsoft Excel For Human Resources Analytics



HR Data Analytics is a growing field in an increasingly data-driven world. Excel has tools to organize HR data and HR professionals need to know how to add these skills to their toolset to drive insight into HR metrics and deliver results to the business. This course covers the Excel tools and skills an HR professional will need to analyze HR data into meaningful presentations.

Over the two days, delegates will learn about the functions in Excel that assist in the cleaning up of text and time/date data generated in the activities of administering human resources, as well as functions that facilitate relevant and accurate analysis of the data, leading to a presentation of worthwhile and applicable information.

This course will also include the demonstration and application of appropriate shortcut keys, workbook and worksheet design specifically for large amounts of text data as experienced in the administrating of human resources, as well as the generation of dashboard elements such as charts and pivot tables.


Delivery Methods

Leading Training is focusing on providing virtual training courses for the foreseeable future and will only consider in-person and classroom training on request, with a required minimum group size of six delegates. We remain committed to offering training that is fast, focused and effective.

Delivery Method Duration Price (excl. VAT)
Live Virtual Training 2 days ZAR 4,500.00 Get a Quote

Discounts Available


Download Brochure

Information may change without notice.


This course is for professionals working in Human Resources for organizations who need to represent, analyze or organize HR data visually using Excel.


Excel Advanced knowledge is required and having completed the Excel for Data Analytics course with Leading Training would be beneficial.

Course Outline / Curriculum

Day One

Including External Data

1. Inserting Sheets

2. Referencing external Sheets

3. Linking to published sources


Clean Up

1. Information Functions

2. Statistical Functions

3. Data Tools


Organised Structure

1. Text Functions

2. Date and Time Functions


3. Named Ranges



Day Two

Creating Information

1. Look & Reference Functions

2. Logical Functions

3. Tables


At a glance

1. Conditional Formatting

2. Sparklines

3. Slicers


Dashboard Elements

1. Charts

2. Pivot Tables

3. Pivot Charts

Schedule Dates and Booking

There are currently no scheduled dates.

Please note that this course needs a minimum of 6 delegates to schedule a course. You can choose to be added to the waiting list by clicking the button below, and we will contact you when we have enough delegates interested. Should we not get enough delegates, we will refund or credit your paid booking.

Add me to the waiting list

Should you need this course urgently, the following options are available:

  1. Pay for 6 delegates (whether you have them or not) and we will schedule the course as soon as possible.
  2. If you have fewer delegates and cannot pay for 6, we can negotiate a shortened course where some of the time will be spent in blended learning - watching videos and doing tutorials and exercises with some contact time with the trainer. We would want to discuss what your core needs are so that we cover those aspects. You need to have paid for 3 delegates at least.
Submit Enquiry