Excel Yourself/Excel Budget Payroll

  • $25

Excel Budget Payroll

  • Course
  • 4 Lessons

This session examines an existing payroll budget structure. Payroll is one of largest expenses in many organisations. Getting it right is an important step in the budget process. Often the payroll budget is separate to the main budget due to confidentiality issues. This payroll model handles up 250 staff & could be scaled further. Version: All Versions Recorded: Feb 2022 Level: Advanced Duration: 1 hour Price: AU$25

Course content

The session covers
  • Global input and assumptions
  • Handling oncosts like Super and Payroll Tax
  • Including pay increases
  • Using check boxes in a budget
  • Using Conditional formats for warnings
  • Enabling start and end dates for employees
  • Handling overtime and annual leave
  • Validations
  • Functions: INDEX, IF, IFERROR, ROUND, SUMIFS, MATCH, COUNTIFS, SUMPRODUCT
  • Using range names

Course structure

Course materials - click links below to download

 The session materials
  • a pdf manual which you can print out and make notes in
  • Excel file to work through during the session
Excel Payroll Budget PDF Manual
Budget_Payroll Excel File

Course video - 1 hour and 20 minutes

Payroll Budget Video

Course Quiz - how well can you do?

Check out your new found knowledge.
Excel Payroll Budget Quiz