Learn How To Utilise Advanced Excel Formulas For Rewards Work, And Understand The Principles Behind Creating Dashboards And How To Create A Pivot Chart Dashboard

WHO IS THIS MASTERCLASS FOR:

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.

OUTLINE

Introduction

Lookup And Reference Formulas

Using the following formulas to do pay and benefits calculations:

Vlookup formula
Hlookup formula
Iferror with Vlookup
Using named ranges with Vlookup
Using Vlookup with the columns formula
Xlookup formula
Indirect formula

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

Dashboards Presentation

What are Excel dashboards?
How to create Excel dashboards?
Examples of HR and rewards Excel dashboards

Illustration Of A Formula Driven Dashboard

Quick review of a formula driven dashboard to illustrate some of the Excel techniques that can be used to create dashboards

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

Workshop: Advanced Excel Skills & Dashboards For Comp Professionals

Workshop: Advanced Excel Skills & Dashboards For Comp Professionals