Excel Training Quick Tip
We recently created an Excel spreadsheet to demonstrate how to calculate the amount of PAYG, Super, Medicare levy and Flood Levy payable by a company for it’s employees based on an employees gross yearly income. It’s an excellent example of using IF STATEMENTS and NESTED IF STATEMENTS.
You can change the gross annual income and watch all the other figures change automatically.
We’ll be using this information in our MYOB Payroll Training Course which will undergo a huge update this quarter. If you are a small business owner you can calculate your PAYG obligations on a spreadsheet and then enter the pay transaction as a journal entry or spend money in your MYOB software.
This Payroll, PAYG, Super excel file is now freely available to students of the Microsoft Excel Online Training Course, just log into Course 306 which covers IF STATEMENTS. Remember if you are an MYOB training course student you can enrol into our Excel training course for a discount. See the Course Outline for MYOB Day-to-Day (existing students only) for the details of how to claim your discount.
The one thing I've found fascinating in accounting and bookkeeping is watching technology companies try…
Is your name on this list? I want to thank the following students for choosing…
There are many finance professionals — who does your business need? Does your business need a…
Employers like small business owners are looking for staff online using Google. From office admin…
Most complete courses are now discounted. If you want to learn something new now is…
The features that each of these companies provide is invaluable for businesses. We can't do…