Transforming Reward Data with Macros

Transforming Reward Data with Macros

EXCEL FOR REWARD – MASTERCLASS #2

Transforming Reward Data with Macros

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

Date: Thursday 27 January 2022
Time: 1pm to 3.30pm (UK)
Duration: 2.5 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 and input 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.