Posted on Leave a comment

Online MYOB training for New Zealand students

We’ve had some inquiries and enrolments from New Zealand students and this blog is to help you understand some fundamental differences between Australian and New Zealand versions.

The first thing you need to be aware of is that the knowledge review questions used in our MYOB Payroll Introduction (course 505) use the sample company file which comes with the free MYOB Test drive. From discoveries made by our New Zealand students the sample file contains different information in different countries. You need to use the Australian version to get the correct answers.

This brings another problem, when you try to download the Australian version of the test drive you need to enter a phone number. One of our students entered our telephone number as the contact number and we have no problem with you doing that if you are an EzyLearn student. If we hear something different from MYOB we’ll let you know.

I should also mention at this point that this might also apply to our students from Canada, China, Korea, UK and other parts of the world.

If you want to take a look at what students have said about our course click here.

If you want to receive these updates in your email, subscribe to the EzyLearn blog here:

Posted on 1 Comment

How did you go in the MYOB skills test?

Answer Stats for MYOB online training course free public skills test

We recently made a quick MYOB skills test available on our website to coincide with the launch of our full online MYOB training and assessment tools and the result from over 3000 website visitors showed some very interesting information. The average score was 44.74, with the bulk of students receiving between 31-70%.

Most fascinating was that less than 10% of all attempts managed to get the first two questions right! These questions related to what options are found in the command centres.

Tests are a great way to highlight learning outcomes of a course while providing links to the exact training material you need to provide the correct answer and our online MYOB training course includes 9 knowledge reviews covering the Day-to-day operations of a business, bank reconciliation (which if completed successfully allows you to complete your BAS in less than 5 minutes) and Payroll Introduction.

Posted on 1 Comment

MYOB Training Course and the Institute of Certified Bookkeepers

MYOB online training course - Institute_of_Certified_Bookkeepers

MYOB online training course - Institute_of_Certified_BookkeepersWhen you enrol into our Online MYOB Training Course from today onwards you receive LifeTime access to all training materials to use as resource after your initial training (this also includes new training materials that we create) AND you can become a member of the Institute of Certified Bookkeepers at half the normal price.

We are working hard every day to give you the skills and certification to be a confident MYOB software user plus give you tools to improve your professional profile for business development or career development.

Take a quick quiz to test your MYOB skills.

If you are ready to enjoy the benefits of being an EzyLearn student, enrol now online and start by 5pm tomorrow afternoon (next business day).

Posted on Leave a comment

Advanced Excel: eliminating errors in functions

Microsoft excel online training course

Forward this email to your friends so they can subscribe themselves. Click on the heading to visit the EzyLearn Blog

One of the most efficient features available in Microsoft Excel is the ability to create a formula and then copy it into a large number of subsequent cells. When you perform a dbroad copy and paste like this, Depending on the type of data, you’ll get either a #DIV/0 or a #VALUE error if the source cells don’t contain the correct data. You could scan the spreadsheet manually and modify each cell that contains such an error or use the IFERROR function when creating your original formula.

The IFERROR function is composed of two parts – the original function that you wanted to create (such as dividing two numbers) and a value to use when this function doesn’t make sense (like trying to divide by 0 or a word).

Let’s take a basic table of data that contains three columns. The total amount of a restaurant bill is in the first column, and the second column is comprised of the number of people in the party that received the bill. In the third column, we want to calculate the price per person.

Advanced Excel Functions - IFERROR - online Excel course

Task: Use the IFERROR function

(1)     Create the spreadsheet above using the data in columns A & B.

(2)     Perform a simple calculation to divide the Total Price by the number of people to get the answer in Colum C

(3)     Notice the error messages

(4)     Click on cell C2 and type the following function =IFERROR(A2/B2,”Unknown”)

(5)     Use the fill handle to copy it down the column. Notice that where-ever the error normally occurred; it has been replaced by the word Unknown.

(6)     This time try =IFERROR(A2/B2,””) and notice that the cells where an error occurred are now showing no value.

If you’d like to participate in our online Microsoft Excel training course visit this link.

Want to do a course online but not sure how online training courses work?

If you want to have a group of people trained in your office or our training centre call us on (02) 9971 0000 or visit our online schedule to enrol into Class-Based Training in Chatswood, Sydney.

Posted on Leave a comment

Advanced Excel Tip: IF Statements

Advanced Microsoft Excel Training Course - Sales Commission IF - intro

Advanced Microsoft Excel Training Course - Sales Commission IF - intro

IF Statements are what is called a LOGICAL test, such as is this value larger than this, if true do (or display) this, if false then do (or display) that. IF statements can be used for a lot of different things and all of them save you having to manual go through the data and perform the calculations themselves.

These are some examples of how IF statement can be used:

= IF (Question eg B17>B16, do this, otherwise do this)

OR, if you want to show text

=IF(Question eg B17>B16, “Text if correct”, “Text if incorrect”)

OR if you want to perform a calculation

=IF(Question eg B17>B16, if yes multiply sales by 2%, if not multiply sales by 1.5%)

We’ve attached the file that we used to create the image in this blog post so you can open the file and see the formulas that we have entered into cells D7 and E7. Click on each cell to see the formula. See if you can duplicate these values down each column.

Excel exercise file: Sales Commission IF – Intro

If you’d like to participate in our online Microsoft Excel training course visit this link.

Want to do a course online but not sure how online training courses work?

If you want to have a group of people training in your office or our training centre call us on (02) 9971 0000 or visit our online schedule to enrol into Class-Based Training in Chatswood, Sydney.

Posted on Leave a comment

Want to work at home for EzyLearn?

remote contractor and virtual assistant group

remote contractor and virtual assistant groupWe are building the Remote Contractor network of work from home contractors and at the same time, we are recruiting for online marketing consultants. You don’t have to be an expert though, simply go searching through Australian job forums, social networks (on Facebook) and comments on Twitter accounts where you think it would be good to mention EzyLearn’s online courses.

All you need to do is open up and Excel spreadsheet, and copy and paste the hyperlinks of website forums and social networks (like facebook groups) into each row of the spreadsheet.

We’ll go through the list you create and if it looks like a good list, and we pick you as an EzyLearn online marketer, we’ll pay you to inform the Australia jobseekers about our online courses. Simple.

Have any questions? Send an email to Richard at

Posted on Leave a comment

Are MYOB skills good enough to be a bookkeeper?

MYOB bookkeeper with Cert IV in Bookkeeping

MYOB bookkeeper with Cert IV in BookkeepingAccounting in the past

I remember the days when MYOB was a young company called Data Tech Pty Ltd, they were based in Crows Nest and gave trials of their software on floppy disk and videos on how powerful their software was on VHS. It was also an awkward situation if you wanted to become “certified”. Many people learnt how to use the software and offered their services and it wasn’t until you had a couple customers under your belt that you could become certified by MYOB. This scenario is now very different.

Education businesses around Australia (and New Zealand) now have strict guidelines to follow when they deliver and assess their training (as part of the Cert IV in Training and Assessment) and there’s a whole new official language which includes: Scope of Registration, Units of competency, Learning outcomes, competency mapping, Core subjects, electives, qualifications, subjects etc. The great news is that we are now “mapping” our training material with the outcomes for the Cert IV in Bookkeeping!

This qualification will be mandatory by 2013 if you plan to perform bookkeeping tasks for a business whether you are an employee, contractor or a small business owner.

In fact to give you an idea of how specific and focussed this new qualification is here are the electives (based on your desired goal):

Contract Bookkeeper
• (FNSICCUS401B) Deliver a professional service to customers
• (FNSICCUS402B) Maintain customer relationship

Small Business Owner
• (FNSICORG510B) Manage own professional development
• (FNSPRAC501B) Manage and maintain small/medium business operations

Permanent Paid Bookkeeper
• (FNSICORG510B) Manage own professional development
• (FNSICCUS402B) Maintain customer relationship

Are you a BAS agent?

You might also be interested to know that “If you provide BAS services for a fee or other reward, you are required by law to be registered as a BAS agent” with the ATO.

Our offer to students

We recently announced the Lifetime MYOB course student membership for all students so you can use our learning resources (including updates as they are created) and now we are happy to inform that we are mapping our training material to the desired learning outcomes for the subjects which make up the Cert IV in Bookkeeping. We’ll be working closely with an RTO (Registered Training Organisation) in a VET partnership and we’ll be able to help you get some fundamental MYOB and accounting skills via our online course, PLUS provide you with a pathway to your Certificate IV in Bookkeeping (including assessment and certification).

Visit out MYOB course website or enrol as a student.

Make sure you subscribe to our blog to receive these articles in your email. If this has been forwarded to you, click the title of the blog post and subscribe at our website.

Posted on Leave a comment

How much do you know about MYOB?

MYOB Quick free skills test and training

MYOB Quick free skills test and trainingTests are an excellent way to master new skills. If they are created with a learning outcome in mind they force you to answer based on your current knowledge and then provide you with an explanation of what the correct answer is and where you can go to find more.

We’ve recently updated our online MYOB training course to include over 80 knowledge review questions covering most aspects of operating MYOB software on a day to day basis. For each question we provide you with the correct answer and information about where you can go to review your knowledge and get it right the next time.

You’re invited to attempt a quick MYOB skills test to see how much you know.

Posted on Leave a comment

Microsoft Excel 2007 & 2010 Training – menus and ribbons

If you are receiving this as an email, click on the heading to see the free training video at the EzyLearn blog.

Microsoft Excel is still the worlds most popular spreadsheet program by a long shot. I’ve used Google’s spreadsheet and it is a fantastic tool if you want to access or share a spreadsheet online but it’s still not the same as using Microsoft Excel and with the prices becoming quite competitive and Microsoft offering new ways of sharing Microsoft Office documents in “the Cloud” it is still easier to use what you know, ie. Microsoft Excel.

We are in production of our 2010 Microsoft Office training videos as part of the beefing up of our online training courses and this videos is one of the new batch covering fundamental tools in Microsoft Excel 2007/2010.

If you wish to learn how to use Microsoft Excel at a beginner or intermediate level, Steve who created the training material will be teaching at Maxis Solutions training centre in Chatswood in February.

Are you new to online training courses? Check out our brief tour on how online learning works.

Posted on 6 Comments

LIFETIME membership for MYOB online training course

OldCoupleInLovebyErikclitgaad - lifetime MYOB and Excel training course We use the EzyLearn Blog to announce improvements, additions and updates to existing courses and training services and today we announce LIFETIME access to students who enrol into our MYOB Training Course from today onwards. This feature will be introduced to our other courses during the year.

It’s finally here. We’ve made some improvements to our MYOB Training course during the New Year period and are thrilled to announce the latest and greatest feature in online MYOB training. “Lifetime membership” for our online MYOB training course.

Lifetime membership means that after you have completed your course you are free to use the training site as a resource for the rest of your working life! As new content and online learning resources are created, you will have access to these resources for no extra charge.

If you agree with us that this offer is amazing share it on Twitter or Facebook and tell your friends. Otherwise head over to our online training course website to learn more about what we offer OR test your MYOB skills using our free MYOB online training skills test.

EzyLearn: That’s how easy it is.

Posted on Leave a comment

Steve training Excel and MYOB in December

If you are located in Sydney and want to attend an MYOB Day to Day Transactions course or Beginners Microsoft Excel 2007 before the festive season begins, you are in luck. Steve, who has created most of the EzyLearn content for computer software training is the trainer for the upcoming Excel and MYOB courses at Chatswood training centre Maxis Solutions.

Steve will use his humour and years of education experience to make the the learning of these software programs as simple and as quick as possible.

The one day courses are usually held on a Wednesday and you can enrol online using their secure and automatic enrolment service. Click the link below to enrol:

Posted on Leave a comment

Earn money with phone bill analysis and Microsoft Excel

phone bill analysis example 2 - virion
phone bill analysis example - virion
phone bill analysis example - virion

One of the benefits of a spreadsheet is you can use a reasonably complicated spreadsheet over and over. One person goes to the effort of creating a spreadsheet and millions of people could potentially use that spreadsheet for a similar purpose.

The people at virion business grade voip have put a spreadsheet together to make it easier for them to perform price comparisons for their customers. The virion prices are fixed into the spreadsheet so all you need to do is enter in information about the costs on your phone bill and hey presto, phone bill analysis showing potential savings.

virion operates a distributed business model using “cloud based” software to manage and promote their business. Cloud computing is where your software operates over the internet, just like your banking and email applications like Hotmail and Gmail. Even powerful companies like MYOB are facing competition from cloud based solutions which are smaller, nimbler and more in tune with early adopters of new technology.

As part of the virion distributed business model they are seeking the help of remote contractors who are interested in earning money performing price comparisons for people they know as well as from leads provided by the company.

If you are interested in performing these tasks and earning money while working from home register as a remote contractor for further details as they come to hand.

If you want to take a look at the Microsoft Excel file that virion voip use for the phone bill analysis, please see the attachment to this blog post. Call Cost Comparison Spreadsheet v5 – RC

Posted on Leave a comment

Upgrading the MYOB data file for MYOB AccountRight Plus 19

You can’t have your old data file in the location where you’d like to put it. In AccountRight Plus 19 (the upgarde for MYOB Accounting Plus v18.5) the folder where all the files are stored is located at C:\Plus19.

The Training_Company exercise file used in our MYOB Bank Reconciliation course (#503) uses a datafile created in MYOB Accounting Plus v18 so it needs to be upgraded if you have downloaded the latest version. You can upgrade the file using the special program (found under the start menu) or by simply trying to open the file using the program.

This video takes you through the upgrade process. Click Here to see the elearning website, scroll to the bottom and you’ll see the topics covered in MYOB Bank Reconciliation 503. If you wish to enrol into the course you can enrol at the website mentioned above of visit our online ordering site for online courses by clicking here.

Posted on Leave a comment

Downloading the MYOB Training Company data file

There is an exercise file used in our 503 – MYOB Bank Reconciliation course called Training_Company.MYO. This file is accessible via this link if you are a student: This file contains a nice simple collection of data and after you have completed the step-by-step exercises the bank reconciliation process is nice and simple.

We’ve used Google’s new Internet Browser called Google Chrome (which is very fast compared to Microsoft’s Internet Explorer), to show you how to access this datafile and get it onto your computer. This data file was created using MYOB Accounting Plus version 18 so if you are using a more recent version of the software you’ll need to upgrade the datafile using the upgrade assistant.

Posted on Leave a comment

Navigate your way around

I recently started a topic in a finance course I am doing with Kaplan Professional to discover that this tertiary qualification I am studying is done completely online. That means watching powerpoint slides with audio, reading a workbook and having access to an online forum if I have questions. Even the assignment task is submitted online and results received via the online learning portal.

My first thought was how interesting that a well reputed education institution stops having lectures altogether and I was a little disappointed that I wouldn’t have an opportunity to meet my fellow students and share stories and ask questions. After using the learning tools however I have come to the conclusion that the tools themselves are very useful and it re-affirmed our online training goals here at EzyLearn to become the number one source of online training in Australia for employment and productivity for small to medium businesses.

We have received help requests of how to get around our online learning websites so the video in this post is designed to give you a quick demonstration.

The production of the next MYOB course (MYOB Payroll) is underway and you’ll get a change to see these videos for free if you are a subscriber to this blog. This video is a small taste of the many more to come. Please feel free to comment or share this blog post with your friends. To visit the online MYOB course website, click here.

Posted on Leave a comment

All MYOB courses now sold separately

The people who want to use MYOB on a day to day basis don’t necessarily want to learn how to set it up from scratch or customise MYOB forms. This task is commonly performed by a bookkeeper or accountant and perhaps in the case of a micro business (or a sub contractor) by the business owner themselves. To accommodate the specific needs for business owners and employees alike, EzyLearn has changed the enrolment options for its online MYOB courses.

Late in May 2010 we introduced an Installment Payment option using PayPal for students who wanted to learn how to use the program but didn’t require a certificate, which reduced the cost considerably. Now you can enrol in each of the individual courses separately and for an amount that is very affordable.

It’s coming close to end of financial year and this is the best time for small business owners to learn how to use and eventually implement MYOB as their accounting software. It’s the best time to do the MYOB Setup Course that provides you with the software skills to create a new company from scratch and set it up for daily use. Click here to visit the online elearning website and see the outline of topics included in the course. This link also provides you with a Pay Now option to get started straight away.