Webinar – Excel Payroll Budget

Price: $25 incl GST

Duration : 1h 30 min

This session uses the subscription version of Excel.

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 and could be scaled even further.

The session covers

  • Global input and assumptions
  • Handling oncosts like Super and Payroll Tax
  • Including pay increases
  • Includes Casuals
  • 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 dynamic array formulas
  • Using range names

Plus, as always, I will share extra tips along the way.

Date: 22/02/2024
Time: 1:00 PM AEDST
Event: Excel Payroll Budget - Subscription Version (1hr 30min)
Topic: Payroll Budget
Public: Public
Registration: Click here to register.