Excel for Compensation & Benefits Professional

Curriculum

Overview

Training Outline:

This online course equips learners with hands-on practical skills needed to do actual compensation work within a typical HR and business environment, with a 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 salary structure design, salary proposal preparation, payroll budgeting, tax calculation, 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 Outcome / Training Outline:

Prepare Salary Proposal or CTC Calculation Worksheet
Prepare payroll budget from scratch
Prepare Tax Calculation Worksheet to calculate monthly / yearly salary tax
Prepare Monthly Payroll accumulating data from different sources
Prepare prerequisite worksheet
Prepare 108 Statement as per Income Tax Ordinance
Prepare multiple payroll reports

Target Audience:

C&B Professionals at every level
HR Manager/professional who has focused on C&B

Training Deliverables:

Exercise Files for practice
Full Video recording of the training
Certificate of Participation

Pre-requisites to Participate:

1. Should have intermediate knowledge about Excel.
2. Use Microsoft Office 2016 or higher. Office 365 is the best

Note:

After completing every lesson click on the “COMPLETE” button the go to the next lesson.
Must set up your first name, last name, and display name from settings of your profile for your certificate.
don’t click on the “FINISH COURSE” button.
If you click on the “FINISH COURSE” button then the course will be finished and a Certificate will be generated.
More details: https://thrivingskill.com/faqs/

Instructor: