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 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
- C&B Professionals at every level
- HR Manager/professional who has focused on C&B
- Exercise Files for practice
- Full Video recording of the training
- Certificate of Participation
Pre-requisites to Participate:
- Should have intermediate knowledge about Excel.
- Use Microsoft Office 2016 or higher. Office 365 is the best
- 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/
Course and Training of this Instructor:
- Business Reporting with PivotTables
- Advance Excel Functions & Tools
- HR Analytics & Dashboard with Excel
- Tips & Tricks of Modern Dashboard
- Bring Data to Life Excel Dashboard
- Use Excel Like a Pro!
- PivotTable Basic to Pro
- Increase Office Productivity with MS Excel Lookup Series
- Power up Excel Report with Power Pivot & Power Query
- HR Analysis & Dashboard with Excel
- Essentials of Excel Business Intelligence Tool
- Automate HR Dashboard & Reporting with Excel
- Advance Excel for Sales & Marketing Professional
- Lectures 15
- Quizzes 0
- Duration 6.5 hours
- Language Bangla
- Students 26
- Certificate Yes
- Assessments Yes