Category: Small Business Productivity

Posted on by — Leave a comment

New MYOB Training Content available for all students

MYOB Training Course Bank Reconciliation Tutorial Screen

If you are enrolled into our online MYOB training course you’re probably aware of our LIFETIME access feature. You might also recall that this feature enables you to log in at any time and have access to any new or updated content that we create.

We’ve just created training video tutorials for our MYOB bank reconciliation course!

The training workbook for the bank reconciliation course contains a project where you can create a new company file from scratch, import an accounts list (Chart of Accounts), import transaction journals and then enter your own transactions to complete a bank reconciliation. It’s a very satisfying feeling!

Here is a list of the 9 new training videos we created. If you are a student you can simply click on each video, sign-in and start watching.

  • Section 1 Video 1 – Export and Import using MYOB
  • Section 1 Video 2 – Working with Read Only MYOB data files
  • Section 1 Video 3 – Exporting Accounts List and Transaction Journals
  • Section 1 Video 4 – Exploring Exported MYOB Accounts list Data
  • Section 1 Video 5 – Create a new training company datafile
  • Section 1 Video 6 – Importing an accounts list into a new MYOB data file
  • Section 1 Video 7 – Importing the Transaction Journals into a new MYOB data file
  • Section 1 Video 8 – Deleting duplicate accounts and changing linked accounts
  • Section 1 Video 9 – Setting Linked Accounts for GST

    •  

    As part of our continuous improvement process we are now hosting our videos on a dedicated video hosting platform and the videos can now be paused and played and you can enable them to take up the full screen for easier viewing.

    Happy Learning!

    To learn more about our online MYOB training course and the fantastic new features like LIFETIME membership, EzyLearn Q&A and more visit: http://ezylearnonline.com.au/courses/myob-training/

    [button link=”http://ezylearnonline.com.au/courses/myob-training/”] MYOB online training course[/button]

    Posted on by — Leave a comment

    Selling horse feed in the internet age

    We’re in the internet age whether we like it or not. Our internet connection is as valuable to us now as our power supply and our telecommunications and it’s important to have a website if you are in business. In this post I want to introduce you to a small operation in King Island in Tasmania. A company that sells Kelp is learning how to play the internet game and best of all you can learn with them.

    Kelli has a WordPress website hosted with 123ezy and we are building our WordPress and Webmaster Course around her growing internet presence. To start with we have created some elementary training videos about the navigation around the WordPress themes and what different parts of the website are called. We’re learning about themes, header images, menus and widget just to get started. As we progress we’ll be talking about Pages vs Posts, tags and categories, working with images, Search Engine Optimisation and much more.

    We’ve included our Introduction to WordPress video below so if you are reading this on your phone, click on the heading to get to our Blog page where you can watch the full video.

    Posted on by — Leave a comment

    MYOB Training Q&A: Printing Cheques using MYOB

    MYOB Training Online - Printing cheques
    Image of a cheque from http://www.afl.com.au/tabid/208/default.aspx?newsid=55721

    We recently introduced the EzyLearn Q&A service for our MYOB online training course students to give you more specific answers to your MYOB questions. The service is available for existing EzyLearn students only and there is no extra cost for this service. If you are an existing student and you need an answer to an MYOB question please feel free to use the service!

    One of our students in Perth is having some issues printing cheques and the bookkeeper for their organisation is being a little cagey with the information so we jumped in to help.

    In a nutshell you need to make sure that whether you create a cheque from the banking module or the Purchases module, you need to ensure that when your payment is entered that it is NOT marked as printed. So that when you do search for Cheques to be printed the one you want will show up.

    Keep the questions coming and stay tuned to the EzyLearn blog (register to receive them automatically) to see what MYOB Online Training students are looking for.

    If you are an existing student simply follow this link to see the Printing Cheques using MYOB training guide we created to answer the question. Just log in with your student login details.

    Posted on by — Leave a comment

    MYOB Training Course: We’ve identified problems

    MYOB online training course knowledge reviewsDon’t be alarmed, but we have identified problems. We’ve conducted some GAP analysis on our processes and realise that it is taking too long for us to assess the results of knowledge reviews.

    There are always ways that we can improve our business and the best way of finding out is by feedback from students who’ve actually completed the course. Like all good businesses we try hard to get better at what we offer and how we offer it and I’ve taken measures to ensure that our assessment issue is rectified immediately!

    Stay tuned for news about an addition to our team to handle student knowledge review assessments for the EzyLearn MYOB Course Certificate. We pride ourselves on having a very popular online MYOB training course that you can enrol into today and start by 5pm the next business day and now we are aiming to bring down the time for completion of assessment so that you can have your course completed, assessed and a certificate issued within 2 weeks. That’s our next goal.

    We’ve had some great feedback from students AND we are also listening to what they think we can improve. Here are some of the comments we’ve received from our MYOB online training students when asked about the best parts of our MYOB course:

    “…goes into fine detail of all aspect of MYOB”

    Sammar Kamar from Victoria

    “Liked the fact that I could know if I got the question right or wrong immediately.”

    Phillip Sayce from Queensland

    “..the convenience of being able to do it in your own time”

    Keira Page from New South Wales

    “It is all really good I couldn’t pick (the best parts) if I tried. I have tried to use MYOB in the past but it never made sense to me. But after doing your course it makes more sense. Thanks”

    Linda Matanovic from Queensland.

    Read what other students have to say about our online MYOB training course.

    The next improvement on our list is adding more detailed content to our Payroll Course. Oh, and you probably might already be aware, but existing students will have access to this new content for no extra charge because of our new LIFETIME student memberships that come with each course.

    Posted on by — Leave a comment

    MYOB Online Course Videos — Creating Customer Cards

    Click on the heading to view the image or video if you are receiving this via email.

    Creating customer cards in MYOB is easy! To enter a new customer, simply click on ‘New’; this will bring up a new window.

    It’s also simple to edit customers here. Say you want to change postal or contact details, simply click on ‘Customer’ and hit ‘Edit’.

    You will note that MYOB gives you a choice in the designation section to enter a company or an individual. All customer entries are stored alphabetically so make sure if you are entering an individual you use their last name first.

    You use the tab key as a shortcut to go through all the fields.

    A handy hint: When a customer has a longer address, such as a unit number or a Suite number, hold the Control Key and press ‘Enter’ for a second line.

    Also, if you have tabbed past a field you need, simply hold the Shift Key and hit the ‘Tab’ key to go up to the field above.

    Video Reference: 501204

    Link for existing students: http://myobcourse.com/elearning/mod/resource/view.php?id=359

    For information about our Online MYOB Training Course and new Lifetime Membership for all students, please visit: www.studymyob.com.au

    Please feel free to send your comments about this video to: sales@ezylearn.com.au

     

    Posted on by — Leave a comment

    MYOB online course videos – Company information & 13th period

    Make sure all accounting details are correct in the company details. You will not be able to change any details once entered and saved. So the rule here is check and double check all details are correct.

    Did you know that in MYOB there is a 13th Accounting Period? This is not another month but is an accounting period where you can make any accounting changes if needed.

     

    Video Reference: 501102

    Link for existing students: http://myobcourse.com/elearning/mod/resource/view.php?id=349

    For information about our Online MYOB Training Course and new lifetime membership for all students please visit: www.studymyob.com.au

    Please feel free to send your comments to us about this video to sales@ezylearn.com.au
    Unable to display content. Adobe Flash is required.

    Posted on by — Leave a comment

    Subscribe for free MYOB hints during June

    I’d like to introduce you to Frankie. She has been working with EzyLearn in an admin capacity and she going through some of our training material and writing a little bit about each video so that we can showcase what we have.

    Every week we are getting fantastic feedback about our online courses and we’ll share some of them with you. Remember if you haven’t tried online learning, our courses come with a money-back guarantee and LIFETIME membership.

    We’ll be releasing some of our MYOB Setup videos to help you setup your own MYOB Accounting company and data file. The videos we’re releasing are part of the training videos that are included in our online MYOB Training Course.

    Remember that our Online MYOB Training Course contains over 120 training videos, 5 hours of continuous instruction, 5 training workbooks that you can print and keep as a reference and knowledge reviews to test what you’ve learnt and guide you in the right direction for incorrect answers. Students who enrol now will also receive free membership to the course for the rest of their working life.

    Visit our website for more information and to enrol: www.studymyob.com.au.

    You can also stay in touch with EzyLearn and what’s going on my liking our new Facebook page: http://www.facebook.com/pages/EzyLearn/110111062349216

    Posted on by — Leave a comment

    Online MYOB training is better than just CD’s or workbooks

    In the evolution of our online training courses we originally started with a flash based player that operated in our training centres. It was easy to use and accessible on all computers. We then took a look at how to deliver the same consistency of experience using our training videos in your home, an environment that could be completely difference and that we have no control over. At first we thought about CD’s and after trying some different technologies, we came to the realisation that the experience different from user to use and computer to user. Will online learning really be the best way?

    One issue that we came across in delivering our courses online was whether customers have a good enough broadband connection to receive the relatively large videos files through to them. The other question we had was how long should students have access to the training materials. In the end, we decided to go as OPEN as we possibly could. We opted to use technology that would enable all students to access the materials, whether they were on a Windows based computer or Mac.

    The result is that you can now use our training material for life (no need to try to locate those scratchy CD’s) and you can use a combination of videos (with live demonstrations and audio commentary), Workbooks (with actual exercises you can try) and Knowledge Reviews (to test your skills) and it works on all platforms.

    See our online MYOB training course outline.

    [button link=”http://www.myobcourse.com.au/training/page_enrol.html”] Enrol into our online MYOB course[/button]

    Posted on by — 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: https://ezylearn.com.au/

    Posted on by — 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 by — 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 by — Leave a comment

    Learn Powerful PowerPoint in 4 hours

    If you are receiving this post via email click the heading to visit our blog and watch the free PowerPoint training video included.

    EzyLearn online Microsoft PowerPoint course
    Peter Costello using Powerpoint (from smh.com.au)

    Microsoft PowerPoint is a fun program to learn that gives your presentations structure and professionalism. We recently spent 4 hours getting a technical product manager up to speed with PowerPoint so that he can use Powerpoint slides to demonstrate his companies products to their dealer network. Geoff had used the program only sparingly over the years but the time had come for him to quickly get up to speed so he could look professional with his dealer network.

    In the 4 hour training session he had all the skills to create his own presentations from scratch, use company templates, create flowcharts and diagrams, charts and animations and even incorporate music and video into his presentations. He also had access to our online course and some course notes to keep as a reference.

    See our PowerPoint course outline and enrol into our online course, or make contact to organise a half day training session at your office or our training centres.

    If you want to subscribe to receive new blog posts in your email subscribe using the feedburner form on the blog page.

    Posted on by — 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 by — 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 by — 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 by — 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.