Watch Dianne Auld demonstrate how to create pay structures and pay scale charts using exponential regression, pay scale formulas, scatter charts, combo charts and dynamic arrays. This is a highly practical watch – it is not only captivating but it is also invaluable to anyone involved with creating or maintaining pay structures.

Dianne will demonstrate:

• A quick overview of linear and exponential regression – when to use each one, the formulas used and interpretation if R squared.
• How to create scatter charts and how to use exponential regression to create a pay midpoint line taking into account internal employee and market pay data.
• How to calculate the pay ranges for this pay line and plot the pay ranges as lines on the scatter chart.
• Using the same data to create a scatter chart but with traditional rectangular pay ranges and alpha or alpha numeric grades on the X axis – this is a complex chart to create as it involves a combination of a scatter chart, lines and stacked columns. It has to be created in a very specific way.
• Once learnt, you will use this chart in your pay structuring work and wonder how you ever coped without it. Past students have loved the visual representation clearly showing how good a fit the pay ranges are relative to the employee pay scatter.
• Calculating a median market data per grade, using a traditional array formula or using Microsoft 365 dynamic arrays (available to Microsoft 365 users), and adding this to the chart.
• Using dynamic arrays SORT, UNIQUE and FILTER formulas, the spilled range operator and data validation to create the same chart allowing drill down per department.
• How to create a dashboard of department scatter charts all linked to one source data sheet.

Don’t miss this informative session. Dianne will also share example files for you to practice on (after the course has taken place). This Masterclass has limited space available.

This Masterclass has limited space available, registration fees are as follows: 

SARA Professionalised Members: R900
SARA Paid-up members: R1 000
Non-SARA Members: R2 400
 

Terms and Conditions

• To get member discount you must use the email address associated with your regular SARA account.
• If you use a new email address a new account will be opened for you, unless you ask the secretariat to update your old account details. 
• Member discount is only offered to paid-up members. 
• You and the billing contact of your organisation will receive invoices a few minutes after you have registered.
• If you see a red notice on the screen about unpaid invoices please contact the secretariat on saraservices@vdw.co.za to resolve.
• Cancellation: Please contact eileen@vdw.co.za if you are unable to attend
   

If you don’t have a Valid Purchase Order Number please use your phone number