RewardED course accreditations

Advanced Excel for HR

1 day course

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

At the end of this course the delegate will be able 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

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’

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

booking form

Take a look at all our RewardED Training Courses

COMING UP

Johannesburg

4 April
08h00 – 16h00

21st Century Offices
12 Bolton Road (cnr. Sussex)
Saxonwold, 2132

Cape Town

4 June
08h30 – 16h30

Venue to be confirmed
(central southern suburbs)

Johannesburg

11 June
08h00 – 16h00

21st Century Offices
12 Bolton Road (cnr. Sussex)
Saxonwold, 2132

More 2019 dates

Johannesburg:

10 September
7 November

 

Cape Town:

17 September

 

Port Elizabeth:

16 August

 

Durban:

16 August

 

Namibia

13 August

 

booking form

Single Course Rate

R4 775ex VAT

The price includes tuition, instruction, materials, a workbook and a certificate of attendance. Tea and lunch will be served and are included in the price.

SEE OUR DISCOUNTED PACKAGE RATES!

Take a look at our other RewardED Training Courses