Excel Skills for Compensation Professionals

Course

Excel Training Course to Make Your Compensation Work Faster and More Effective

As a human resources compensation professional, you rely on Excel to format and analyze large amounts of data. To do this most effectively and efficiently, you need to harness the power of Excel. Learn time-saving Excel strategies in this class developed by total rewards expert and WorldatWork faculty member Dianne Auld. This class will empower you with new skills to save you time – hours, even days – in your compensation work. In this course, you’ll:

  • Receive step-by-step instructions on Excel functions that will make your compensation work easier and more efficient.
  • View demonstrations of essential Excel tasks related to HR compensation work.
  • Complete hands-on practice exercises of the various formulas and functions specific to compensation work.

This class is for the intermediate level compensation professional. It is offered in-person and online. Advanced Excel skills are required for the in-person class due to its faster pace; whereas, intermediate Excel skills are sufficient for the self-paced online environment. A PC laptop with Excel 2007 or later is required for the onsite class. A PC desktop or laptop with Excel 2007 or later may be used for the online course. For both the onsite and online classes, a mouse if recommended for ease in navigation.
 

Course Outline:

  • Customizing toolbars
  • Formatting data
  • LOOKUP, IF and SUM formulas
  • Checking data
  • Subtotaling data
  • Comparative formulas and conditional formatting
  • Statistics for compensation data
  • Charts and graphs
  • Regression analysis
  • Distribution tables (e-learning only)
  • Rounding formulas (classroom only
  • Goal Seek and PivotTables
     

Learning Objectives:

  • Customize the quick-access toolbar
  • Create charts, graphs and tables from various types of data
  • Use formulas to simplify complex calculations
  • Check data for duplications and errors
  • Calculate subtotals
  • Calculate a variety of statistics
  • Calculate linear and exponential regression
     

If you are an HR compensation professional who uses Excel to perform complex job tasks such as compiling and analyzing compensation data and performing calculations and you have intermediate to advanced Excel skills, this class is for you.

Ready to become the go-to Excel whiz within your organization and start saving time?

This course is available in a variety of formats, including online and in-person.

Find a class format that works for you and register today.

*A personal laptop is required for this course

Learning Options

Classroom

On-site instructor-led delivery of course materials with the added value of face-to-face interaction with a subject-matter expert and peers.

Course

Member: $1,125 USD

$1,680 USD

E-Learning

Self-paced online learning with access to pre-recorded course modules delivered by an instructor.

Green Option
60-Day Access

Member: $995 USD

$1,385 USD

Contact Us

Please note: 60-day access to e-course material starts immediately on the day of purchase.

Course Credits & Certifications

  • Recertification

    Course: 2 credits

  • CEUs:

    Course: 1.5 credits

  • HRCI Recertification

    14 classroom hours

  • SHRM Recertification:

    14 classroom hours

More Information

Who Should Register

This course is designed for compensation professionals who need to use Excel to perform complex job tasks such as compiling and analyzing compensation data and performing calculations. Participants should be using Excel regularly for their work.

E-Learning Option: A basic to intermediate knowledge of Excel is required.

Classroom Option: An intermediate knowledge is required since this option is more fast-paced.

Requirements

You must bring a PC laptop (not Mac) with Microsoft Excel 2010 or later. A mouse is recommended to help with extensive on-screen navigation.

How to Register

Policies

Click Here to view our policies on payments, returns, class schedules, registration, cancellation, and more.

Have Questions?

Phone

+1 877 951 9191

USA and Canada

+1 480 951 9191

Other Countries

Online

Chat currently unavailable.

Email Us