HRD

Excel Skills for Compensation Practical Workshop

Equips C&B professionals with hands-on practical skills needed to do actual compensation work with focus on Excel skills.

1-day interactive session

Offered in-person, online, and in-house at your Organization

Accredited by ASEAN Total Rewards Institute

Course Introduction

This one-day course equips learners with hands-on practical skills needed to do actual compensation work within a typical HR and business environment, with focus on Excel skills. It is designed to supplement theoretical and technical knowledge of compensation gained through certification courses or other knowledge-based training on remuneration practices. Using a “watch first, then do together” approach, the facilitator will demonstrate the actual process steps involved in job evaluation, market analysis, salary structure design, salary proposal preparation and commonly used Excel functions. Using simulated data for a fictitious company, learners will work on their own laptops to complete the above tasks using tools and methods similar to those used by large companies.

Learning Outcomes
By the end of the session, participants should be able to:
1. Evaluate a job
2. Conduct a market benchmark analysis
3. Calculate individual and aggregate market ratios
4. Develop a salary range structure and calculate compa-ratios
5. Develop salary proposal worksheet
6. Use Excel functions for the most common compensation tasks

Course Facilitator

Detailed Agenda

1. Sample Excel practice file, including “start” version and the instructor’s final version, with:
● Fictitious employee data and market data
● Survey job matching template, with premium and discount feature
● Market data aging calculator
● Market-ratio and compa-ratio calculations
● Salary structure design template
● Regression tools
● Salary proposal worksheet

2. Job Analysis Questionnaire

Who Should Attend?

This class is designed specifically for HR or Comp & Benefits professionals with basic knowledge of compensation practices such as job evaluation and market pricing, but who wish to acquire or sharpen practical hand-on skills to perform related tasks. Those who have had some formal training or certification, or have at least one year experience doing compensation work will benefit most.

Course Requirements
A laptop with Microsoft Excel installed is required for the workshop.

What Others Say About This Course

“I gained a lot of value and insights from this programme. I am thankful for having the opportunity to attend as this programme did a great job delivering the curriculum.”
“Very informative. Really made me think about possible scenarios. I found Tom Farmer, the trainer excellent. He could answer all questions asked and delivered the course in an interesting format.”
“Great Trainer, willing to share his own materials to participants. Fresh idea got showed something different from old practice”
“Tom Farmer is a real expert. A Jedi master in C&B. Elbee handled everything well. Professional and warm. Keep it up guys. Congratulations I learned a lot.”

Request more information

Event Gallery