Learn Payroll Administration Basics on Excel - Short Course
1.0 (1 rating)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4 students enrolled

Learn Payroll Administration Basics on Excel - Short Course

User-friendly Payroll Administration Excel spreadsheets
New
1.0 (1 rating)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4 students enrolled
Created by Michelle van Wyk
Last updated 5/2020
English
English [Auto]
Current price: $11.99 Original price: $19.99 Discount: 40% off
1 day left at this price!
30-Day Money-Back Guarantee
This course includes
  • 32 mins on-demand video
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • How to use Excel Spreadsheets to keep accurate and up-to-date Payroll records
Requirements
  • Basic Bookkeeping / Payroll knowledge
Description

A basic Excel structured Payroll course, to teach you the basics of payroll, as well as to provide you with the tools needed to edit and create your own personalized Excel Payroll workbook.

The workbook is structured in an easy and user friendly manner, to facilitate learning and personalization.

This course is best suited for:

  • Start-up business owners, who cannot afford expensive payroll packages or extra help in the office

  • Persons who consider pursuing a career in payroll administration and /or bookkeeping

  • Beginner payroll administrators and /or bookkeepers; and

  • Students

Please note that the information used during this course may differ from company-to-company, and was only used as sample data. It is your responsibility to make sure that you use the information relevant to your specific needs. Two sources of information has been provided in the introduction video, which will assist you in determining the data that applies to your business.

Who this course is for:
  • Start-up Business Owners
  • Payroll Administrators
  • Junior Bookkeepers
  • Financial Administrators
  • Payroll Students
  • Bookkeeping Students
Course content
Expand 7 lectures 32:08
+ Introduction
7 lectures 32:08

A short introduction on the course and myself

Preview 01:40

This lecture covers:

  • How to use Excel formulas to create a workday spreadsheet

Preview 02:10

Let's reflect on the lesson Part 1...

Part 1 - Workday Tracker Spreadsheets
2 questions

This lecture covers:

  • How to use Excel formulas to create an automated leave day spreadsheet

Part 2 - Leave Day Worksheet
08:46

Let's reflect on the lesson Part 2...

Part 2 - Leave Day Tracker
7 questions

This lecture covers:

  • How to use Excel formulas to create an automated timesheet

Part 3 - Timesheets, Salaries /Wages and Deductions
09:29

Let's reflect on this lesson Part 3...

Part 3 - Timesheets, Salaries /Wages and Deductions
7 questions

This lecture covers:

  • How to use Excel formulas to automatically calculate PAYE deductible from the employee's salary

  • Income Tax Brackets for the 2020/2021 financial year

  • Rebates for the 2020/2021 financial year

Preview 06:30

Let's reflect on this lesson Part 4...

Part 4 - PAYE Data Sheet
5 questions

This lecture covers:

  • How Excel formulas can be used to automatically calculate the amounts of UIF, SDL and PAYE that need to be submitted and paid over to SARS

Part 5 - EMP201 Information
02:03

Let's reflect on this lesson Part 5...

Part 5 - EMP201 Information
4 questions

This lecture covers:

  • ETI calculations

  • Who qualifies for ETI


Part 6 - ETI
01:30

Let's reflect on this lesson Part 6...

Part 6 - ETI
5 questions