CTCBA 

WorldatWork Advanced Excel 2020

  • March 23, 2020
  • (CDT)
  • March 24, 2020
  • (CDT)
  • Beautiful Downtown Austin, Texas

 

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

 

 Click here for more information and registration.

 

CTCBA is a 503(c) educational nonprofit association headquartered in Austin, Texas.

Powered by Wild Apricot Membership Software