Excel for Compensation & Benefits Professional
Please fill following information
This one-day / seven hours online 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 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 perquisite 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 focus on C&B
Course Information
- Reg. Ends 21 October, 2021
- Start Date 22 October, 2021
- End Date 23 October, 2021
- Class Schedule 7:00PM - 10:30PM
- Total Hours 7
- Venue Title Online Live Training
- Venue Address www.sudoksho.com/class-room
