Transforming Reward Data with Macros
Course Information

EXCEL FOR REWARD – MASTERCLASS #2

Transforming Reward Data with Macros

Part of our Spring 2021 Excel for Reward Masterclass series: click here for more details about the five afternoon sessions.

Date: Thursday 6th May 2021
Time: 1pm to 3pm (UK)
Duration: Two hours including five-minute break at approx. 2pm
Venue: Your PC

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 andinput boxes, conditional structures and loops.

In this course Dianne will demonstrate, using reward examples, how to:

Part 1 – Record and run macros:
  • Enable the Developer menu to work with macros
  • Record macros to automate repetitive tasks
  • Run macros using key strokes or by assigning them to a shape
  • Edit, re-name and delete macros
  • Debug macros
  • Set macro security settings
Part 2 – Write simple macro code:
  • Work with the Visual Basic Editor
  • Write simple macros from scratch
  • Declare variables and work with operators in macros
  • Use input and message boxes to get user input
  • Apply simple conditional structures in macros
  • Use a loop structure in a macro

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.

Who should attend?

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.

Dianne Auld, GRP, CCP, CSCP
Dianne Auld, GRP, CCP, CSCP
Senior Consultant

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.

EXCEL FOR REWARD – MASTERCLASS #2

Transforming Reward Data with Macros

Part of our Spring 2021 Excel for Reward Masterclass series: click here for more details about the five afternoon sessions.

Date: Thursday 6th May 2021
Time: 1pm to 3pm (UK)
Duration: Two hours including five-minute break at approx. 2pm
Venue: Your PC

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 andinput boxes, conditional structures and loops.

In this course Dianne will demonstrate, using reward examples, how to:

Part 1 – Record and run macros:
  • Enable the Developer menu to work with macros
  • Record macros to automate repetitive tasks
  • Run macros using key strokes or by assigning them to a shape
  • Edit, re-name and delete macros
  • Debug macros
  • Set macro security settings
Part 2 – Write simple macro code:
  • Work with the Visual Basic Editor
  • Write simple macros from scratch
  • Declare variables and work with operators in macros
  • Use input and message boxes to get user input
  • Apply simple conditional structures in macros
  • Use a loop structure in a macro

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.

Who should attend?

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.

Virtual classroom: Thursday afternoon 06/05/2021 - 06/05/2021