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

Course

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

Virtual Classroom

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

Course

Member: $395 USD

$525 USD

Instructor

Dianne Auld

Excel Expert Instructor
Auld Compensation Consulting

Dianne Auld, CCP, GRP, CSCP, WLCP owns a consulting practice, Auld Compensation Consulting, in Cape Town, South Africa. She consults a wide range of organizations across Africa and the Middle East in all areas of total rewards. 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 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. Diane has partnered with WorldatWork to develop several educational products to assist compensation professionals with their day-to-day tasks in Excel, including "Pay Structures - Develop a Framework from Start to Finish," "Excel Skills for Compensation Professionals," "Advanced Excel Skills for Compensation Professionals," "Excel Tips for Compensation Professionals," and "Tackling Compensation's What If Questions Using Excel".

Course Credits & Certifications

  • Recertification

    0.25 credits

More Information

Who Should Register

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

Requirements

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

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