I accept

WorldatWork uses cookies to enhance your experience on the website.
By continuing to use the website, you are agreeing to the use of cookies.

View Privacy Policy Learn more about cookies
Excel Tips for Compensation Professionals

Harness the Power of Excel

Working with and analyzing large amounts of compensation data is not easy. Many compensation professionals rely on Microsoft® Excel® to help them, but working in Excel can be intimidating. Excel Tips for Compensation Professionals provide instructional step-by-step video demonstrations that can alleviate anxiety and save you vast amounts of time when analyzing data.

Excel Tips for Compensation Professionals allows you to focus on your specific learning objectives with a variety of comprehensive packages to choose from. Unlike other Excel tips, each tip provides a visual and audio demonstration, a job aid, as well as sample spreadsheets you can use immediately in your job.  Plus each demonstration is instructed in the context of compensation work—so you’ll see exactly how and when to use these Excel functions.

With Excel Tips you will learn how to:

Perform complex analyses in seconds with PivotTables
Use formulas such as COUNTIF, SUMIF, AVERAGEIF to save you time when analyzing data
Use Advanced LOOKUP functions to create interactive spreadsheets for sales compensation, pay structuring, and market pricing work
Grasp macros to automate repetitive functions
Manipulate what-if functions, indispensable tools for financial modeling of incentives and compensation costs
Leverage regression analysis and interpret the findings
Take the complexity out of array formulas – understand their structure, how to write them, and where they can be useful
Understand how and where to leverage complicated control forms
And more!

Audience  |  Instructor  |  Requirements  |  Take a Product Tour

Excel Tips Are Available in These Individual Packages:
Regression Analysis  
Advanced Lookup Functions  
Data Validation and Protection  
IF Formulas  
What-If Functions  
Using Formulas for Mail Merge and Compensation Work  
Data Consolidation  
Array Formulas  
Paste Special  
Financial Functions  
Control Keys and Function Keys  
Form Controls  
Take a Product Tour
View Demo
Sample Job Aid
Sample Spreadsheet
Still looking for more on Excel?
Don’t miss these other Excel products.
Learn how to apply quantitative concepts utilizing Excel.
Get the foundational skills you need to use Excel in your job.
Have a desk reference of common compensation and benefits formulas and how to apply those in Excel.