Advanced Excel for Compensation Professionals

Are you a compensation professional who routinely uses Excel to analyze large amounts of data and dream of being able to work more efficiently? If so, this Excel training class designed for HR professionals is for you. In it you will learn advanced Excel techniques developed by Dianne Auld, an in-demand total rewards expert and faculty member at WorldatWork. 

Over the two-day course you will learn: 

• How to create powerful interactive Excel dashboards that consolidate large amounts of data into executive summary views to facilitate business decision making.
• Advanced Excel functions, including complex LOOKUP and IF formulas, data validation and protection, array formulas and macros to do pay and benefits calculations and pay and commissions calculations.
• How to build Excel dashboards using real-world scenarios. 

Participants must be proficient with writing VLOOKUP, IF and other formulas and be able to create charts.

Recertification:

Course: 2 credits

CEUs: Course: 1.5 credits

HRCI Recertification 14 classroom hours

SHRM Recertification: 14 classroom hours

If you are registered or interested in registering, contact WorldatWork at                   877-951-9191 and provide them with the CTCBATR2020 code.

 Click here for more information and registration.