Excel Yourself/Excel Budget Payroll 2024

  • $25

Excel Budget Payroll 2024

  • 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 2024 Level: Advanced Duration: 1.5 hours 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

  • Custom functions

  • Validations

  • Functions: IF, IFERROR, ROUND, SUMIFS, COUNTIFS, OFFSET, VSTACK, HSTACK

  • 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 2024.pdf
  • 589 KB
Budget_Payroll_2024_incl_Casuals_M365.xlsx
  • 919 KB

Course video - 1 hour and 26 minutes

Budget Payroll 2024 recording
  • (1h 26m 13s)
  • 429 MB

Course Quiz - how well can you do?

Check out your new found knowledge.
Excel Payroll Budget Quiz