Study Method
Blended
Start Date
Sep 28 2020
Length of Course
TBA
Fees
1,095 per person
Location
TBA
Excel Skills for Reward Professionals: Intermediate Level
Aspects covered in detail during this two-day course include the following:
- Customising the Quick Access Toolbar/Importing and formatting remuneration data – including combining data from different columns, dividing data into different columns, changing case and text formulas
- Rounding numbers/Custom formatting/Working with dates
- Valuing the total reward package – including Vlookup, Hlookup and If formulas
- Validation/checking of remuneration data (including the Data Filter, Custom Filter and removing duplicates)
- Sub-totalling remuneration data
- Comparing/Projecting remuneration data/Applying conditional formatting to market comparisons
- Statistics for remuneration data
- Graphing remuneration data
- Scattergrams, trend lines and regression analysis
- Pivot Tables and Goal Seek.
With this class you will:
- Learn skills specific to compensation work not taught in any standard Excel course.
- Save hours of work when you import, merge and format large amounts of data for analysis.
- Learn how to analyse mountains of data in seconds with professional-looking charts and Pivot Tables.
- Face your fear of regression analysis and easily create a pay policy line and salary predictions.
- Perform complex calculations in minutes using the SUBTOTAL function.
- Harness the power of VLOOKUP, HLOOKUP, IF, AND, OR and IFERROR functions.
Learning objectives
- Customise the quick-access toolbar
- Create charts, graphs and tables from various types of data
- Use formulas to simplify complex calculations
- Check data for duplications and errors
- Calculate subtotals
- Calculate a variety of statistics
- Calculate linear and exponential regression.
Next class
“Compensation Software Showcase 2014: ‘Thank you very much for the opportunity to join the event – to see some of the products on offer in the market for prospective buyers.’ ”
“Compensation Software Showcase 2014: ‘Great insights provided in relation to the overall selection of a provider, including the views of the providers themselves.’”
“Compensation Software Showcase 2014: ‘Enjoyed the opportunity to meet the vendors and gain up-to-date insights from them.’”
“ Annual conference 2015: ‘An excellent range of topical topics and good/expert presenters. Very good value for the price!’”
“ Annual conference 2015: ‘A very relevant day’ . . . ‘An excellent conference’ . . . ‘A really good, interesting day.’”
“Annual conference 2015: 'We made some great networking connections at the E-reward conference and have already followed up on a few to get a stronger connection and see if we can ”