MERCER LEARNING

H E A LT H W E A LT H C A R E E R

I N T R O D U C T I O NAiming to develop all-around knowledge of compensation and benefits? Eager to connect the dots on compensation-related and benefits-related knowledge, and want to know how it can be applied in your dailyHR work?

Attend this 3-in-1 workshop to learn about interesting topics ranging from compensation, role analysis, job evaluation to benefits, and understand the practical applications within your organization.

W H A T T H E W O R K S H O P W I L L C O V E R

• Learn about Mercer’s International Position Evaluation (IPE) job evaluation methodology, and howto apply it.

• Understanding compensation philosophy, strategyand rewards elements.

• How to leverage data to manage compensationeffectively.

• Working with market data and trend analysis.

• What makes for an “ideal” benefits program.

• Learn Excel skills to manage HR data efficiently and how to use Excel for data analysis.• Create, design and format Excel spreadsheet for reporting and forecasting.

M E R C E R L E A R N I N G

This workshop is accredited by WorldatWork

3 - IN - 1 WORKSHOP : INTERNATIONAL POSITION EVALUATION,COMPENSATION AND BENEFITS, DATA ANALYTICS USINGEXCEL WORKSHOP

W H A T Y O U W I L L L E A R N

Day 1

Mercer's International Position Evaluation methodology and its applications.

Day 2

How to develop a compensation policy that delivers great value to the employeeat the lowest cost to the company.Use of different tools and techniques for compensation management.

How to design Benefits and implement incentives that motivate staff.

Day 3Algorithm, logical and text operations, sorting and filtering, charts and lookup functions.

Learn dynamic lookup operations, pivot table and array of formulas.

Copyright 2019 Mercer LLC. All rights reserved.

For more information about Mercer Learning AMEA, please visit our website at I M E R C E R . C O M / M E R C E R L E A R N I N G A S I A

C O N TA C T D E TA I L S

TA L K T O M E R C E R T O D AY For any inquiries regarding registration or other questions related to Mercer Learning programs, please contact:

C A R M E L L A P I L L A IT : + 6 0 3 - 2 3 0 2 8 5 6 7 E: carmella.pillai@mercer.com

W H Y M E R C E R ?Mercer’s learning and development solution enhances and integrates business capability through people development. With a local focus and best practice expertise, backed up by global intellectual capital, we offer courses that are designed to deepen expertise of both people managers and HR practitioners at all levels. These courses are developed from our extensive consulting experience and are updated to reflect changing business environments and the latest HR thinking and practice.

W O R K S H O PD E T A I L S

D A T E :19-21 November 2019 | 9.00am - 5.00pm

V E N U E :Sheraton Petaling Jaya HotelJalan Utara C, 46200 Petaling Jaya, Selangor

F E E S :STANDARD EARLY BIRDMYR 6,700 MYR 5,000

Select Mercer programmes qualify for recertification credit for the Certified Compensation Professional® (CCP®), Certified Benefits Professional®(CBP), Global Remuneration Professional (GRP®), Work-Life Certified Professional® (WLCP®), Certified Sales Compensation Professional (CSCP)®, Certified Executive Compensation Professional (CECP)®, Advanced Certified Compensation Professional (ACCP)™ and Master Certified Compensation Professional (MCCP)™ designations granted by WorldatWork Society of Certified Professionals. For more information on recertification, visit the

Register by 01 November 2019 to enjoy the WorldatWork recertification webpage. early bird fee

R E G I S T E R

3 - IN - 1 WORKSHOP : INTERNATIONAL POSITION EVALUATION, COMPENSATION & BENEFITS, DATAANALYTICS USING EXCEL

H E A LT H W E A LT H C A R E E R

W H A T T H E W O R K S H O PW I L L C O V E R

In the era of big data, Excel is one of the key tools for different types of analysis. Without the skillset to master it, you may end up spending extra hours doing manual calculations. Mercer’s Excel workshops will equip HR professionals with the knowledge and skills on how to perform various calculations with ease and confidence.

HR professionals are frequently tasked to manage day to day HR data analysis, reports, tools and applications using Excel. In this hands-on workshop, participants will work on practical exercises and HR-related case studies that would help develop practical skills and learn techniques to manage HR data efficiently.

• Compile and analyze C&B market data from multiple sources.

• Determine salary mid-point by data regression, minimum and maximum of salary ranges and pay adjustment.

• Algorithm, logical and text operations, sorting and filtering, charts and lookup functions.

• Learn dynamic lookup operations, pivot table and array of formulas.

• Excel shortcuts every consultant should know.

M E R C E R L E A R N I N GR E W A R D S A N A L Y T I C S U S I N G E X C E L

MERCER LEARNING

I N T R O D U C T I O N

W H A T Y O U W I L L L E A R N

Learn Excel skills to manage HR data efficiently.

Learn how to make the best use of important formulas.

Learn how to use Excel for data analysis.

Create, design and format Excel spreadsheet for reporting and forecasting.

Copyright 2019 Mercer LLC. All rights reserved.

For more information about Mercer Learning AMEA, please visit our website at I M E R C E R . C O M / M E R C E R L E A R N I N G A S I A

R E W A R D S A N A L Y T I C S U S I N G E X C E L W O R K S H O P

C O N TA C T D E TA I L S

TA L K T O M E R C E R T O D AYFor any inquiries regarding registration or other questions related to Mercer Learning programs, please contact:

C A R M E L L A P I L L A IT : + 6 0 3 - 2 3 0 2 8 5 6 7 E: carmella.pillai@mercer.com

W H Y M E R C E R ?Mercer’s learning and development solution enhances and integrates business capability through people development. With a local focus and best practice expertise, backed up by global intellectual capital, we offer courses that are designed to deepen expertise of both people managers and HR practitioners at all levels. These courses are developed from our extensive consulting experience and are updated to reflect changing business environments and the latest HR thinking and practice.

W O R K S H O PD E T A I L S

D A T E :21 November 2019 | 9.00am - 5.00pm

V E N U E :Sheraton Petaling Jaya HotelJalan Utara C, 46200 Petaling Jaya, Selangor

F E E S :STANDARD EARLY BIRD MYR 2,500 MYR 2,100

Select Mercer programmes qualify for recertification credit for the Certified Compensation Professional® (CCP®), Certified Benefits Professional® (CBP), Global Remuneration Professional (GRP®), Work-Life Certified Professional® (WLCP®), Certified Sales Compensation Professional (CSCP)®, Certified Executive Compensation Professional (CECP)®, Advanced Certified Compensation Professional (ACCP)™ and Master Certified Compensation Professional (MCCP)™ designations granted by WorldatWork Society of Certified Professionals. For more information on recertification, visit the WorldatWork recertification webpage.

Register by 01 November 2019 to enjoy the early bird fee

R E G I S T E R