GR2 Made Easy with Excel

Enter Title


26 September 2013
Bytes Conference Centre

Who should attend this course:

GRP Graduates
Current GRP candidates who have completed GR2
(This course is limited to 20 delegates)

Date: Thursday, 26 September 2013
Venue: Bytes Conference Centre
241 3rd Road
Cost: R2360 per delegate
Cancellation Fee: Please note that if registration is not cancelled 48 hours before the function or if delegate is a 'No Show' at the function, the delegate will be responsible for the full cost.
Dietary Requirements: Please advise of any dietary requirements: Halaal, kosher, vegetarian
RSVP: Please RSVP by Tuesday, 17 September 2013


09h00 - 10h00 Section A: Levels of Measurement, Percents, Pay Scale Calculations and Pay Scale Graphs
Levels of measurement in Excel
Converting text to numbers
Calculating percentages
Calculating compa ratios and market indices
Calculating pay scale formulas
Graphing pay scales using a stacked column graph

Exercise A
10h00 - 10h30 Section B: Time Value of Money
Using formulas to calculate:
Present value
Future value
Interest rate
Number of payment periods
Repayment per period

Exercise B
10h30 - 11h00 TEA / COFFEE
11h00 - 12h00 Section C: Measures of Central Tendency and Location
Using formulas to calculate:
Mean; Median; Mode
Lower Quartile; Upper Quartile
10th Percentile; 90th Percentile
Minimum; Maximum
Company weighted vs Incumbent weighted Average
Survey weighted Average

Using Data Analysis Descriptive Statistics

Exercise C
12h00 - 13h00 Section D: Measures of Variability
Using formulas to calculate:
Interquartile range
Standard deviation - population and sample
2 and 3 sigma boundaries

Exercise D
13h00 - 14h00 LUNCH
14h00 - 15h00 Section E: Organizing, Grouping and Displaying Data Shapes of Distributions
Sorting data
Grouping data into suitable intervals
Creating a distribution table and graph using the Data Analysis, Histogram function
Converting the column distribution graph to a smoothed line distribution graph
Measuring the skewness and kurtosis of the data
Examining and measuring the shapes of different distributions

Exercise E
15h00 - 15h15 TEA / COFFEE
15h15 – 16h15 Section F: Regression Analysis
Carrying out linear regression using:
A scattergram and linear trend line
Add in Regression Analysis function
Carrying out exponential regression using:
A scattergram and exponential trend line
Carrying out multi-linear regression using:
Add in Regression Analysis function
Adding pay scales and market data to the scattergram

Exercise F
16h15 CLOSE

More about the facilitator:

Dianne Auld
•    Dianne was born and educated in Zimbabwe, where she obtained a B Sc Psychology Hons degree. She then spent a year in Malawi, where she taught English and Mathematics at a secondary school, before moving to South Africa.  

•    Dianne has held a number of reward positions in South Africa at Richards Bay Minerals, Unilever and Old Mutual, and currently runs her own consulting practice – Auld Compensation Consulting.  She consults on all areas of reward to a wide range of corporate clients, and runs a number of remuneration training courses in conjunction with PwC Remchannel. Dianne also works part time for Pick n Pay, where she advises on group remuneration policy and practices.

•    In 2007 Dianne, in partnership with Remchannel, designed REMeasure, an internet based job evaluation system.  The system was launched in 2008, and has a growing South African and African client base.

•    Dianne is a faculty member with Worldatwork and a reviewer for the Worldatwork journal.  She completed her Global Remuneration Professional (GRP) certification in 2006 and her Certified Compensation Professional (CCP) qualification in 2010.  She is on the committee of the Western Cape branch of SARA.  Dianne presented a session at the Worldatwork conference in Orlando in 2012 on Transforming Data into Critical Insights using Excel Dashboards.

•    Dianne has published many articles on remuneration in HR journals, a chapter on remuneration in “Managing Industrial Relations in South Africa”, and a series of fact sheets on remuneration for IPM.   The Compensation and Benefits Formula handbook including Dianne’s Excel Tips was published by Worldatwork in March 2012, and is the fastest selling book Worldatwork have ever published.  It sold out at the 2012 Orlando conference.

•    Dianne was made an honorary life member of SARA in 2010.

Registration for this event is now closed


Follow us

Text/HTML rent a car göcek yat kiralama izmir escort sex shop sex shop redtube porn xnxx Porn Xnxx videos Free Porn videos
ankara escort alanya bayan escort bitcoin cloud mining izmit escort XXX Porn tube Free Online Porn oto kiralama ankara