Merit planning often looks straightforward on paper, until the real decisions begin.
Join us on February 24 for an exclusive, hands on webinar that uses Excel as a working tool to solve a familiar compensation challenge: building a merit matrix that holds up under real world conditions.
Excel Case Study: Using Excel Tools and Formulas to Build a Dynamic Merit Matrix is a guided workshop built around a realistic case study. Rather than walking through formulas in isolation, this session mirrors how merit decisions are actually modeled, tested, and adjusted during a compensation cycle.
What You Will Learn
You will work with Excel tools and formulas commonly used in merit modeling, including
- Tables and named ranges
- VLOOKUP for approximate matches
- INDIRECT and SUBSTITUTE
- XLOOKUP
- INDEX and XMATCH
- Goal Seek
- Scenario Manager
By the end of the session, you will leave with stronger Excel skills, greater confidence supporting compensation decisions, and a repeatable framework you can apply to your own merit planning process year after year.
Credit Details: WAW: 1 Compensation Credit | HRCI: 1 Credit | SHRM: 1 Credit
REGISTER HERE
WorldatWork
