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
Following the transformation of PagesJaunes from a print-based company to a mainly digital and online-based advertising business, in 2014 the organisation introduced a new compensation scheme to incentivise its sales representatives to sell its full portfolio of products and services. The scheme has four main objectives – revenue, number of customers, quality and a product specific target – and reps can earn up to 60% of their fixed income in additional compensation if they achieve their personal targets. According to Mathieu Nuée, Head of Compensation Solution, the key to the scheme is its transparency – sales people can see full details of all their orders within the system, explore how their compensation payments are calculated and even forecast their potential payments for the rest of the year using a sophisticated simulation module within the compensation software.
Researched and written by E-reward.co.uk