View All Events

Using Excel for Compensation Modeling

Thursday, July 30, 2020

Registration Pricing

TCA Member – $219

Non-Member – $399

TPP Best Practice Group & inGauge Users – No Charge

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 at 1 p.m. ET on Thursday, July 30.

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.


Beth Carroll

Beth Carroll is the Founder and Managing Principal of Prosperio Group and has worked with more than 100 transportation & logistics companies. For 21 years, Beth has been developing compensation strategies to help large and small companies from all industries maximize, focus and improve engagement and morale throughout their organization.   

Upcoming Truckload Live Distance Learning Courses

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.