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
Consumers’ organisation, Which?, has introduced job families and simplified pay bands as part of its strategy to attract and retain new groups of employees and to provide better and more transparent career development opportunities for its existing 450-strong workforce. During the project, as many as 297 different salary bands were cut to 60, and four completely separate reward structures were replaced by one career and reward framework.
A new strategic business plan was introduced in 2010, supported by five “Must-win Ambitions”, including one with particular relevance for the Which? HR team: “Developing the organisation to deliver success”. As Which? stresses: “A key part of success is developing a career and reward framework that supports and reinforces our values and culture”.
In order to meet its business growth objectives, Which? needs to attract and retain talent, particularly as it moves into new business sectors and markets, for example, the provision of mortgage advice or its expansion into new locations. Which? says: “From a talent perspective, this move into new and different job markets presents new people challenges.”
What you will find in this report
This case study, written and researched by e-reward, examines: