Individuals
Contact us
Student Portal
TRANSFORM Training LOGO

Advanced Excel Skills & Dashboards for Compensation Professionals

HR and Reward professionals today are expected to be proficient in Excel to effectively analyse data and do pay calculations. This advanced-level live streaming online course will help you utilise advanced Excel formulas for your rewards work, understand the principles behind creating dashboards and create interactive formula-driven and pivot chart dashboards. This hands-on practical course has been created for reward, HR and payroll professionals who would like to enhance their Excel skills, and perform complex job tasks such as compiling and analysing data and performing calculations.

Course Enquiry Form

Your Location(Required)
MM slash DD slash YYYY
Course Content
Who Should Attend
Benefits of Attending

Course Content

How to use the VLOOKUP formula together with named ranges, with the COLUMNS formula, the IFERROR formula and the INDIRECT formula to increase productivity and reduce errors when working with rewards data
How to use the HLOOKUP formula
How to use the brand new and powerful XLOOKUP formula together with dynamic arrays for rewards work (Office 365 subscribers only)
Understanding the logic of the IF formula
How to use IF formulas, IF (AND) and IF (OR) formulas, Nested IF formulas, COUNTIF, SUMIF, AVERAGEIF, COUNTIFS, SUMIFS and AVERAGEIFS 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

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

1.Use advanced Excel skills so that you can concentrate on extracting insights from your data rather than waste hours or days crunching numbers
2.Enhance your Excel skills, and perform complex job tasks such as compiling and analysing data and performing calculations

Earn a Certificate

All of our courses come with an official digital certificate issued by the respective course provider, verifying your skills and knowledge while enhancing your professional credentials.
Transform Education Certificate-training

Trusted content endorsed by a leading awarding body

Transform courses are used by some of the world’s most recognisable companies. Where you see the Transform Quality endorsed stamp, the course meets the highest quality standards expected of a leading UK awarding organisation.