Using Excel for Compensation Modeling

Time: July 30th, 2020 01:00 PM Eastern Time (US and Canada)

Want to gain a better understanding of how Excel can be used as a decision making tool for compensation plan design? Join TCA for it’s upcoming Truckload Live Distance Learning virtual session so you can learn from one of the best, Beth Carroll.

To make the best use of time, we assume you have a basic understanding of Excel and can write a SUM formula, perform basic calculations, and write an IF statement.

Key items to be addressed:

– How to use Excel as a decision making tool for financial modeling or any sort of statistical analysis;
– Examples of simple tools to use in Excel when doing financial modeling; and
– Formulas such as SUMIFS, VLOOKUP, INDEX, INDIRECT, DATA TABLES, PIVOT, and POWER PIVOT for compensation modeling.

Be sure to check back regularly for further details on the following topics as they are scheduled:

• Best Practices for Communicating Compensation Plan Changes;

• Annual Review and Plan Governance; and

• How to Keep Your Plans on Track.