The latest Excel updates have propelled its utility for Total Rewards professionals to unprecedented heights. By harnessing the power of Excel's new and advanced features, you can effortlessly tackle complex tasks in mere minutes. During this hands-on workshop you’ll discover the ins and outs of Excel's new features — including FILTER, SORT, UNIQUE, XLOOKUP, IFS, INDEX, XMATCH, INDIRECT, Goal Seek, Map Charts, dynamic ranges and wildcard characters — and learn how to apply them to typical Total Rewards scenarios.

Takeaways

• Use the INDIRECT and SUBSTITUTE formulas to calculate compa-ratios and range penetrations for employees in different salary structures.
• Use the XLOOKUP formula to determine each employee’s correct quartile based on their respective range penetrations.
• Use the INDEX and XMATCH formulas and the Goal Seek function to build out merit matrices.
• Use the IFS and DATE formulas to assign different effective dates to different employees based on a myriad of unrelated factors.
• Use the FILTER and SORT formulas and the Data Validation tool to build interactive, filterable charts.
• Use the UNIQUE formula and the Map Chart feature to create maps with employee information by state.

NOTE: The target audience for this workshop is Total Rewards professionals who already have a working knowledge of Excel. Mastery over common functions and formulas, such as Pivot Tables, VLOOKUP, SUM, and MEDIAN,  prior to attending the workshop is recommended.

Bring your laptop to the workshop for an interactive and hands-on experience. Pre-register for this session through the conference mobile app.