Advanced Excel Skills & Dashboards for Compensation Professionals
An advanced-level live streaming online course helping you utilize advanced Excel formulas for your rewards work, understand the principles behind creating dashboards and create interactive formula-driven and pivot chart dashboards
Sign Up for Our Advanced Excel Skills & Dashboards for Compensation Professionals Training
An advanced-level course helping you utilize advanced Excel formulas for your rewards work
Why Attend?
Compensation professionals who already have intermediate Excel skills, and would like to enhance their skills to improve their productivity in Excel and learn how to create interactive Excel models and dashboards for their rewards work. Delegates should use Excel for their day-to-day rewards work, be able to write a VLOOKUP formula and be familiar with pivots and charts.
Benefits Of Attending
- How to use Form Controls to set up scroll bars, spin buttons and combo boxes to make your data models and dashboards interactive with a professional touch
- How to use the OFFSET, INDEX and CHOOSE formulas to count, sum and average rewards data for different periods based on user choice
- How to use named ranges and the INDIRECT formula together with the VLOOKUP formula to increase productivity and reduce errors when working with rewards data
- How to set up data validation for forms, models or dashboards
Run this course in-house
For over 29 years, Informa Connect Academy’s customised training solutions have helped organisations deliver tailored learning in different languages to suit every requirement.
Bespoke training designed for your organisation only, combining traditional classroom setting, blended and online learning models
Is this course for you?
Who Should Attend
Compensation professionals who already have intermediate Excel skills, and would like to enhance their skills to improve their productivity in Excel and learn how to create interactive Excel models and dashboards for their rewards work. Delegates should use Excel for their day-to-day rewards work, be able to write a VLOOKUP formula and be familiar with pivots and charts.
Course Information
The course will commence at 9:30 on Day One and end at 16:30 GST (GMT+4). There will be short refreshment breaks and an hour long break at 12:45
LEARN MORE ABOUT THIS TRAINING COURSE
Delivered by Dianne
Dianne is without doubt the most highly regarded and popular Excel for Reward expert in the world. Well respected and distinguished in the compensation field and Excel, her skills and expertise are in high demand.
Run this course in-house
For over 29 years, Informa Connect Academy’s customised training solutions have helped organisations deliver tailored learning in different languages to suit every requirement