E-reward has commissioned international Excel for Reward guru Dianne Auld to design, develop and deliver a virtual training programme comprising two diplomas and seven short masterclasses focused and tailored so that we cover all of the essential Excel skills that are relevant to the needs of compensation & benefits professionals.
The diplomas, offer you the opportunity to enhance your learning as you progress from Level 1, a foundational diploma, to Level 2, the expert level.
Plus a series of seven Excel for Reward Masterclasses for those who want to immediately elevate their skills:
- Excel Power Query
- Grading Maps
- Using regression Analysis and Dynamic Arrays
- Transforming Reward Data with Macros
- Excel Dashboards
- Incentive Modelling
- Developing a Pay Range Zone Calculator

Capital One has a clear and well-developed approach to total reward. It’s about making connections between all the different elements of reward and capturing what is unique about working at Capital One. The company vision – 'Make Lives Better' – which is now evolving into the corporate mission – 'Changing Banking for Good' – guides everything the company does for both customers and associates.
Researched and written by E-reward.co.uk