Ms-Excel with MYOB data

Learn how to use tools and reports in your MYOB software and Microsoft Excel to understand business performance

Move beyond simple compliance to discover key reports, ratios and indicators to help generate a snapshop of your business’ health.

Get up and running properly with MYOB and learn how to set up all the relevant accounts, GST codes and card files correctly. We show you how to load opening balances for debtors, creditors, stock and the bank. Also covered is the backup and recovery of data files and basic housekeeping.

You will learn how to..

• Use the Profit & Loss and Balance Sheet reports to analyse your business
• Customise your Accounts List to meet your business’ reporting needs
• Discover tooks in your MYOB software to track profitability in different areas of your business
• Set up and report on Key Performance Indicators using MYOB software and  Ms-Excel
• Understand key ratios and apply them to measure business performance
• Use MYOB reports and Ms-Excel to customise templates for targeted reporting
• Input your MYOB data into financial templates to enable you to measure business performance
• Recognise the difference between cash flow and profit and how to improve them

What you will get from this course:

• Opportunity to ask questions relating to your business during the course
• Small groups (maximum 12) to ensure attendees can participate
• 170+ page workbook to all of those who attend – great for later reference
• Certificate of attendance once course is complete
• Morning & afternoon tea

Pre-requisites

This event is hands-on and delivered classroom style. You need to have used Ms-Excel as well as have hands-on experience with MYOB software. Alternatively, you may have completed the MYOB course called ‘Day to Day Processers’

Enroll Now!

Price $350 + GST

Upcoming Courses

Opt-in to hear about upcoming courses and seminars on MYOB software:

Yes, send me that stuff!