Excel Skills for Remuneration Practitioners

Learn more about analysing the market and organisation remuneration

Course Features

Course schedule: 
3 sessions
Date One: 
Thursday, 22 March, 2018
Date Two: 
Tuesday, 19 June, 2018
Date three: 
Tuesday, 18 September, 2018
South Africa; Johannesburg, Cape Town and Johannesburg
2 days
Presented by: 
Dianne Auld
Cost of Training: 
R 9,143.00 (Including VAT) per person

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.

For any workshop enquiries, please click here to contact us...