Course
Working Smarter & Faster with Excel Formulas
Use timesaving Excel tips to turn long, complex formulas into simple data expressions that speed decision making.

Increase your productivity, reduce your stress, and make better data-based decisions by learning Excel’s secrets for managing compensation calculations.

This live, virtual course covers little-known tips, tricks, and hacks that will save you precious time and effort. In just two hours, you’ll learn to read data from compensation-related tables without writing complicated, nested IF formulas. You'll even learn to apply a single command to multiple worksheets quickly and efficiently. And working with charts will be a breeze once you see the handy shortcuts offered in this course.

At the end of the class, the Excel spreadsheets used by the instructor are yours to keep, along with detailed directions showing how to replicate the functions you’ve learned.


What You Will Learn:

  • Write efficient LOOKUP formulas instead of complex nested formulas.
  • Create combo charts for impactful market comparisons.
  • Use ASAP Utilities to create an index of your worksheets, detect and visualize adjacent data, and more.


Additional Information

This course is ideal for compensation professionals who regularly use Excel to analyze large quantities of data – and who want to work faster and more efficiently through simplified formulas. The course requires an intermediate to advanced knowledge of Excel. Participants also should have access to a computer with Excel 2013 or newer.

Based in India? Contact india@worldatwork.org for India-special course pricing.


Related Courses

This learning experience is part of WorldatWork’s suite of Excel mastery courses, which include:


Policies

View our Return/Cancellation policies and more here.

Become a Member

Members can register for this course at a special rate and gain exclusive access to research, publications and more! 

Course Credits

WorldatWork Recertification

By successfully completing this course you will earn 2 WorldatWork recertification credits.


Learning Options
Exercises are included throughout each section of the course for hands-on practice.
Course Schedules
Filtro Filtro 2 Filter By
Reset
Link
{{product.page_title}}
{{getDate(product.cfs.Product_Start_Date_C, product.cfs.Product_End_Date_C)}}
{{getPlace(product.cfs)}}
{{getDelivery(product.cfs)}} - View Details
@ {{getSponsor(product.cfs)}}
There are no classes scheduled at this time.

Please consider a different learning method or contact our Customer Experience Team to learn about other classes and schedules. Click here to check our global course schedule for availability. Click here to check our global course schedule for availability.

Phone
877-951-9191 (United States and Canada)
+1 480-951-9191 (other countries)

Monday-Friday: 8:00 a.m. - 7:00 p.m. EST

Email
Email our Customer Experience Team: customerexperience@worldatwork.org