Close
Learning Methods
Classroom
A traditional classroom couples on-site learning with the added value of face-to-face interaction with instructors and peers. With courses and exams scheduled worldwide, you will be sure to find a class near you.
Interaction
Highly Interactive
On-going interaction with instructor throughout the entire classroom event
Interaction with peers/professionals via face-to-face
Components (May Include)
Onsite
On-site instructor-led delivery of course modules, discussions, exercises, case studies, and application opportunities
Supplemental learning elements such as: audio/video files, tools and templates, articles and/or white papers
E-course materials available two weeks prior to the course start date; printed course materials ship directly to the event location
Duration
One + Days
Varies by course ranging from one to multiple days
Technical Needs
Specific requirements are clearly noted on the course page
Virtual Classroom
Ideal for those who appreciate live education instruction, but looking to save on travel. A virtual classroom affords you many of the same learning benefits as traditional–all from the convenience of your office.
Interaction
Highly Interactive
On-going interaction with instructor throughout the entire virtual classroom event
Interaction with peers/professionals via online environment
Components (May Include)
Live online instructor-led delivery of course modules, discussions, exercises, case studies, and application opportunities
Supplemental learning elements such as: audio/video files, tools and templates, articles and/or white papers
E-course materials available up to one week prior to the course start date. Recorded playback and supplemental materials available up to seven days after the live event.
Duration
Varies by course ranging from one to multiple sessions
Technical Needs
Adobe Flash Player
Acrobat Reader
Computer with sound capability and high-speed internet access
Phone line access
E-Learning
A self-paced, online learning experience that allows you to study any time of day. Course material is pre-recorded by an instructor and you have the flexibility to view content modules as desired.
Interaction
Independent Learning
Components (May Include)
Pre-Recorded
Pre-recorded course modules
Supplemental learning elements such as: audio/video files, online quizzes
E-course materials start on the day of purchase
Optional purchased print material ships within 7 business days
Duration
120 Days - Anytime
120-day access starts on the day of purchase
Direct access to all components
Technical Needs
Adobe Flash Player
Acrobat Reader
Computer with sound capability and high-speed internet access
Close
Contact Sponsor
E-Reward
Online
Paul Thompson
Phone: 1 44 01614322584
Contact by Email | Website
Close
Sorry, you can't add this item to the cart.
You have reached the maximum allowed quantity for purchase in your cart or the item isn't available anymore.
Product successfully added to your cart!
Price
View your cart
Continue shopping
Please note our website will be down this Friday, November 5 from 9pm ET – 11pm ET for routine maintenance. We apologize for any inconvenience.
Course

Advanced Excel Skills for Compensation Professionals

;
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.

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
Become a Member
Not only do Members gain access to exclusive information, they also gain access to education and events!
Join Now

Learning Options

Course Schedules
Filtro Filtro Filter By
Filtro Filtro 2 Filter By
Reset all
Clean

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.

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

More Information

Who Should Register
This course is designed for professionals who want a basic overview of the components that can create an effective balance in employee rewards tools. This includes professionals new to human resources, HR generalists and line managers.
How to Register
Register Online (above)
Call 877-951-9191 (United States and Canada) or +1480-951-9191 (other countries) for Customer Experience Team.
Email customerexperience@worldatwork.org.
Policies
Click Here to view our policies on payments, returns, class schedules, registration, cancellation, and more.