Download brochure: Click here
Download report: Click here
Live-streamed masterclasses. Attend from your home or any location. No travel required. Recordings of each masterclass available for 90 days after the virtual class.
Dianne Auld is an international guru who makes tricky reward-related Excel tasks transform into solutions in a blink of an eye. Dianne will show reward professionals a range of Excel time-saving skills. Her six masterclasses will dramatically increase your productivity and present spectacular ways to analyse mountains of reward data in seconds with professional looking charts, dashboards and Pivot Tables.
Per masterclass: GBP £195 + VAT per delegate. Attend all six masterclasses: GBP £995 + VAT per delegate.
To ensure an effective learning experience, there are just 20 seats available for each masterclass.
Cancellations: Please note that delegates will be held liable for the full fee if registration is not cancelled by 2 January 2023 or if the delegate is a 'no show'.
Anyone attending our six afternoon virtual masterclasses will dramatically increase their productivity levels when working with remuneration data in Excel. These Excel for Reward masterclasses include sleek visual and audio demonstrations of tasks reward professionals need to perform in their job function. Unlike other Excel courses, our classes have been specially developed to help you master skills specific to compensation and benefits work not taught in a general Excel course. These courses are UNIQUE.
Dianne will demonstrate to reward professionals how to save hours and hours – some even say days – by harnessing all the power of Excel.
‘I thought that the Excel masterclasses were insightful as always and the combination of watching Dianne in action, then going through the step-by-step instructions after with the video of the session to fall back on was a great way to teach what is a complicated process. You do need to spend some time on this after the session to properly understand it all, but it is already paying off as I’ve started applying it in my work!’
All attendees will be provided with some great give-aways:
Our hands-on practical masterclasses cover some essential Excel skills required to analyse and visualise market and organisation remuneration information. They have been created for reward, HR and payroll professionals who would like to enhance their Excel skills, and massively increase their productivity when transforming, compiling, analysing and presenting data. For those who already have a good working knowledge in Excel, these masterclasses will provide you with the expertise and skills to use Excel at a higher level.
Delegates are not required to follow along in these classes. They will have access to the video for 90 days afterwards and will receive detailed instructions to replicate all functions demonstrated.
But, to maximise the learning experience and appreciate the value add from the classes:
We would like students to leave the classes thinking: ‘Wow, I didn’t know this was possible, but after the demonstration and with the resources supplied, I feel confident enough to apply the learnings to my own work’.
‘I attended two masterclasses, Excel Power Query and Powerful Excel Dashboards. I really enjoyed both courses, but the Excel Power Query has been the most useful to me. I use Excel all the time in my role and the ability to format, build and refresh data files in Power Query has already saved time and reduced some of my workload. The ability to merge the different data files in to one has just been so useful. I only wish I had done the course years ago!
I enjoyed Dianne’s friendly presentation style. She is extremely knowledgeable and explained the techniques in a clear but comprehensive way. Having all the documentation to refer back to has also helped me so I was able to refer back to it when I wanted to try it for myself.’ – Anne Farquhar, Sanctuary Housing.
‘Dianne’s Excel reward training is fantastic. It gave me practical excel skills for use in reward as well as great theory on how to set up and update pay structures. So many benefits from attending! It’s all fantastic!' – Susan Maclean, Micro Focus.
‘Power Query was the most useful course for me. It helped me to complete our gender pay analysis much faster than with the previous manual method. The course was easy to follow, Dianne explained everything and talked us through step by step. She is really good at explaining complex formulas in a simple way.
The measures feature is a God send!!! I don’t know how I ever managed without it . . . Thanks to Dianne’s course I am more productive as I have more time to spend on the narrative and answering the why added value questions that companies so need to understand. Thanks Dianne.’ – Samantha Reid, former Chevron employee.
‘All of Dianne’s courses are so useful. Each one gave me something practical that I could see myself using in my role. Dianne showed us so many tricks and tools in Excel which have helped me to work more efficiently. She uses real reward examples so you can apply what you have learnt in your day job.
It’s saved me so much time – previously I was manipulating data to get the output I wanted. Dianne’s courses have really given me the tools and confidence to try new things within Excel.
In reward, we work with data constantly, so being able to optimise how I use Excel to really get the most out of it, and avoid the risks that come with manual data manipulation is really fantastic.’ – Susie Godfrey, Allen Overy
Watch Dianne demonstrate one of the smartest and most powerful tools ever developed for Excel. Power Query comes standard with Excel 2016 / 2019 / Office 365, and is available as an add-in to Excel 2010 / 2013.
Dianne will show you how it can automate routine data transformation (e.g. merging / splitting / removing columns, filtering data, replacing data, rounding, sorting, converting text to numbers and dates). She will demonstrate how you can achieve this without using macros and VBA, and with hardly any formulas.
Almost all the transformation is done through the simple use of a menu and a mouse.
Dianne will show you how to merge and transform multiple files in a folder, then how to add / transform another file from the folder simply by clicking Refresh. You can scrape data from web tables, transform the data for use in an Excel file, then update it with a single click.
Dianne will demonstrate:
Once your jobs have been evaluated, using either a job content or market pricing approach, your reward team and management need to audit and view the grades by grade and by function (or job family, discipline, business unit, division, area, company).
To conduct a meaningful audit, the jobs need to be in a matrix form rather than in a long list. This enables an equity / consistency check:
This matrix also presents the job grade data in a user-friendly and accessible format for viewing of grades and determining of career paths, as shown in the screenshot.
All too often, these grading matrices are high maintenance and error prone, as:
During this Excel masterclass, Dianne will demonstrate how to transform this time-consuming and error-prone process into a streamlined, accurate, low-maintenance approach. She will show you how to:
Attendees will be provided after the session with the Excel spreadsheets demonstrated and detailed instructions, so that they can replicate the functionality with their own grading data.
Reward and HR practitioners who work with grades and would like to know how to transform data from a list to a matrix.
Join International Excel Guru, Dianne Auld as she demonstrates 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’s not only captivating but it’s also invaluable to anyone involved with creating or maintaining pay structures.
Dianne will demonstrate:
Do you need to carry out the same repetitive sequence of steps on your employee data every week, month or quarter? If so, macros can transform your life by automating the series of steps to run with a single click, saving you hours and hours of time and tedium.
Many of us are often nervous of macros; some of us are even scared to use them. But, in this Excel masterclass, Dianne will demystify macros. She will show you how to record them, run them and edit them to get the macro to run on every worksheet.
She will also teach you how to write some simple macros from scratch using variables, operators, message and input boxes, conditional structures and loops.
In this course Dianne will demonstrate, using reward examples, how to:
Attendees will be provided after the session with the Excel spreadsheets demonstrated and detailed instructions, so that they can replicate the functionality with their own reward data. After this course delegates should feel confident enough to record, run, edit and write simple macros to automate repetitive rewards work.
Reward and HR practitioners who need to do regular, repetitive work on employee data and would like to know how to automate the work to run with a single click.
This three-hour lesson will demonstrate and teach you how to create beautiful HR or rewards dashboards that stand out from the herd, tell a powerful story and can be updated with only two clicks. (Not to mention, impress the boss!)
Dianne will show you the wonders of Power Pivot:
Thorough incentive modelling is critical for the success of any incentive plan. Incentive models that are not thoroughly tested may be unaffordable, pay out too much or too little, fail to differentiate adequately, or fail to motivate sufficiently. Excel provides wonderful tools and techniques for modelling incentives, but you need to know how to use them effectively.
In this session, Dianne will review the areas of incentives that can be modelled in Excel, such as:
She will outline guidelines for good incentive model design and will then draw up an incentive modelling tool for a company-wide incentive bonus plan. This modelling tool will allow the user to model different measure weightings, performance targets, payout levels, hurdles and eligibility, and to experiment with different incentive parameters to minimise incentive payout moderation to the incentive pool. Dianne will create interactive tables, charts and data tables to illustrate payout costs for different business areas and levels and payout distribution.
During this Excel for Reward masterclass, attendees will learn how to:
'Dianne was brilliant, very engaging. Just what was needed. The time went so quickly.'
'The Excel stuff you need to know as a comp professional. Very helpful and presented in an easily accessible manner.'
'Great course, full of tips and techniques.'
'Valuable course, fantastic knowledge of the trainer. Learnt lots of quick short cuts and extremely valuable time-saving techniques.'
'Dianne was worldly and informative.'
'Dianne was really engaging, positive and interesting.'
'Really interesting and useful course with a great instructor.'
'Dianne was very good, informative and engaging.'
'Very high level of knowledge.'
'Excellent instructor.'
'Very good with loads of useful examples. Dianne has an excellent skill in getting information across.'
'The practical examples and the way Dianne built up the content was very good.'
'Very good – I haven’t been on one of Dianne’s courses before but I will certainly do some more.'
‘A really excellent course, one of the best I have been on.’
‘The course was fantastic! Dianne is an expert in reward and a great teacher. She covered everything that I expected and more – it was comprehensive and I came away with a strong idea of how I can adapt and put the learning into practice.’
‘Excellent course that enables you to apply what has been learned immediately and Dianne is a fantastic trainer and clearly an expert in her field.’
‘It exceeded my expectations . . . the course was fantastic. I hope to be able to attend more of Dianne’s E-reward courses in future.’
‘Absolutely fabulous course. I learned so much. Dianne was so knowledgeable and shared so well. I've saved days and days now!'
'Very informative course, explaining the possibilities of Excel. My life will be so much easier now I understand the capability of Excel in terms of compensation and reward.'
'Dianne was great and extremely knowledgeable.'
'Excellent instructor, very clear, good pace, always ensuring everyone is up to speed and keeping up with the rest of the class.'
'Course content was well put together, very relevant to work and was made interesting by Dianne. I would highly recommend the course to anyone wanting to save time and understand Excel functions. Really pleased I attended.'
'The instructor was very friendly and informative, no improvements needed!'
Dianne is the founding member of Auld Compensation Consulting, operating out of Cape Town, South Africa. Her consulting work around the world covers all areas of total rewards, including reward strategy, base pay management, job evaluation, pay structuring, incentive design and sales compensation. She has developed and taught Excel and rewards courses in Africa, the Middle East, Asia, Europe, and the United States.
As a WorldatWork faculty member, Dianne teaches the GRP reward qualification courses in Southern Africa. She is the author of Dianne Auld’s Excel Tips, 3rd edition. Dianne has developed and recorded several e-learning products for WorldatWork, including Excel Skills, Advanced Excel Skills and Pay Structures. She is an honorary life member of the South African Reward Association (SARA) and an accredited Master Reward Specialist.
Live streamed from Dianne's office in Cape Town, via Zoom
1pm to 3pm / 4pm (UK)
Dianne suggests that you don’t try to follow along with her demo on your computer. She will proceed at a reasonably smart pace and you might get lost. Just watch and take notes if desired.
You will have access to a video of the masterclass for 90 days from the date of the masterclass so that you can replay at your leisure and practise the steps.
Attendees will be provided with detailed instructions for replication of the functions demonstrated by Dianne after the masterclass.
Watch Dianne demonstrate one of the smartest and most powerful tools ever developed for Excel. Power Query comes standard with Excel 2016 / 2019 / Office 365, and is available as an add-in to Excel 2010 / 2013.
Dianne will show you how it can automate routine data transformation (e.g. merging / splitting / removing columns, filtering data, replacing data, rounding, sorting, converting text to numbers and dates). She will demonstrate how you can achieve this without using macros and VBA, and with hardly any formulas.
Almost all the transformation is done through the simple use of a menu and a mouse.
Dianne will show you how to merge and transform multiple files in a folder, then how to add / transform another file from the folder simply by clicking Refresh. You can scrape data from web tables, transform the data for use in an Excel file, then update it with a single click.
Dianne will demonstrate:
Once your jobs have been evaluated, using either a job content or market pricing approach, your reward team and management need to audit and view the grades by grade and by function (or job family, discipline, business unit, division, area, company).
To conduct a meaningful audit, the jobs need to be in a matrix form rather than in a long list. This enables an equity / consistency check:
This matrix also presents the job grade data in a user-friendly and accessible format for viewing of grades and determining of career paths, as shown in the screenshot.
All too often, these grading matrices are high maintenance and error prone, as:
During this Excel masterclass, Dianne will demonstrate how to transform this time-consuming and error-prone process into a streamlined, accurate, low-maintenance approach. She will show you how to:
Attendees will be provided after the session with the Excel spreadsheets demonstrated and detailed instructions, so that they can replicate the functionality with their own grading data.
Reward and HR practitioners who work with grades and would like to know how to transform data from a list to a matrix.
Join International Excel Guru, Dianne Auld as she demonstrates 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’s not only captivating but it’s also invaluable to anyone involved with creating or maintaining pay structures.
Dianne will demonstrate:
Do you need to carry out the same repetitive sequence of steps on your employee data every week, month or quarter? If so, macros can transform your life by automating the series of steps to run with a single click, saving you hours and hours of time and tedium.
Many of us are often nervous of macros; some of us are even scared to use them. But, in this Excel masterclass, Dianne will demystify macros. She will show you how to record them, run them and edit them to get the macro to run on every worksheet.
She will also teach you how to write some simple macros from scratch using variables, operators, message and input boxes, conditional structures and loops.
In this course Dianne will demonstrate, using reward examples, how to:
Attendees will be provided after the session with the Excel spreadsheets demonstrated and detailed instructions, so that they can replicate the functionality with their own reward data. After this course delegates should feel confident enough to record, run, edit and write simple macros to automate repetitive rewards work.
Reward and HR practitioners who need to do regular, repetitive work on employee data and would like to know how to automate the work to run with a single click.
This three-hour lesson will demonstrate and teach you how to create beautiful HR or rewards dashboards that stand out from the herd, tell a powerful story and can be updated with only two clicks. (Not to mention, impress the boss!)
Dianne will show you the wonders of Power Pivot:
Thorough incentive modelling is critical for the success of any incentive plan. Incentive models that are not thoroughly tested may be unaffordable, pay out too much or too little, fail to differentiate adequately, or fail to motivate sufficiently. Excel provides wonderful tools and techniques for modelling incentives, but you need to know how to use them effectively.
In this session, Dianne will review the areas of incentives that can be modelled in Excel, such as:
She will outline guidelines for good incentive model design and will then draw up an incentive modelling tool for a company-wide incentive bonus plan. This modelling tool will allow the user to model different measure weightings, performance targets, payout levels, hurdles and eligibility, and to experiment with different incentive parameters to minimise incentive payout moderation to the incentive pool. Dianne will create interactive tables, charts and data tables to illustrate payout costs for different business areas and levels and payout distribution.
During this Excel for Reward masterclass, attendees will learn how to:
| Virtual classroom | 29/01/2024 - 25/03/2024 |
| Virtual classroom | 23/09/2024 - 04/12/2024 |
These terms and conditions apply between the person, firm, company or other entity specified on your booking form and E-reward.co.uk Ltd (company number: 4281768). Registered in England and Wales. Registered office 33 Denby Lane, Heaton Chapel, Stockport, Cheshire SK4 2RA, United Kingdom for delegate registrations for the course (including Mastering Reward courses, GRP courses with exam and in-house training courses) specified on your booking form (‘Course’).
By submitting your registration to attend the Course you agree to be bound by these terms to the exclusion of all other terms. If you do not agree to be bound by these terms E-reward.co.uk Ltd will be unable to accept your registration.
Delegates who advise E-reward.co.uk Ltd of their cancellation in writing via email (to paul@e-reward.co.uk) 30 calendar days before the start of the Course will have their fees refunded – less an administration charge of 20% of the Course fees.
No refund will be made for cancellations received less than 30 calendar days before the start of the Course.
Failure to attend the Course will be subject to the same terms.
Transfers may be made to any other Course in the UK organised by E-reward.co.uk Ltd subject to space availability. All transfer requests must be made in writing via email (to paul@e-reward.co.uk) 30 calendar days or more before the start of the Course.
There will be no fee charged for such transfers. One free transfer can be made for each course booking after which there will be a £100 administration charge for each further request.
Please note: We are unable to accept any transfer requests received less than 30 calendar days before the start of the course and no refunds will be made.
We are unable to accept any transfer requests once you have received access to GRP pre-recorded learning videos.
Substitutions with employees from your organisation are welcome at any time at no extra charge. You must email any substitutions (to paul@e-reward.co.uk) prior to the date of the Course.
Please note: We are unable to accept any ‘substitutions’ once you have received access to GRP pre-recorded learning videos.
You will pay E-reward.co.uk Ltd any fees specified in your booking form for the Course. Payment to E-reward.co.uk Ltd in GBP British Pounds is by BACS, wire transfer, cheque or credit card. It is a condition of booking that payment must be received by E-reward.co.uk Ltd before the start of the Course or no later than 30 days from the date of invoice, whichever is sooner.
If payment of your fees in full is not received before the Course, E-reward.co.uk Ltd may (at its sole discretion) either require such payment as a condition of your entry to the Course or refuse you entry to the Course.
Prices for each Course, where applicable, are correct at the time of publication. We reserve the right to change the prices at any time but changes will not affect registrations which have already been confirmed by E-reward.co.uk Ltd.
Each ticket covers attendance for one person only for the duration of the Course, and includes coffees, teas and light snacks during the lunch hour, as well as course materials.
All bookings are subject to value added tax (VAT) at 20%. You shall, on receipt of a VAT invoice from E-reward.co.uk Ltd, pay to E-reward.co.uk Ltd such additional amounts in respect of VAT as are chargeable on the supply of the Course.
We understand and will exercise our statutory right to interest and compensation for debt recovery costs under the late payment legislation if we are not paid according to agreed credit terms. Under the Late Payment of Commercial Debts [Interest] Act 1998 – as amended and supplemented by the Late Payment of Commercial Debts Regulations 2002 (to incorporate the features of European Directive 2000/35/EC) – we are entitled to charge:
Final Course details will be emailed to delegates at least three weeks before the Course.
You will receive your course materials by email ahead of the Course.
Delegates are responsible for their own accommodation.
The Course programme is correct at the time of going to press.
E-reward.co.uk Ltd reserves the right to change the format, tutors, venue location and programme or any other aspect of the Course at any time and for any reason, whether or not due to a Force Majeure event, in each case without liability/refund.
‘Force Majeure Course’ means any event arising that is beyond the reasonable control of E-reward.co.uk Ltd including (without limitation) speaker or participant cancellation or withdrawal, supplier or contractor failure, venue damage or cancellation, health scares, industrial dispute, governmental regulations or action, military action, fire, flood, disaster, civil riot, acts of terrorism or war.
E-reward.co.uk Ltd reserves the right to change the date or cancel a Course at any time and for any reason without notice. Where circumstances force E-reward.co.uk to cancel a Course, E-reward.co.uk Ltd shall offer you the option of attending any rearranged Course that E-reward.co.uk Ltd chooses to organise.
If you do not wish to accept this offer, then you will (as your sole remedy) be entitled, at your discretion, to receive either a credit note or a refund in respect of your fees received by E-reward.co.uk Ltd for that particular Course.
However, where the Course is postponed for reasons due to a Force Majeure event, any of your fees received by E-reward.co.uk Ltd shall be applied to any rearranged or rescheduled Course and all these Terms and Conditions shall apply to any such transferred booking.
To the fullest extent permitted by the applicable law, E-reward.co.uk Ltd shall not be liable to you for any loss, delay, damage or other liability incurred resulting from or arising in connection with the cancellation or date change of the Course howsoever arising or any venue change.
For the avoidance of doubt, you acknowledge and agree that should the Course date be changed or cancelled, E-reward.co.uk Ltd is not liable for any travel or accommodation costs you may have incurred.
E-reward.co.uk Limited is a registered data controller under number Z7317541.
Your Course registration information will be added to our marketing database but will not be given to third parties without your prior consent.
E-reward.co.uk Ltd uses email addresses for its own purposes of keeping customers informed about Courses and providing product, service and information announcements.
If you supply us with your postal address online, you may receive periodic mailings from E-reward.co.uk Ltd with information on new products and services and upcoming Courses.
If you do not wish to receive information about products and services, please let us know by email (to paul@e-reward.co.uk).
To the fullest extent permitted by the applicable law, E-reward.co.uk Ltd excludes:
If E-reward.co.uk Ltd is liable to you for any reason, its total liability to you in relation to the Courses (whether under these terms or conditions or otherwise) is limited to the amount of your fees received by E-reward.co.uk Ltd.
Views expressed by the Course instructors are their own. All advice provided at this course is for general guidance only. Any course delegates relying on information or advice given in the course of such training do so at their own risk.
E-reward.co.uk reserves the right to amend these terms and conditions from time to time. However, you will be subject to the terms and conditions in force at the time you submit your registration.
Further information
If you have any questions, please email us at paul@e-reward.co.uk