Advanced Excel Skills for Compensation Professionals

Course

Create Powerful Excel Dashboards to Streamline Compensation Work in This Online Excel Course

Are you a compensation professional who routinely uses Excel to analyze large amounts of data and dream of being able to work more efficiently? If so, this Excel class is for you. In it you will learn advanced Excel techniques from Excel expert, Dianne Auld.

  • Discover how to create powerful interactive Excel dashboards that consolidate large amounts of data into executive summary views to facilitate business decision making.
  • Learn advanced Excel functions, including complex LOOKUP and IF formulas, data validation and protection, array formulas and macros to do pay and benefits calculations and pay and commissions calculations.
  • Find out how to build Excel dashboards using real-world scenarios

This new online class helps you maximize your time and advance your skills…while staying safe. Each class is divided into three two-week blocks. During each block, you will first study independently using a guided recording from Dianne. Then you will join Diane herself in a two-hour, live online session where she will go over the lesson, answer any questions and share additional insight into advanced Excel techniques.

AEXC-schedule - Dianne Auld

Participants must be proficient with writing VLOOKUP, IF and other formulas and be able to create charts. Upon completing this course, all attendees will receive a new set of tools to create powerful Excel dashboards that analyze large amounts of HR data and facilitate business decision making.

What You Will Learn

Exercises are included throughout each section of the course for hands-on practice.

  • Lookup Formulas Part 1 – Learn to use the following formulas for pay and benefits calculations:
    • VLOOKUP
    • HLOOKUP
    • IFERROR with VLOOKUP
    • Using named ranges with VLOOKUP
    • MATCH
    • Looking up a merit matrix using VLOOKUP and MATCH
  • Lookup Formulas Part 2 – Learn to use the following formulas to do pay and commission calculations:
    • INDIRECT with VLOOKUP
    • INDEX
    • OFFSET
    • CHOOSE
    • Inserting form controls – scroll bar and combo box
  • If Formulas – Learn to use the following formulas to do pay and benefits calculations:
    • IF
    • IF(AND); IF(OR)
    • Nested IF
    • COUNTIF, SUMIF, AVERAGEIF
    • COUNTIFS, SUMIFS, AVERAGEIFS
  • Array Formulas
    • Understand the purpose and rules of array formulas
    • Write multi-cell array formulas and single-cell array formulas
    • Use array formulas for measures of location
    • Use an array formula with INDIRECT
  • Data Validation and Protection
    • Set up a form or document with data validation and protection
    • Validate using a list and other criteria
    • Hide sheets
    • Unprotect cells and hiding formulas
    • Protect the sheet and the workbook
  • Macros
    • Record macros
    • Run macros
    • Macro security settings
  • Introduction to Dashboards
    • Create a dashboard framework
    • Create a market comparison dashboard 

*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

Virtual Classroom

Live online instructor-led delivery of online course materials including real-time interaction with a subject-matter expert and peers — no travel required!

Course

Member: $1,125 USD

$1,680 USD

Instructor

Dianne Auld

Reward Consultant
Auld Compensation Consulting

Dianne Auld, CCP, GRP, CSCP, WLCP owns a consulting practice, Auld Compensation Consulting, in Cape Town, South Africa. . She consults to a wide range of organizations globally in all areas of total rewards. She has developed and taught courses in Africa, the Middle East, Asia, 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 the compensation field and Excel, Dianne's skills and expertise are in high demand. In fact, her sessions at the WorldatWork Total Rewards Conference and Exhibition typically fill to capacity. She is the author of the popular Dianne Auld’s Excel Tips, third edition.

Dianne has partnered with WorldatWork to develop several educational products to assist compensation professionals with their day-to-day tasks in Excel, including "Working Smarter and Faster with Excel Formulas, Charts and ASAP Utilities,” “Regression Analysis Made Easy with Excel,” “Hello Excel Power Query, My New BFF”, "Excel Skills for Compensation Professionals," and "Advanced Excel Skills and Dashboards for Compensation Professionals."

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 for compensation professionals with at least intermediate Excel skills and who use Excel on a regular basis. Participants must be comfortable with writing Vlookup, If and other formulas and be able to create charts.

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

Email Us