We are please to announce that our most advanced Microsoft Excel course (course 309) now includes a training exercise on Macros!

You may recall we asked the question as to whether it is better to give a discount and accept prepayments or to charge your normal price and chase invoices and statements? Well, we got our Microsoft Excel expert to create a simple table that enables us to keep track of prepayments as well as incremental reductions from this prepayment.

This file is a great tool to keep track of how much credit a customer has if you decide to invoice them in advance. There is a way of accepting prepayments in MYOB and our MYOB expert and resident BAS Agent is currently putting a guide together on how to handle prepayments using MYOB. Using Excel  can be a handy replacement for using MYOB in this one aspect of your business.

Best of all, Karen created a short guide that we have added to the 309 course training manual which explains how to replicate what she created. Both the Workbook and the demonstration file that Karen created are now at the learning site.

Steve Slisar

Steve Slisar has been training people how to use computers since 1994, opened a training centre in 1999 in Dee Why and by 2005 had 3 training centres and created over 35 individual courses that include Screen videos with audio commentary, training workbooks for those who prefer to read to learn, and exercise files that are used with the tasks in the workbooks so you get practical experience in the software you are trying to learn. Now the creator of 5 of the most popular online MYOB training courses in Australia.

Recent Posts

Who is Melio? US payment provider that might become global because of Xero?

Melio primarily competes with other accounts payable and payment automation platforms, including BILL (Bill.com), Tipalti, Stampli,…

9 hours ago

Top 5 Things Small Businesses Must Do Before June 30 to Get Their EOFY Accounting in Order

As the end of the financial year (EOFY) approaches in Australia, small business owners need…

2 weeks ago

How EzyLearn Gets Xero Skills Into Your Brain (So They Stick!)

[A casual chat between two friends – Sam, a job seeker wanting to upskill, and…

3 weeks ago

Mastering Xero with EzyLearn: Building Confidence Through Practical Learning

In today's digital landscape, proficiency in cloud-based accounting software like Xero is essential for professionals…

4 weeks ago

Xero gives itself a 90% high distinction – users disagree

Have you seen the recent ads promotion 90+ % approval from their customers? The claims…

1 month ago

Intuit QuickBooks Course updates coming – features and navigation changes

Intuit is hunting for ways of helping their software become more relevant to Australian small…

1 month ago