WorldatWork, the Total Rewards Association
 
 
Password:  Change  |  Forgot  |  Help   
     
Email   Print
 
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:
PivotTables  
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  
Macros  
Form Controls  

 

Audience

Compensation professionals who are using or would like to incorporate the use of Excel when working with compensation data.  To get the most out of these tips, it is recommended you have basic to intermediate knowledge of Microsoft Excel. All tips were created using Microsoft Excel 2007 so it is recommended you use this version of software.


Instructor

Dianne Auld, GRP, CCP, CSCP

Dianne Auld, GRP, CCP, owns a consulting practice, Auld Compensation Consulting, in Cape Town, South Africa. She consults in all areas of total rewards to a wide range of organizations across Africa and the Middle East. She has developed and taught courses in Africa, the Middle East, Europe, and the United States.

Dianne is also a faculty member at WorldatWork and a reviewer for the WorldatWork Journal.  Well respected and known as an expert in Excel, Dianne has worked with WorldatWork to develop several products to assist compensation professionals with their day-to-day tasks in Excel. Together with WorldatWork, Dianne has developed a new WorldatWork Blended Learning course called “Excel Skills for Compensation Professionals”  as well as Excel Tips for Compensation Professionals, which include sleek visual and audio demonstrations of tasks compensation professionals need to perform in their job function.


Requirements

An Internet connection is needed to access Excel Tips for Compensation Professionals. These tips were created in Excel 2007 so using this version of software will provide the best overall experience. 


Take a Free Product Tour

Excel Tips for Compensation Professionals provide step-by-step video demonstrations that can save you vast amounts of time in analyzing data. 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.

Sample Video Tip
Each tip includes a step-by-step video demonstration of an Excel function. You will be able to access video tips for 60 days from the day you purchase the package. View a video tip from the "Changing Value Field Settings" in a PivotTable from the PivotTable package (be sure to have your volume turned on).

View Demo

Job Aids & Spreadsheets
Each tip comes with a Job Aid and the spreadsheet used in the video demonstration so you can practice and apply what you learned in the video. Download within 60 days of your purchase and keep for future reference.

Here is a sample of the Job Aid and Spreadsheet you would receive in the "Changing Value Field Settings" in a PivotTable from the PivotTable package.

Sample Job Aid
Sample Spreadsheet

 

 

 

 

 

 

 

 

 

 

 

 
Share
 
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.
CONNECT WITH US 

Copyright  |  Privacy Policy  |  Site Map  |  Advertise with Us  |  Community Terms and Conditions

WorldatWork