Advanced Excel Skills for Compensation Professionals

  • May 19, 2016
  • 8:00 AM
  • May 20, 2016
  • 5:00 PM
  • TBD


  • WorldatWork Member - $1,125
    NonMember - $1,680

Advanced Excel Skills for

Compensation Professionals

Face-to-Face with Instructor and Excel Expert, Dianne Auld

Are you a compensation professional who uses Excel on a regular basis to analyze large amounts of data, but would like to learn more advanced techniques to streamline your work? In this 2-day, limited engagement class with instructor and Excel expert Dianne Auld, you will discover advanced Excel techniques and apply them to create powerful interactive Excel dashboards to consolidate vast amounts of data, findings and analysis into a condensed, executive summary view that will facilitate sound business decisions.

On the first day you'll learn 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. The next day, you'll learn about data validation and protection as well as macros and put what you learned into action as you create an Excel dashboard that will illustrate how pay structures compare competitively to the market.

  • Learn advanced Excel formulas to streamline your compensation tasks.
  • Create an interactive Excel dashboard using a real-world scenario that illustrates how pay structures compare competitively to the market.
  • Transform vast amounts of data and display analysis and key findings in a condensed space where it is easy to access, interact with and understand.
  • Learn how to gain critical information and insights from dashboards in order to make quick and effective business decisions.
  • Ask questions and interact with Excel expert, Dianne Auld.


This course is for professionals with advanced Excel skills and who use Excel for compensation work on a regular basis. Participants must be comfortable with writing Vlookup, If and other formulas and be able to create charts in order to keep pace with the course.




To Register:

Powered by Wild Apricot Membership Software