Course
Analyzing & Automating Rewards Data with Excel
Save time and ease decision-making with powerful Excel tools that streamline data formatting and calculations.

Spend more time using data – and less time preparing it in Excel. In two short hours, you will boost your efficiency and decision-making acumen by learning tested techniques for streamlining data formatting and calculations.

What You’ll Learn 

  • Using pivot tables and charts to analyze data and create interactive dashboards.
  • Writing macros to automate frequent tasks.
  • Using interactive tools to generate robust analyses.
  • Modeling the impact of different base pay increases on average comparative ratios to market and on cost of increase.
  • Modeling the impact of different eligibility levels, share allocation numbers and stock prices on the cost of stock granted.
  • Calculating the cost of stock granted as a percentage of base pay and shares granted as a percentage of shares outstanding.

Who Will Benefit from This Course? 

This course is ideal for anyone seeking to create interactive pivot tables quickly and easily, and who wishes to use macros to automate repetitive tasks. 

Course Requirements

The course requires an intermediate to advanced knowledge of Excel. Participants also should have access to a computer with Excel 2013 or newer.

Related Courses

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

Recertification Credits

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


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

Become a Member

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

Learning Options
Exercises are included throughout each section of the course for hands-on practice.
Course Schedules
Filtro Filtro Filter By
Filtro Filtro 2 Filter By
Reset
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