1. Home
  2. Course
  3. Excel for Payroll (CPF and Salary)

Excel for Payroll (CPF and Salary)

  

About this Course

This course is design to help you develop your own customized spreadsheet with regards to yourCPF Rates & Salary calculations using Excel 2010

Course Outline :

  • Calculating new CPF rates for different age groups i.e <35, > 35<50, >50<55, >55<60, >60<56, >65 for both employers and employees.
  • Calculating 1st year & 2nd year PR contributions
  • Salary voucher preparation
  • Calculating Agency Fee for CDAC, MBMF, SINDA, ECF
  • Calculating Skill Development Levy
  • Consolidating Salary and CPF amount for IR8A & IR8S reporting
  • Printing individual staff consolidated payroll report
  • Align with CPF e-submission of contribution details (Auto eXcel Plus)
  • Copy partial records from excel to “Auto-Inclusion Scheme Offline Application (version 2.3)”
  • How to Print Cheques (in Words and Figures)


Course Duration : 5 Hours


Target Audience

This course is designed for a those who wishes to explore the functions of Excel in regarads to CPF, Salary calculations.

Pre-requisites

Need to possess the basic knowledge of Excel version 2007/2010

Certification

Successful trainees will receive Certificate of Attainment from Genetic Computer School

Course Pathway

ICDL Advanced Courses or any other Professional Course


Rate this course:

Comments

Course Rating

  • /5 from users

Course Enquiry

Course Info

Similar Courses Provided By Other Premium Providers

  • ICDL Module 5: ES WSQ - Perform Advanced Database Functions (Microsoft Access 2010) Fast Track

    Information and Communications  

    This course provides the basis for the practice-based test for ICDL Module 5 Perform Advanced Database Functions exam.The exam requires the candidate to operate effectively at more than a basic level of competence and be able to realize much of the potential of the database application. The candidate shall be able to use the database to organize, extract, view and report on data using what are dee...


    Provider:

  • ICDL Module 5: ES WSQ - Perform Advance Database Functions (Microsoft Access 2013 Fast Track)

    Information and Communications  

    This course provides the basis for the practice-based test for ICDL Module 5 Perform Advanced Database Functions exam.This course enables the participant to operate effectively at more than a basic level of competence and be able to realize much of the potential of the database application. The participant shall be able to use the database to organize, extract, view and report on data using what a...


    Provider:

  • Mobile App Creation for End User

    Information and Communications  

    No programming skills required. Come and join us in this one day workshop and learn how you can create a cross platform mobile application in just ONE day.COURSE OUTLINEModule 1.Introduction To The Mobile App IndustryModule 2.Different Kinds of App Marketing ModelsModule 3.Researching & planning your first appModule 4.Publishing Apps Golden RulesModule 5.How to get Images for your appsModule ...


    Provider:

  • Cross-platform Mobile Applications Development

    Information and Communications  

    HTML5 provides developers with tools such as Offline Web Storage, GeoLocation API, Canvas Drawing, CSS3, and many more. HTML5 applications run on Firefox OS, Tizen, Ubuntu Touch, and WebOS without a browser.COURSE OUTLINEModule 1. Mobile Applications OverviewModule 2. Apache Cordova (PhoneGap)Module 3. Cordova apps with EclipseModule 4. jQuery FundamentalsModule 5. jQuery MobileModule 6. Working w...


    Provider:

  • MCSD Web Applications

    Information and Communications  

    Today's customers need high-quality, interactive line-of-business and consumer web solutions. Get recognized for your expertise in creating and deploying modern web applications and services by earning the Microsoft Certified Solutions Developer (MCSD): Web Applications certification. COURSE OUTLINEProgramming in HTML5 with JavaScript and CSS3Developing ASP.NET 4.5 MVC Web ApplicationsDeveloping ...


    Provider: