Advanced Excel for HR

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.

In-house Training Rates

All our courses can be run In-house and can be customised to suit your organisation’s needs.

• 1-10 delegates: a flat daily rate of R26 775.00
• PLUS a daily fee for each additional delegate of R3 000.00

2026 Public Training Courses,
Rates and Booking

We run a select few of our most popular in-house courses as Public Courses during the year.

Please click on the table below for a larger view of the 2026 Public Course Dates.

• 1-day courses:
  R6900.00 ex. VAT per delegate;
• 2-day courses:
  R13 800.00 ex. VAT per delegate
• 3-day courses:
  R20 700.00 ex. VAT per delegate;
• 4-day courses:
  R27 600.00 ex. VAT per delegate
• 5-day courses:
  R34 500.00 ex. VAT per delegate

Please note that all public training courses require upfront payment by your organisation. If any delegate cannot attend, they may transfer their place on the course to any other person from the organisation. Terms & Conditions will be sent to you on booking.

If you are interested in any of our courses, or if you have any queries, please fill in the contact form or speak to one of our regional contacts for more information.

Contact Form