Excel skills for remuneration practitioners

Enhance the essential Excel skills required to analyse market and organisation remuneration data

Course features

Course schedule: 3 sessions
Date one: Tuesday, 2 April 2019 (JHB)
Date two: Tuesday, 16 April 2019 (CT)
Date three: Tuesday, 17 September 2019 (JHB)
Venue: South Africa, Johannesburg and Cape Town
Presented by: Dianne Auld
Cost of training: R9,890.00 (Including VAT) per person
Man and woman talking to each other

Detailed descriptions

Target audience: Remuneration, HR or Payroll Specialists, Assistants or Managers, who would like to improve their Excel skills, and dramatically increase their productivity levels when working with remuneration data in Excel.

Course details: This is a hands on practical workshop covering the essential Excel skills required to analyse market and organisation remuneration information.
Aspects covered in detail during the course of the workshop are the following:

  1. Importing and formatting remuneration data / working with dates
  2. Valuing the Total Package (incl Vlookup & If formulas)
  3. Validation / checking of remuneration data
  4. Sub-totalling remuneration data
  5. Comparing market data and conditional formatting
  6. Statistics for remuneration data
  7. Graphing remuneration data
  8. Scattergrams and trend lines
  9. Distribution tables and graphs
  10. Pivot tables and goal seek

A workbook is provided with detailed (click by click) instructions on how to carry out every function demonstrated.  The workbook covers Excel 2007 and 2010.  A disc is also provided to each delegate with all training and exercise spreadsheets used during the workshop.

 

Contact us

Puseletso Matsheng

Senior Manager, PwC South Africa

Tel: +27 (0) 11 287 0436

Follow us