Business, HR and Remuneration Courses

Advanced Excel for HR

21C Ed logo
Advanced Excel for HR Training Course

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’

Public Course Dates

22 September

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 900.00
(per delegate, excluding VAT)

Course Rates & Information

If your company is planning to send multiple people on a public course, or is sending one person on multiple public courses, it is worth looking at purchasing one of our discounted Public Course Packages.

1-day course: R6 900.00
2-day course: R13 800.00
3-day course: R20 700.00

NB: All course rates exclude VAT.

We offer package rates for companies that are sending multiple people on a public course, or that are sending one person on multiple public courses:

  • Structured according to the total number of course days required;
  • Savings 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.
  • We require an upfront payment.

Please note that all package rates exclude VAT.

  • 3-day package: R20 700 (save R3 400)
  • 4-day package: R27 600 (save R4 850)
  • 5-day package: R34 500 (save R6 500)
  • 6-day package: R41 400 (save R8 650)
  • 7-day package: R48 300 (save R10 950)
  • 8-day package: R55 200 (save R13 450)
  • 9-day package: R62 100 (save R17 150)
  • 10-day package: R69 000 (save R21 100)

Package savings are based on the 1-day rate of R6 900.00

If you’d like to buy a Public Course Package, please click on the link below to fill in the form.

We charge a flat daily rate of R26 775.00 for up to 10 people, PLUS a daily fee of R3 000.00 for each additional delegate.

Many of our courses are accredited by highly prestigious bodies in the Remuneration and Reward field. CPD points will be awarded for all completed accredited courses.

Please see individual course pages for accreditation information.

  • Once your booking has been confirmed in writing and you have been invoiced, an upfront payment is required.
  • Once invoiced, there will be no refunds. However, you may transfer your course or package to anyone in your company to use.
  • 21st Century reserves the right to invoice customers for goods and services ordered, which were procured upon written request (completed form), either via a non-cancellable, irrevocable order, an official purchase order, or an email instruction received.
  • 21st Century reserves the right not to accept any order.
  • If you cancel or reschedule at any time before the date of training, payment will be retained and you will receive a training credit, which can be used within a calendar year. You may, however, send a substitute in your place at no extra cost. Please inform us – IN WRITING – of the new name for registration purposes at least one working day before the event.
  • In the event of unforeseen circumstances, 21st Century reserves the right to change the programme content, the speakers, the venue or the date.
  • If the event is canceled, delegates will be notified in writing. The delegate can then choose to attend on the next available date of the scheduled event.
  • Please note that prices may be subject to annual changes, based on inflation, without prior notification.

Contact

If you have any queries, please contact our Head of Training on +27 11 447 0306 or at [email protected]

Regional Contacts

Chimoné Zaayman
Head of Training

Thandeka Dube
Training Coordinator

 

Leanne Visser
General Manager,
Western Cape & Northern Cape