BEGIN:VCALENDAR
VERSION:2.0
PRODID:-// - ECPv6.18.3.1//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-ORIGINAL-URL:https://competad.com
X-WR-CALDESC:Events for 
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:Asia/Shanghai
BEGIN:STANDARD
TZOFFSETFROM:+0800
TZOFFSETTO:+0800
TZNAME:CST
DTSTART:20180101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=Asia/Shanghai:20190510T083000
DTEND;TZID=Asia/Shanghai:20190510T173000
DTSTAMP:20190320T223001Z
CREATED:20170426T000109Z
LAST-MODIFIED:20190320T223001Z
UID:847-1557477000-1557509400@competad.com
SUMMARY:Microsoft Excel for Payroll
DESCRIPTION:Click here to REGISTER \nCOURSE DESCRIPTION:\n To employees\, payday is always an important day. Providing pay and salaries on time and calculating pay and taxes and other statutory deductions accurately is essential to maintain morale and performance of the staff. Armed with basic payroll information and Microsoft Excel\, you can create your own payroll worksheets. \nOBJECTIVES:\n After this training\, you will be able to:\n      A. Know the fundamental Elements of a Payroll Spreadsheet\n      B. Learn Step-by-Step Payroll Process\n      C. Create Advanced Excel built-in formulas and Use Advanced Excel Features that\n      D. Creates Dynamic Employee List and Payroll Sheet that Expands and Contracts as Name of Employee is Added or Removed\n      E. Calculates Salary Withholding Tax and Philhealth Employee/Employer Premiums\n      F. Extracts SSS Employee/Employer Premiums from SSS Table\n      G. Summarizes the SSS and Pag-ibig Loan Balances and Reflects the Due Amount if the Loan is not yet fully paid in the Payroll Sheet           automatically\n      H. Create Payslip Automatically \nCOURSE OUTLINE:\n  I. Module 1 – Fundamental Elements of Payroll Spreadsheet\n      A. Employee Record\n      B. SSS\, Philhealth and Withholding Tax Tables\n      C. Regular and Overtime Days/Hours Worked\n      D. Allowances and Other Benefits\n      E. Deductions \nII. Module 2 – Step-by-Step Payroll Process\n      A. Checking and Updating Employee Records\n      B. Setting Up SSS\, Philhealth and Withholding Tax Tables\n      C. Encoding Daily Time Records\n      D. Encoding Allowances and Other Benefits\n      E. Encoding Deductions \nIII. Module 3 – Advanced Features and Excel Built-in Formulas\n      A. Table\n           i. Table Features that You Can Use to Manage Table Data\n           ii. Elements of an Excel Table\n           iii. Application of Table features in Creating Employee Records that Expands and Contracts as You Add or Remove Employee\n           iv. Application of Table features in Creating Payroll Sheet that Expands and Contracts as You Add or Remove Employee\n      B. IF Function\n           i. Use\n           ii. Components\n           iii. Application in Philhealth Employee/Employer Premiums Computation\n      C. SUMIFS Function\, Advanced Filter and Macro Recorder\n           i. Use\n           ii. Components\n           iii. Application in Summarizing SSS and Pag-ibig Loans (Subsidiary Ledgers)\n      D. VLOOKUP AND INDIRECT Functions\n           i. Use\n           ii. Components\n           iii. Application in SSS Employee/Employer Premiums Computation\n           iv. Application in Salary Withholding Tax Computation\n           v. Application in Creating Payslip Automatically \n \nRegistration Instructions:  \n1. Fill out the registration form by clicking the link on top of this page. You may also download the MS Word attachment send it to training@competad.com\n2. Our admin team shall send you shortly the Statement of Account/Confirmation of registration. Sign the statement of account to conform and finalize your registration and email the soft copy.\n3. Follow the instructions in the statement of account and complete your payment.\n4. Send the scanned copy of the Statement of Account and your deposit slip.\n5. Should you need an official Billing Invoice\, please call us at (02) 4333342 or click here for alternative numbers.
URL:https://competad.com/event/practical-microsoft-excel-course/
LOCATION:Marsk Training Room\, Marsk Building\, Aurora Boulevard corner Balete Drive\, Quezon City\, NCR\, 1111\, Philippines
CATEGORIES:Public Training
ORGANIZER;CN="COMPETAD Training and Professional Development Services":MAILTO:publictraining@competad.com
END:VEVENT
END:VCALENDAR