PLEASE NOTE: In this time of Covid-19 we will be offering this course either face-to-face or online via Zoom

Advanced Excel for HR

1-day course

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

Who is this course
aimed at?

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

Are there any prerequisites for attending this course?

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

Is this course accredited?

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.

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

2021 course dates

Tuesday, 2 February

Monday, 3 May

Tuesday, 3 August

Tuesday, 2 November

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

In order to participate in the course, please fill in the forms below and we will get back to you with further details.

What other courses does 21st Century offer?

21st Century ED offers one and two-day courses that cover all areas of Remuneration and HR.

 

 

more courses

1-day Public Course Rate

R 5 250.00
(per delegate, excluding VAT)

Public Course Package Rates

If you – or 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 packages.

  • Structured according to the number of delegate days
  • Discounts of up to 30%
  • Valid for a year
  • Specific to the company (not to the delegate) so can be used:
    • by any number of employees
    • in any combination
    • for any course/s

If you would like to purchase a package, please fill out the booking form

In-house Rates

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

R 19 950.00

+ a daily fee for each
additional delegate
of

R 1 750.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.

* Please note that we need a minimum of 5 delegates in order to run this course.

Contact us

Please familiarise yourself with the TERMS & CONDITIONS before booking

Terms & Conditions

Regional Contact Details

Head Office:

Sharlene Herandien
Training Manager, Johannesburg & Gauteng

Johannesburg

Eastern Cape & KwaZulu Natal:

Penny Petrou
General Manager, Eastern Cape & KZN

Eastern Cape & KZN

Western Cape & Northern Cape

Leanne Visser
Regional Manager, Western & Northern Cape region

Western & Northern Cape

BOOKING FORM: Courses & Packages

  • Section A: Company Information:

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

  • Section B: Delegate Information:

  • Section C: Purchasing Options:

  • Choose how you would like to pay. Fill in all the fields that are applicable, choosing AT LEAST ONE purchasing option.

  • Section D: 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.