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 should attend this course?

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.

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

Johannesburg:

Dates:
3 February
8 May
4 August
3 November

 

Time:
08h00 – 16h00

 

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

 

Cape Town:

26 March
25 August

 

Time:
08h30 – 16h30

 

Venue:
To be confirmed
(central southern suburbs)

 

Port Elizabeth:

20 February
20 May
8 July
14 October

 

Time:
08h00 – 16h00

 

Venue:
To be confirmed

 

Durban:

13 February
13 May
3 June
14 October

 

Time:
08h00 – 16h00

 

Venue:
To be confirmed

1-day Public Course Rate

R 4 775.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 18 500.00

 

+ a daily fee for each additional delegate of

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