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
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.
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 WorldatWorkJournal. 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.
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).
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.