Study Method
Blended
Start Date
Oct 1 2020
Length of Course
TBA
Fees
1,095 per person
Location
TBA
Excel Skills for Reward Professionals: Advanced Level
DAY 1: ADVANCED EXCEL TECHNIQUES
Lookup Formulas #1
Vlookup, Hlookup, Iferror, Columns, Match formulas and Naming Ranges
Lookup Formulas #2
Indirect, Index, Offset, Choose formulas and Inserting Form Controls – scroll bar, spin button and combo box
If formulas
If, If (And), If (Or), Nested If, Countif, Countifs, Sumif, Sumifs, Averageif, Averageifs formulas
Macros
Recording, running and editing macros, macro security settings
DAY 2: ADVANCED EXCEL TECHNIQUES CONTINUED AND CREATING EXCEL DASHBOARDS
Data validation and protection
- Creating forms and input documents using data validation tools
- Hiding sheets, protecting worksheets and workbooks
Array formulas
- Single-cell and multi-cell array formulas
- Application of array formulas together with other Excel formulas
- All formulas and techniques will be demonstrated using remuneration applications
Introductory dashboard presentation
- What are dashboards?
- What they are used for?
- How do you create dashboards?
- Important principles, examples of dashboards
Creating an interactive market comparison dashboard
- With visual indicators, charts, tables and interactive fields allowing geographical drill downs and different market projection dates
- Learning to use the camera tool and complex conditional formatting
- Using Match, Offset, Array, Indirect, Averageifs, Iferror, Datedif and other formulas to create this interactive and powerful dashboard
Creating an interactive Pivot Table HR statistics dashboard
Using pivot tables, pivot table charts, slicers, and a heading linked to the report filter. These techniques will be used to create this visually powerful dashboard of reward statistics, allowing drill down by function, region and level.
Next class
“Reward Blueprints: 'This report on market data is something that I wished I could have had on my desk to read when I started my career in remuneration a number of years ago.'”
“Reward Blueprints: 'I have found e-reward to be an extremely useful and informative site. The research documentation has also been of the highest quality.'”
“Compensation Software Showcase 2014: ‘An excellent day which was well worth the trip from my perspective.’”
“Excel April 2015: 'Valuable course, fantastic knowledge of the trainer. Very helpful, small group, learnt lots of quick short cuts and extremely valuable time-saving techniques.' ”
“ Annual conference 2014: ‘Good quality of speakers. Excellent day' . . . ‘Excellent networking. Good content. Thank you so much for a great event’ . . . ‘Very informative and thou”
“GRP: 'I’ve just moved roles and am now working as a Reward Manager (Compensation) at [financial services company]. I think the professional credibility that the GRP designation of”