

Advanced Excel Skills & Dashboards for Compensation Professionals (Online Training)
14 April - 15 April 2021
Online Training
Level: Advanced
Brochure Download In-Company Training REGISTER FOR THE COURSE DOWNLOAD BROCHURECourse Director

Dianne Auld
- 14 Apr 2021 Online
- 27 Oct 2021 Online
Overview
Timings: 10:30 to 16:00 GST
Duration: The online training will be in sessions of 90 minutes each with two 30-minute breaks
An advanced-level live streaming online course helping you utilise advanced Excel formulas for your rewards work, understand the principles behind creating dashboards and create interactive formula-driven and pivot chart dashboards.
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.
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
- Understanding the logic of the IF formula
- How to use IF formulas, IF (AND) and IF (OR) formulas, Nested IF formulas, COUNTIF, SUMIF, AVERAGIF, COUNTIFS, SUMIFS and VERAGIFS formulas for rewards work
- How to set up data validation for forms, models or dashboards
- How to protect the sheet and the workbook
- Understand the principles of dashboard design
- Create an interactive formula driven market comparison dashboard using formulas, conditional formatting, charts and the camera tool
- Create a pivot chart HR statistics dashboard, using the pivot functionality to group data, and making the dashboard interactive with slicers
Course Outline
Module 1: Using Advanced Excel Formulas
14 April 2021
Lookup And Reference Formulas
Using the following formulas to do pay and benefits calculations:
- Indirect formula with Vlookup
- Index formula
- Offset formula
- Choose formula
- Inserting Form Controls – scroll bar, spin button and combo box
Exercise
If Formulas
Using the following formulas to do pay and benefits calculations:
- If formula
- If (And) ; If (Or) formulas
- Nested If formula
- Countif, Sumif, Averagif formulas
- Countifs, Sumifs, Averagifs formulas
Exercise
Data Validation And Protection
- Setting up a form / document with data validation and protection
- Validating using a list and other criteria
- Hiding sheets
- Unprotecting cells and hiding formulas
- Protecting the sheet and the workbook
Exercise
Module 2: Creating Powerful Excel Dashboards
15 April 2021
Discussion Of Previous Exercise
Dashboards Presentation
- What are Excel dashboards?
- How to create Excel dashboards?
- Examples of HR and Rewards Excel dashboards
Creating A Dashboard Framework
Creating A Market Comparison Dashboard
- Using the Offset, Match, Averageifs, Iferror, Datedif, Indirect, Array and other formulas and functions to create an interactive formula driven dashboard
- Using conditional formatting icons and charts to add visuals to the dashboard
- Using the camera tool to show tables in the dashboard
- Protecting the dashboard
Creating A Pivot Chart Dashboard
- Creating an HR statistics pivot chart dashboard
- Grouping data in a pivot table
- Creating and sizing charts to fit the dashboard
- Making the dashboard interactive with slicers
- Protecting the dashboard
Course Director
|
Dianne Auld GRP, CCP, CSCP 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. Based in Cape Town, South Africa, she travels worldwide showing reward professionals how to harness all the power of Excel. Dianne has developed a series of Excel and dashboard courses for compensation professionals. Dianne is also a faculty member at WorldatWork and a reviewer for the WorldatWork Journal. Since 2012, she has presented each year at the Worldatwork US Total Rewards conference. |
Venue
Online Training
Online Training
Telephone: +971 4 407 2500
Fax: +971 4 335 2438
Course Fees
|
|
|
|
Pricing excludes 5% VAT, which will be charged where applicable
Conduct group trainings for this course in your company.
For more information and group discounts, call +971 4 408 2864 or email a.watts@informa.com
Call Me Back
Related Courses
-
View DetailsCertificate in HR Administration (Online Training)
19 - 21 October 2021
Online Training
Level : Intermediate
Education Partner : CPDContinuing Professional Development (CPD)
-
View DetailsManaging Remote Teams (Online Programmes)
13 - 26 June 2021
Online Programmes
Level : Intermediate
-
View DetailsCreating an Integrated Employee Experience & Engagement Programme (Online Training)
28 - 29 July 2021
Online Training
Level : Intermediate
-
View DetailsOrganisational Agility
19 - 21 September 2021
LIVE In-Person
Level : Intermediate
-
View DetailsConducting Workplace Investigations
17 - 19 August 2021
LIVE In-Person
Level : Intermediate
-
View DetailsEmployer Branding for Competitive Advantage (Online Training)
24 - 25 October 2021
Online Training
Level : Intermediate
-
View DetailsBest Practice Recruitment (Online Training)
26 - 28 October 2021
Online Training
Level : Essential

13 - 26 June 2021
Online Programmes
Level: Intermediate

28 - 29 July 2021
Online Training
Level: Intermediate

17 - 19 August 2021
LIVE In-Person
Level: Intermediate

19 - 21 September 2021
LIVE In-Person
Level: Intermediate

19 - 21 October 2021
Online Training
Level: Intermediate
Education Partner : CPDContinuing Professional Development (CPD)

24 - 25 October 2021
Online Training
Level: Intermediate

26 - 28 October 2021
Online Training
Level: Essential