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
Newly-merged global manufacturer, CNH Industrial, introduced a cloud-based compensation solution to help its HR business partners around the world manage short-term incentive payments in spring 2015 and is now looking to use the tool in broader reward planning, including the company’s annual pay review cycle. Over the course of 12 months, CNH Industrial has moved from a reliance on Excel spreadsheets to manage a crucial element of its compensation, bonuses, to a position where its HR people around the world can manage new bonus arrangements in real-time using a tailor-made technology solution provided by a third party, beqom.
A case study researched and written by E-reward.co.uk
Download PDF