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