Remuneration and HR Training Courses

Advanced Excel for HR

21C Ed logo

1-day course

This course is ideal for reward practitioners who are involved in detailed data analysis. The purpose is to discover the power of excel in assisting in time-consuming ‘number-crunching’

Who is this course aimed at?

HR Practitioners with remuneration planning responsibilities and a basic knowledge of Excel.

Course content and outcomes

At the conclusion of this course the delegate should understand how to:

  • Interpret surveys – understand what statistics mean in remuneration analysis
  • Analyse market data – know what to look for – understand how to interpret data – know how to use technology to interpret survey results
  • Use Excel as an analysis tool – sorting, searching, filters, pivot charts and basic formulae – analysing data in Excel – lookups, ‘if’ functions, conditional formatting, arrays
  • Present data using Excel – charting (scatterplots, line graphs, bar charts) – advanced functions

Are there any prerequisites for attending this course?

It would be advisable for the delegate to have a basic knowledge of Excel.

Accreditation

This course is accredited by two highly prestigious bodies in the Remuneration and Reward field – SARA and IPM – and CPD points will be awarded for completing this course.

Cost of course:

R 6 300.00
(per delegate, excluding VAT)

Please scroll down for Booking Forms, In-house Rates, discounted Delegate Day Package Rates, Terms & Conditions, and Contact Details

Other training courses

21st Century offers courses in all areas of Remuneration and HR.

Course Date

15 May
10 July
16 October

The course content has been split into two modules – one in the morning and one in the afternoon:

Module 1 :
09h00 – 12h00
Module 2:
13h00 – 16h00

1-day Public Course Rate

R 6 300.00

(per delegate, excluding VAT)

In-house Rates

We need a minimum of 5 delegates in order to run this course in-house.

For between 5 and 10 delegates*,
a flat daily rate of

R 24 500.00

PLUS a daily fee for each additional delegate of

R 2 100.00

We can tailor-make this course, or customise any combination of courses to suit your organisation’s needs.

If you would like to run this course in-house at your company, please contact us and will will get back to you ASAP.

Delegate Day Packages

NB: Packages for use in 2024 (valid for a calendar year from date of purchase) can still be purchased at 2023 rates!

(Scroll down for 2023 and 2024 rates)

If any company employees would like to attend more than one public training course, or more than one person from your company would like to attend any of the courses, we highly recommend purchasing one of our discounted packages:

  • Structured according to the number of delegate days,
  • Packages are paid for up-front,
  • Discounts of up to 30%,
  • Valid for one year from date of purchase,
  • Specific to the company (rather than the delegate), so can be used by any number of employees, in any combination, for any course or courses.

If you would like to purchase a package, please fill out the BOOKING FORM.

Please click on pic below to see a larger version.

2023 Package Rates

Terms & Conditions

Please familiarise yourself with the TERMS & CONDITIONS before booking

Regional Contacts

Head Office

Sharlene Herandien
Training Manager,
Johannesburg & Gauteng

Western Cape, Northern Cape & Coastal Regions

Leanne Visser
General Manager,
Western Cape & Northern Cape

BOOKING FORM: Courses & Packages

If you would like to attend this course, please fill out the form below.

  • Section A: Company Information:

  • Please ensure that you fill in all the necessary requirements before submitting the form.

  • Section B: Delegate Information:

    If you ticked 'yes', our Training Manager will get in touch with you to discuss the details.
  • Section C: Invoicing Information:

  • This section contains the details of the financial contact person within your company who would receive the invoice.

  • Section E: Signoff

  • This section must be signed off by a person in your company who has the authority to purchase this course/package/s.