Category: Small Business Productivity

Posted on by — 1 Comment

Live Excel Pivot-Table Stats: self-paced learning versus class-based training

Excel Course 308 - pivot table value field settings for intermediate to advanced Excel training courseWant to see some live data from when we operated our Sydney-based training centre? We conducted courses for Absolute Beginners (we call it Computer Learners now), Microsoft Word and Excel, MYOB Accounting software for bookkeeping and others. We also offered different start times and different methods of delivery including self-paced (which has evolved into online) as well as class-based training courses.

The data in this free Microsoft Excel training video is taken from our student enrolment database the same year we created our first training videos. We created these videos to make them available to students who couldn’t fit into a schedule or wanted a more personalised training experience. Want to learn more about my fond journey in computer training? Feel free to also subscribe to my small business blog while you are at that site.

If you are reading this as an email, click on the heading to get to our blog site and enjoy the free training video about Pivot Tables using Microsoft Excel (the exercise file is provided in our Excel Training Course) and shows live data of enrolments for that year. We used a pivot table to find out:

  1. The popular courses,
  2. The popular training methods
  3. The popular start times for courses.

Can you see in the video which year the data is from? Back then we had experienced trainer like Maria Landrelli and Marie Diblasio to deliver our popular MYOB Day-to-Day courses to find work as a bookkeeper.

< !>

Posted on by — 1 Comment

Do you need more customers, more people, or more time?

Professional bookkeeper and online WordPress training course and hostingI was going through our EzyLearn blog library of articles today. In doing so, I was reminded that we started blogging back in 2007.

This was one year after we closed our three Sydney-based computer training centres to focus solely on online training courses.

After reading some of the old posts, I again realised just how much work is involved in maintaining a blog!

The Necessity of Blogging

When I analyse the workload of the EzyLearn team members and the hours we spend creating step-by-step training workbooks, training videos, knowledge reviews and assessment tasks, I realise that it is all very necessary.

Back in 2007, blogging wasn’t new. In fact, many people had heard of it but most small businesses (or large ones) weren’t really doing it much.

We at EzyLearn wrote a workbook to teach people how to use WordPress and it highlights one of the most important parts of being a training organisation. This being, to study what is new and understand how it will affect businesses and employees that use technology into the future.

This blog you are reading right now is read by a lot of other people and it highlights:

  1. Our commitment to keeping you informed
  2. The range of skills our team has
  3. The number of customers who come to us as a result of reading this blog

Why Blog?

Why am I talking about this? One of our most popular online courses is the MYOB Bookkeeping Course and a lot of people who complete this course want to start their own business.

These same people are keen to build their customer base enabling them to work their own hours, use their brains and earn a good living.

Having a website with built-in blogging functionality based on the WordPress Content Management System is a fantastic way to tell people what you know and drum up new customers. It enables you to keep in contact with people, keep giving them information with no strings attached, and remain top of mind.

Blogging and “content marketing” just takes a bit of time to learn and then keep up to date, but you’ll end up with more customers and won’t have to pay for Google Adwords! 🙂

Read more about why we do content marketing

Posted on by — 1 Comment

New Macros in Excel Course to handle prepayments

Excel Macros in advanced Microsoft online Excel Training courseWe 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.

Posted on by — 3 Comments

EzyLearn MYOB students now get free membership to the Institute of Certified Bookkeepers

Accredited online MYOB training course and support institute of certified bookkeepersIf you are learning MYOB because you want to become a bookkeeper you should know that the bookkeeping industry is undergoing huge changes at the moment and that you need to be aware of these changes.

One of the best ways that any person or company can keep up-to-date with changes in an industry is to participate in continuing professional development training and by joining an industry body. EzyLearn is a member of a number of professional associations including:

  • Australian Institute of Training and Development,
  • Australian Web Industry Association, and the
  • International Coaching Federation

We are also an Accredited Training Provider of the Institute of Certified Bookkeepers. This industry group ensures that all industry participants abide by professional standards and we are also thrilled to announce that as of today all EzyLearn MYOB course students are eligible to join the Institute of Certified Bookkeepers as a student member for free (normally $75)

The forms to access this free student membership have been updated in our learning platform so please feel free to log into your course and get your free membership.

Posted on by

MYOB Day-to-Day course now available separately

Receive-payments-using-MYOB-training-courseUp until now we have sold all our courses as one package because we felt that that is what everyone wants. Guess what? A lot of people did and still do love it, but we found that a lot of people just want enough skills to get then a job performing data entry tasks using MYOB. For this reason we’ve made that course available.

The MYOB Day-to-Day course is still a full days worth of training on the Sales, Purchases, Banking and Inventory modules. The workbook in that course takes you through the process of a company ordering products from the wholesaler, receiving the stock and then selling that stock combined with the services they provide to their customers. Along the way, there are part payments, full payments, Accounts Receivable reports, sending of statements and much more.

The new individual course is available with 12 months access so that we can provide a great resource with up to 12 months to access it when you need to. MYOB Day-to-Day training course includes all the topic in course 502. See what’s included in the MYOB Day-to-Day Course.

If you are interested in this new low cost online MYOB training course option, discover the price for this an our other online training courses at our enrolment page.

Posted on by

Is it better to repay your debts or prepay with discounts?

Microsoft Excel prepayments online training course and MYOBThe recent bad news about MYOB AccountRight 2011 demonstrates the risks involved when you borrow money for any venture (MYOB have a $575M loan that they need to repay). The money needs to be paid back and luckily you can use MYOB software to keep track of what is owed to you. It also brings up the question of rather than having a debt to repay can you pre sell what you do (at a large discount)?

We are asked many questions in our MYOB online training course support service we call “EzyLearn ANSWERS” and one of the recent questions was “what is the best way of keeping track of Prepayments”. We took the question to our Registered BAS Agent and MYOB Tutor as well as our Microsoft Excel Expert and we’ve come up with two scenarios, one using MYOB and one using Microsoft Excel.

What is the best solution?

You could use MYOB to handle pre-payments, or you could use it as a simple track of the lump sum payment you’ve received into your bank account and use Excel to enter the day to day information about how and when that prepayment is used.

We’ve created an Excel “Handy file” for you and we’ve putting the finishing touches on the workbook that explains how to do it using both Excel and MYOB so stay tuned to this blog or subscribe to receive these blog posts via email as they are published.

Need something created in Excel? Enrol into the online Microsoft Excel course and use EzyLearn ANSWERS to put it to our Excel guru.

Posted on by — 1 Comment

Are you a mum returning to work? Receive an instant discount coupon!

mums returning to work online training courseOur online training courses help people gain new skills and keep job seekers up-to-date with software so they are confident in job interviews. They also provide skills to create their own resumes.

Our training includes

  • website design and blogging using WordPress,
  • office administration using Microsoft Office and
  • bookkeeping using MYOB

We believe we have the best solution for online training in Australia but we always want to be certain by understanding  what students want in an online training course.

Features like training videos, knowledge reviews, LIFETIME course access, Tutor Support and Student Community enable students to immerse themselves in the training and make it less stressful. After all, who does a course because they enjoy it? We all know that structured learning is something we do because we have to if we want to get ahead!

Complete the Training Course Needs Assessment and receive an instant discount for one of our online training courses. Tell us what you are looking for and be rewarded. You can forward the reward to someone else if you don’t need it now.

Posted on by

Do you pay yourself but don’t use the Payroll feature of MYOB?

Australian Taxation office ato logo - payroll myob bas paygSometimes we use the EzyLearn Blog to inform readers about general course information. Today we’re announcing a new exercise file that is included in our Microsoft Excel Course 308 (which covers Macros) as well as the MYOB Payroll Course.

If you are a small business owner and you only have yourself or a handful of employees you might come across the dilemma about how to keep a record of payments you’ve made to yourself so that you can pay the correct amount of PAYG, Super etc. If your business is only small you may decide not to purchase and use the full MYOB AccountRight Plus version of MYOB accounting software and opt to keep Payroll records separately or in an Excel spreadsheet.

In a previous post we mentioned that one of our course content creators was working on a spreadsheet to help with PAYG and Super calculations for BAS reporting. Well it’s now ready (AND there’s more to come).

The Excel spreadsheet we have created enables you to enter the total amount that you have paid to an employee (or yourself) and calculates the PAYG and Superannuation that is payable for that amount (you can adjust the superannuation rate). All you have to do now is enter the payment into MYOB and your compliance is assured.

This file is handy if you pay yourself irregularly or differing amounts as you need it. Using this PAYG spreadsheet you simply enter the total amount you’ve paid yourself (or an employee) over the quarter and it finds how much you need to pay in PAYG and Super.

This excel file uses the VLOOKUP command in Microsoft Excel and the tax tables for weekly pay at the ATO website. If you are an existing student you’ll find the exercise file in the Excel 308 course (under the heading Handy Files). This course covers 3D formulas, CHOOSE, VLOOKUP, HLOOKUP, MATCH and INDEX, nested functions and how to protect worksheets.

Did you know that when you enrol into the EzyLearn online Microsoft Excel course that all levels are included for the one price? This also includes access to new content as it is created and you have lifetime access.

 

Posted on by — 1 Comment

What do you want in a training course?

Dr Evil - Need the info - what do you want in an online training courseSometimes we use the EzyLearn blog to learn more about what you are looking for in a training course, particularly if you have not done a course with us before. As a thank you for sharing your opinions with us you’ll receive a discount coupon for one of our courses and updates about special offers.

We’ve assembled a simple Course Needs Assessment to understand what you are looking for. With online training courses and support for MYOB bookkeeping software, WordPress website design and blogging software and Microsoft Office, we cover a wide range of topics.

Our courses are for:

  • Job seekers,
  • Those already in a job and
  • People seeking skills to operate their own business

Each category of student has slightly different needs and we want to make sure we are catering for your training needs.

Complete this brief questionnaire to join the “specials” list and receive a discount coupon code for one of our online courses.

Posted on by — 1 Comment

Statement of formulas for calculating PAYG amounts to be withheld

PAYG withholding Scale 7 for weekly wage payments for online MYOB training course and supportThe MYOB Payroll Training Course is in stage two of development. The contents of our existing Payroll course give students an introduction to how to navigate around and get fundamental information about the payroll environment in the sample company file. As part of our constant improvement process we are developing payroll scenarios as exercises for our students. This new content when published will be available for all existing Payroll Students and all those who have enrolled with the LIFETIME training course Access option.

Which table to use?

The ATO release papers that provide you with the information you need to perform your calculations regarding PAYG, super etc. In this blog post we look at Schedule 1 Pay as you go (PAYG) withholding NAT 1004. If you take a look at table 7 on page (see diagram on this page) you’ll see the variables or what the Australian Tax Office call coefficients.

New Spreadsheet for Excel and MYOB students

One of our content creators is in the process of creating an Excel spreadsheet as a simple tool to help you work out how much PAYG tax and super you owe at the end of quarterly BAS reporting period. It’s a tool that we will offer both Microsoft Excel and MYOB Training Course students when it’s ready. And no, before you think of asking, it won’t cost you any extra money to receive it. It’s available as part of our LIFETIME student access.

Posted on by

Hello to New Zealanders

New Zealander users of MYOB accounting software enrol in our online training courseSometimes we use the EzyLearn Blog to inform readers about who uses our online MYOB training courses. We received an email from a New Zealand student and we have had many New Zealanders enrol into our MYOB Training Courses.

MYOB is an international business that started humbly many years ago in Australia but sold recently to a private equity firm, valuing the business at over $1 Billion dollars. You can see from a recent Bloomberg article that the value of MYOB has grown significantly in recent years.

MYOB, Craig Winkler, Xero and Online Accounting

While we are on the topic of big business and who’s buying what, you might be very interested to know that MYOB founder Craig Winkler closed his account with the company he started in back in 1987, to become a major shareholder in New Zealand publicly listed online accounting company and rival called Xero.

Online accounting appears to be the domain of online workers like website developers and we have had very little demand for MYOB Live Accounts (online accounting competitor to Xero) so as yet we don’t cover MYOB Live Accounts. We wrote an article about cloud based software and it’s importance in the rise of remote contractors (Virtual Assistants) back in August 2010 so feel free to learn a bit more about cloud based software services.

We can help New Zealanders

Until then, we just wanted to say that if you are from New Zealand and you want to learn about MYOB accounting software, we can help you. I also want to add that if you are an existing EzyLearn student and you want to highlight some of the difference between the Australian training videos and the New Zealand version of the software, send us an email to sales@ezylearn.com.au, we’ll get Jacci (our resident BAS Agent) to write something up and include it in our course.

To see the full list of topics included in our online MYOB training course visit our website and REMEMBER, we offer all our MYOB Courses (including updated and new content) for one price AND you receive LIFETIME access.

Posted on by — 2 Comments

Having problems with bank reconciliations using MYOB AccountRight Plus version 2011?

Sometimes we use the EzyLearn Blog to inform readers about modifications to our MYOB online training course. We’ve received feedback in the MYOB Support area from students that elements of our MYOB Bank Reconciliation course are coming up with errors when they use the most recent version of the MYOB software.

Bank Reconciliation using MYOB version 2011

One of the great aspects about coming across problems in a course is that it replicates the type of problems you’ll experience in the workplace or while managing your own business. Jacci, our resident BAS Agent has gone through the steps in the course and identified potential issues. She has written up a concise guide that is now included in the bank reconciliation course (#503) to help you balance the books using MYOB.

Online training and support for MYOB, Microsoft Excel, WordPress and moreIf you come across problems or issues please feel free to use the EzyLearn ANSWERS service we launched in May 2011. It is part of our growing support options for students. If you operate a small business and want to know something or if you come across an issue that is not covered by the training in our existing course let us know because EzyLearn courses are LIVE courses, they are growing every month with new content that you don’t have to pay extra to use.

online training and support for MYOB, Microsoft Excel, WordPress website design and moreOh, before I leave you on this blog post I want to highlight our new student support option we launched last month – Tutor Support and Student Community – it’s a way to connect with other students and have direct contact with our professional tutors who have real life experience using the software in their daily business life.

Posted on by

How long will an online training course take?

online MYOB Training Course and SupportSometimes we use the EzyLearn Blog to inform readers about general course information. Our online courses are completely self-paced so you can complete the online MYOB course in 7 days, 2 to 3 weeks or just use it as a resource.

It’s that time of the year when traditional training centres start their class-based training courses. When EzyLearn operated three physical training centres in Sydney we spent a lot of time scheduling which courses. We asked ourselves questions like

  • What day should the course start
  • Which course should be held on a Tuesday/Wednesday etc
  • Should we schedule it for the morning, all day, evening or Saturday
  • How many weeks should the course last
  • Which training room and centres should we hold the course,
  • Who will the trainer be
  • Is the trainer available

Office administration (Microsoft Word and Excel etc), MYOB (Bookkeeping software), Website Design (using WordPress) and Absolute Beginners courses have always been scheduled this way so people are used to talking about courses this way. One of the most common questions we get asked is “how long will it take?” and our first temptation is to say “How long do you want it to take”.

Our online MYOB training course includes 5 courses for the price you’d expect to pay for one course (It includes MYOB Setup, Day-to-Day Transactions, Reporting & BAS and MYOB Payroll Intro) and the contents of the course is what we used to cover in approximately 4 full time days of training.

Another great aspect about an online training course is you can use it for the rest of your working life without paying any extra (if you choose that enrolment option). So you can complete just the MYOB Day-to-Day Transactions course (# 502) and when you need it you can complete the Bank Reconciliation and BAS courses.

To enrol into our online MYOB training course click here.

In the forthcoming weeks we are going to write about

  • Using Microsoft Excel to enter Payroll information and then enter that information into MYOB
  • Differences between MYOB AccountRight version 2011 and previous versions
  • New content for the MYOB Payroll Course

We’ll also introduce you to Jerry Lame. He’s the new Ordinary Man. Follow Jerry’s journey of starting a business, writing business plans, creating a budget and forecasts and then implementing it. You’ll learn how to use software for practical purposes along the way.

If you don’t want to miss out on this information, make sure you subscribe to our blog using the form below:

 

Enter your email address:

Delivered by FeedBurner

Posted on by

Have you seen the latest version of MYOB software

We sometimes release information at the EzyLearn BLOG that relates to information that will benefit our students. If you are a student and you download the free trial version of the software you will be downloading the latest version.

Back on November 17th 2011 MYOB launched their MYOB AccountRight Plus version 2011 product.

We’ve recently recorded some training videos about MYOB Reports for GST Collected and Paid and where GST is located in source documents like invoices. We’ve then gone on to show you how to update your BAS Info in MYOB and use the BASlink feature that collects your GST information and quickly and easily gives you the information you need for your Business Activity Statement (BAS). This information is covered in our MYOB Reporting and BAS course (code 504). If you are familiar with EzyLearn you’ll know that this course is included with all the others MYOB courses for the one price and LIFETIME membership.

The navigation around MYOB AccountRight Plus version 2011 is very similar to earlier versions (although MYOB has updated the icons they use). We’ve downloaded and recorded a quick video to show you what it looks like. If you are receiving this blog post via email, click on the heading to see the video below.

Posted on by

MYOB Training Course and Support – Reporting Course updated (BASlink added)

MYOB AccountRight Plus 2011 - Training Course and SupportSometimes we use the EzyLearn Blog to inform readers about new course content or updates to existing training tutorials. We have created new content for the MYOB Reporting Course and more specifically how to complete your BAS using the BASlink in MYOB.

If you are an existing student you’ll know that you have access to this new content for no extra charge.

We downloaded the latest version of MYOB AccountRight Plus to perform these tasks and you’ll be thrilled to know that the navigation of the program (apart from where the Sample company file is stored) is VERY similar. The icons and images are slightly different, but navigation is the same.

Stay tuned for the next free MYOB Training Video about this newest version of MYOB Accounting software. The next step after performing a bank reconciliation (Course 503) is the Quarterly or Monthly BAS (Business Activity Statement).


Posted on by

We are OPEN now – enrol before school starts

Online MYOB Training course and supportWE are planning some exciting new content for our online MYOB training course, including new support features for students who want extra support. Remember, once you enrol into the EzyLearn online MYOB training course (with LIFETIME membership) you receive access to all new and updated content for no extra cost. Now is an excellent time to enrol.

Now is the perfect time to start a course because most people are on holidays and you have time to think, study, learn and refocus your life strategies for 2012. If you do want to improve your bookkeeping skills and learn how to use MYOB accounting software you’ll be happy to know that we are open over the holiday period (except public holidays).

We hope you enjoyed your Christmas day (if you celebrated it) and wish you all the best for 2012. We sent a thank you out to you and our EzyLearn team, but we forgot to include Monique from Monstar Documents and Rosie Shilo from Virtually Yours. You have both been excellent to work with and we are thrilled at the benefits we have provide some of your members with our Online WordPress training course. Now, more and more virtual assistants and home workers are able to earn an income while working from home.

Here’s to a successful 2012 to you!