Excel Yourself/Excel Budget Payroll - 2023

  • $25

Excel Budget Payroll - 2023

  • Closed
  • 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 & can be scaled. Version: Microsoft 365 Recorded: Feb 2023 Level: Advanced Duration: 1 hour 15 min 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 M365 2023.pdf
Budget_Payroll_2023_incl_Casuals_M365.xlsx

Course video - 1 hour and 19 minutes

Budget_Payroll_2023.mp4

Course Quiz - how well can you do?

Check out your new found knowledge.
Excel Payroll Budget Quiz