Working Smarter and Faster with Excel Formulas, Charts and ASAP Utilities


A Skill-Building Course with Compensation, Excel Expert Dianne Auld

Free up your time by making the data work for you! Excel formulas for data, such as merit increases and tax tables, can be extremely long and complex, but they don't have to be. You can save hours or even days of time by simplifying complex formulas.

In this two-hour virtual classroom, Dianne Auld will demonstrate time-saving and often unknown tips in Excel. Learn how to read data from merit increase tables, tax tables, commission tables and more without writing complicated, nested IF formulas. You'll find charts have never been easier with shortcuts such as keystrokes and templates. You'll also learn to use ASAP Utilities to apply a single command to multiple worksheets quickly and efficiently.

After this class, you will know how to:

  • Write more efficient lookup formulas in place of complex nested formulas
  • Create combo charts for impactful market comparisons
  • Format, separate and combine increase allocation files in minutes using ASAP Utilities

Extra value! Take home session files and instructions on how to replicate the functions demonstrated in class.

What You Will Learn:

Section 1 — Create More Efficient LOOKUP Formulas

  • Use VLOOKUP without False at the end to read in between values to look up merit increases, tax tables, commission rates or ranges of any kind
  • Use INDIRECT and named ranges to look up different tables, or combine INDIRECT with an ARRAY formula to bring in different tables

Section 2 — Create Charts in Less Time

  • Use a keyboard shortcut to create a chart
  • Use the combo chart option to create effective market comparison charts
  • Save the chart you like as a template, then change chart type to your template to create the chart you want in two steps
  • Discover shortcuts to link your heading to the worksheet and paste data into the chart

Section 3 — Use ASAP Utilities to:

  • Round numbers or change case in place
  • Protect, unprotect or unhide multiple worksheets at one time
  • Select data down to the last used row
  • Copy values to empty cells below filled cells in a selection
  • Detect and visualize adjacent data
  • Break increase data into worksheets
  • Create an index of all your worksheets
  • Export the worksheets as separate files
  • Import and merge separate files into one worksheet

All tips will be demonstrated using one example in sequence.

Learning Options Click on your preferred Learning Option to see pricing and schedule.

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!


Member: $395 USD

$525 USD


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

    0.25 credits

More Information

Who Should Register

Compensation practitioners or compensation managers with at least intermediate Excel skills.


You should have a computer with Microsoft Excel 2010 or later in order to use the modeling tools and formulas demonstrated in class.

How to Register


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

Have Questions?


+1 877 951 9191

USA and Canada

+1 480 951 9191

Other Countries


Email Us