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:

www.ezylearn.com.au/schedule

MYOB Payroll – Employee Payment transaction video

The EzyLearn offer to MYOB students is simple. One price for access to all training resources (videos, workbooks and knowledge reviews) in a 12 month period including new updates. The MYOB Payroll course is part of www.myobcourse.com.au and it’s now ready for paying students to enrol. Included in this blog post is the 4th of 5 videos in part 1 of the course launched today.

This part of the course takes you through the sample company data file to highlight and explain how to navigate around and get information about employees, wages and other payroll categories, pay slips (Pay advices), pay cheques and other transaction information relating to Payroll.

If you are not already enrolled into the course you can choose the

  1. Full Access enrolment (no certificate), or
  2. Full Access enrolment (including assessment and certificate)

Enrol today!

Earn money with phone bill analysis and Microsoft Excel

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

What is a Remote Contractor or Virtual Assistant (VA)?

Software as a Service (in the Cloud)

woman using mobile to find job in payroll, accounts receivable or administrationWITH THE ADVENT of fast speed broadband internet, software programs that operate “in the cloud” and telecommunications that use your internet connection, there’s no wonder the Remote Contractor market is growing.

In the Cloud explained

What is in the cloud, you ask? Well, it’s just like Hotmail or Facebook or your internet banking; secure services that you use on the Internet from anywhere in the world.

It’s easy to access and you don’t need to bring your computer with you if you don’t want to. Even programs like MYOB are moving to the cloud with their online product called Live Accounts. It’s also an interesting time for these companies because new and nimble competitors have an opportunity to grab a market share; take Xero online accounting (New Zealand company) for example.

There are online customer databases like SalesForce which companies use to keep track of their customers and Skype that allow personal users to make calls to other Skype users for free. These services enable you to work from where ever you are and enable employers to validate that you have logged in and performed the desired work so opportunities are coming thick and fast for home workers.

Remote Contractors and Virtual Assistants (VA)

Remote worker, home-based employment, virtual assistants and even Mumpreneurs (working mums and parents starting their own businesses) are some of the terms used to describe this type of work. Some of the work available is paid hourly pay or payment for specific tasks. Of course, it’s an ideal situation for working parents who need to earn an income while caring for babies and young children. But it’s also fairly in demand.

Courses built around employment outcomes

If you’re going to invest time and money in study and upskilling, it’s a given that you want to earn more money as a result, whether that be locally or in your home office. Our online training courses are designed with job outcomes in mind — our cloud accounting software courses in MYOB, Xero and Quickbooks are designed by professionals working in the industry so they know what the requirements are.

Our training courses include real life examples mirroring the everyday occurrences of real world businesses, and its becoming increasingly common for businesses to outsource work tasks to contractors working from home (think bookkeeping, telemarketing, graphic design, social media, content marketing and sales work).

What you study in our courses follows the logical flow of the how everyday businesses are run. Bookkeepers are as in demand as ever, and our courses are designed to help you set yourself up as a bookkeeper, working in an accounting practise, for yourself, or for someone else’s business.

If you’re considering a local position as a receptionist, or in administration or clerical or you enjoy bookkeeping work and want to find a job in accounts payable & receivable and payroll, we have courses for all skills levels from beginners’ to advanced.

Find out more about how we will help you earn more money

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.

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: http://myobcourse.com/elearning/mod/resource/view.php?id=562. 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.

Navigate your way around MYOBCourse.com.au

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.

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.

Free MYOB Training Workbook

We’ve just completed our new and simple MYOB Day-to-Day workbook and I like you to have it for free. It is a significant step towards simple workbooks with big images and simple exercises and I’m so confident you’ll learn just by going through the workbook. If you do like it, please tell your friend or anyone else who needs to learn and feel free to pass it onto them. I’d also love to hear your feedback and especially stories about how your new found skills helped you get a job or some work as an independent contractor.

There are references in the workbook to the videos at our online MYOB training course so if you prefer to watch someone teaching you how to use the software as well as have a workbook with exercises, make sure you visit our online learning website.

Enter your details in the form below and you will receive the free MYOB Day-to-Day Transactions workbook (course number 502) AND enrolment passwords to access free training in Microsoft Word, PowerPoint and Excel.

We’ll also let you know about  new training materials and special offers like this one, but don’t worry about SPAM because the newsletter is fully anti-SPAM compliant and you can automatically opt-out instantly. Plus, we only send a message once or two a year. We figure if you like the workbook, you might also want to do the course, be assessed and receive a certificate.

See what topics are included in the free MYOB Day-to-Day Transactions training workbook?

Updated FREE MYOB Course

The FREE MYOB Training Course Samples are now available at the MYOB short course enrolment catalogue. Get your FREE MYOB Training Here.

Three MYOB courses for $29 per month for 4 months

Full access to myobcourse.com.au for 12 months is now available at the reduced price of $116 (paid off over 4 months). This is made possible by the new Installment Payment feature available on PayPal and you don’t need to have a PayPal account, you can use your credit card (even though PayPal make this process a little confusing to find).

The pricing has changed because we realised that not everyone wants a certificate at the end of their course, they simply want the skills on how to use MYOB on a day to day basis. Rather than simply give every attendee of the MYOB course a certificate just because they paid their enrolment fee EzyLearn students perform a bank reconciliation (and all the entries to make that possible) and email their datafile for assessment. This process of handling the datafile is time consuming and requires an experienced user to assess whether the tasks were performed correctly.

Our new pricing and installment plan is designed to make our course more accessible to a wider range of potential students who might not have the means to pay for it all up front. Visit the website www.myobcourse.com.au/elearning and look for the enrolment links at the right side of the website.

Half price online course in Microsoft Excel and MYOB with this voucher

With the changes that we’re making to our website it’s no surprise you can enrol into the Excel or MYOB online courses for 50% off (half price). We are upgrading our website using a fantastic community blog system call WordPress and if you receive this information via email, then you probably already know it. As a result we are able to combine many of our diverse services under one location and that includes the ability for you to purchase our online courses at discounted prices using discount vouchers.

Discount vouchers are simply a string of numbers that you enter into our shopping system to reveal a discount we are making this offer available to you until the end of this month. The discount voucher code that is available to you between today and 30th May is 888, and it entitles you to half price off our MYOB or Microsoft Excel courses. If you want to take advantage of the discount, go to our online training enrolment page and purchase an online course. Where you see the screen below, enter your code (888) and click update to see the new discounted price.

discount coupon for online training courses in Excel and MYOB
discount coupon for online training courses in Excel and MYOB

You might also be aware that we started a new opportunity for anyone to make promoting our online courses via a method called Affiliate Marketing. This enables you to promote a special code via facebook, email, twitter or anywhere that you can tell people about us, and if your friend enrols into a course after following your special link, you get $30! This system is managed by a completely independent company called clixgalore and if you’d like to learn more, visit our affiliate program page for MYOBcourse.com.au.

Stay tuned in the forthcoming weeks for information about ways that you can work from home using your computer skills as a remote contractor.

New (updated) MYOB training course workbook

It’s ready! The workbook for the MYOB 502 (day to day transactions) training course is now ready. This workbook now has a better flow from navigating around the MYOB screen, creating inventory items, purchasing products from suppliers, setting inventory item properties, paying bills, creating quotes, orders and invoices to receiving payments and making bank deposits.

This workbook has larger screen shots, better practice tasks and references to our online training videos. You can even use the workbook by itself to learn how to use MYOB accounting software.

The workbook is now available in the contents section of the MYOB 502 course. If you are enrolled into the course, you can simply click this link to see the workbook: http://myobcourse.com/elearning/mod/resource/view.php?id=303

Using Google Adwords – Step 1 – choose a budget

The Google Adwords market is constantly changing depending on who is bidding for the keywords you want, how they are bidding and how much they have to spend. Keeping this in mind you will have to make some simple decisions before you can get started.

I sat down with a business owner today and she wanted to bid for every keyword she could think of, everything relating to her field of business, but the problem with that is that you are then competing with everyone else for a whole lot of words. We ended up choosing fewer words and decided to spend more to get people to our website using those keywords. If website visitors who come to your website from a Google Adwords advertisement and stay and explore your site Google will recognise your site as a good result for its searches and this will end up elevating your position in the “relevancy based” search results. That should be a significant goal, but I am now just digressing.

So, the business owner agreed that she was going to spend $1200 per month. The next step is to figure out which services she is going to promote and she gave me a list of 15 different services,which we then categorised into 4 main categories… Phew. We then looked at the relative weighting for each category of her business to decide how much they will receive of the $1200 per month and it came to a relatively simple 25% split each or $300 each category (division) per month. These were good figures because that comes down to $10 per day and that is how you can limit the amount of money you spend on Google Adwords…. by setting a daily limit.

The next step is a little more time consuming and involves choosing the right keywords and keyphrases to use for each category of the business. Once you’ve discovered this you choose how much you are willing to pay per click… hence the term Pay-Per-Click (or PPC) advertising (adwords.google.com). You may not get this part right the first time, but you will soon realise that you can pay for anything from 9c to over $20 per click to be on the first page. The more generic and popular the keyword the higher the price, the more words you combine together (keyphrase) the fewer people will be promoting it so the price will be lower. I’ll cover this in another blog post.

UPDATE:

Learn about alternatives like using relevant keywords in a blog for your business to make your website more valuable and ensure it becomes a trusted resource for customers.

MYOB training courses scheduled for Chatswood and Burwood

workbooks and videos for MYOB training coursesAnnouncing: EzyLearn and Maxis Solutions (RTO 91428) have just released the training schedule for courses in MYOB Accounting for Day to day transactions in both Chatswood and Burwood. These courses are scheduled conveniently during school hours of 9.30am to 3.30 so that mums can attend and get full value out of their day.

These courses cover the Sales, Purchases, Inventory and an introduction to the Banking modules of MYOB Accounting. If you don’t have the software there is a link to the freely downloadable Test Drive software that you can use to practise what you learn on your home or office computer.

The Topics in more detail are:

Creating quotes, orders and then invoices in the sales system, changing item information and credit terms “on the fly” while you are creating an invoice. Understand the different invoice formats, including time billing, how to create and delete text headings and more.

Finding historical transactions is a major part of accounting software. In this course you’ll learn about the Sales Register, Sales Journal, To Do list, Accounts Receivable and Payable reports and Custom lists, plus an introduction to Statements so that you can supply your clients with a summary of funds owing to you. You also learn about the two main type of statement so you can choose the one that suits your needs.

This course also includes recording cash sales, entering credits, settling credits, how to deal with bad debts, deleting sales payments, and reversing credits.

Payments: You’ll learn how to enter invoice and purchase payments including part payments and over payments.

Purchases: You’ll learn how to keep track of your purchases whether you pay for them straight away or receive an account. You will also learn how to create a purchase order, converting it to a bill, creating an item credit, settling and reversing credits, and analysing purchases.

Banking: If you make purchase or income transactions that have nothing to do with the sales or purchases modules, then you’ll learn how to make these entries using the banking module.

There is an early bird rate so visit the ordering site and book early to save money.

We closed our last training centre in 2006 and have taught thousands of students how to use MYOB accounting software since then because we offer

  1. All courses for one price,
  2. Training on various versions of the software,
  3. Training videos combined with knowledge review questions,
  4. MYOB Course Workbooks that act as an MYOB bookkeeping induction
  5. We’re accredited by the Institute of Certified Bookkeepers
  6. We offer a money back guarantee.

Discover more reasons to choose EzyLearn for your MYOB Training Courses.

We’ll notify you when we create a new training video?

I’ve had a Feedburner account (part of Google) for a year and never really understood the benefit of it until now. When you set feedburner up you tell it the RSS feed address of your blog and it keep track of every new feed that you create (or article that I write). That is all good and well and FeedBurner has been working hard to keep track of all the articles and sales texts I have been writing but it never really did anything, until now.

You might notice a little “subscribe now” box at the bottom of every post? If you enter your email address, you’ll receive an email which contains the details of each new post that I write from this website. It is a great way to keep informed through your email about what is going on at EzyLearn. Now is especially a good time to subscribe because I am scheduled to start creating our Excel 2007 and MYOB Payroll training videos for our online courses very soon. I plan to upload each video to this site so that I can get your comments and feedback about the contents and exercises to learn the new skills.

Subscribe now and you’ll be kept in the loop. You might also want to follow us on twitter, this post is automatically added to Twitter as well 🙂

New MYOB training video “email default preferences”

Emailing invoices is commonplace today and the benefits are numerous: The arrive quicker, recipients can print them if they choose to or save them as a file and there is more certainty that they get delivered and not “lost in the mail” http://bit.ly/a6aDTG

You may be aware that the ability to email invoices from MYOB has been available for years and what an empowering experience that was, the first time we did it at EzyLearn. You may also know that there are default email subjects and messages for the quotes, orders, purchases and sales invoices that you create and send to your clients. We’ve created a new video to show you how to change and manage these default email message preferences.

The great feature about default messages is that they make your business look professional and show consistency while providing important information to your customers with each invoice.

We’ve included this video as part of our Day to Day course and it is available for no extra charge for existing students who’ve enrolled within the last 12 months.

Check it out. You can follow the link below (then use your student account login details to gain access to it), or browse through the contents of the Day to Day course and locate video number 502307!

Here’s the link: http://bit.ly/9kKK0B

Enjoy