Course Outline:

Building a system in Excel for computing the PAYE Income Tax

Applying the Applied-Excel® Core Courses to Design and Develop a Payroll Management System

Determination of the Basic Salary given the Net Salary

Automatic generation of Payroll Detail Report

Automatic generation of Payroll Summary Report

Automatic generation of Pay Slips

Automatic generation of IRS Monthly Tax Deductions Report

Expansion and Troubleshooting