Category: Online Excel Training

Posted on by

We’re real people, really!

mums returning to work looking for online MYOB and Excel training course to upskill to find workThere are many questions that we get asked each day and one of them is “Can I start the course tonight?” I’m writing this blog to let you know that we are all people at EzyLearn and if you have an urgent need we’ll try to help you.

Rowena called and asked this question today because another company that was advertising an MYOB online training course was experiencing difficulties with the person that manages their online system, they couldn’t even get her enrolled and started!

The good news is that there are several EzyLearn team members that can get you started and using our online training system and we manage the whole process ourselves.

Why is this important? and why do I blog about it? Because we promote “Enrol today and start by 5pm tomorrow”. We actually perform enrolments EVERY DAY and we only make the “5pm next business day” promise as a safety net if we get excessively busy.

We also say that “our online training courses are the best online training offer in Australia” and what this means is that we offer EzyLearn ANSWERS and the Student Community and Tutor Support because we are constantly adding content to our MYOB, Excel and WordPress courses. If you are one of our students and there is a topic you are experiencing that is not covered in our course content, we will commission the relevant expert to create a training guide and make it available to you!

Oh, and have a great Easter long weekend. Remember you can enrol today and start after Easter if you want.

Posted on by

MYOB Training Course and Support – bank reconciliation

MYOB Training Course - Undo Bank Reconciliations using MYOB version 2011In January 2012 we introduced the Student Community and Tutor Support service and we’re announcing some new training guides that have been placed in the Student Support area.

Bank Reconciliation can be a tricky task to master, and that is before you master the motivation to get started! We have a project in our MYOB Bank Reconciliation course where you have to create a new company file, import accounts and transactions and perform a bank reconciliation. It’s a lot like a real world scenario and it causes some grief for existing students so we added an extra guide to help.

Student Support for online MYOB, Excel and WordPress coursesWe’ve also receive requests in our EzyLearn ANSWER service from students who want help and instructions on how to email invoices using the latest version of MYOB (version 2011) so we have created a guide about how to do it.

Stay tuned for more Student Support Guides over the coming weeks. Enrol to start now and learn at your own pace. Take advantage of LIFETIME student course access and great student support features like EzyLearn ANSWERS and our Student Community and Tutor Support.

 

Posted on by

New Training Material: Advanced Microsoft Excel 2010 videos

Excel Online Training Course 308 - pivot table value field settingsSometimes we use the EzyLearn blog to provide some free tips from new training material that we create, like manipulating Pivot Tables we mentioned earlier in the week. Today we are announcing that 14 new training videos are now available for our advanced Microsoft Excel course (number 308).

This is the list of videos that are now available:

Video for 3.1.1 – Using AutoFilter

Video for 4.1.1 part 1 – Cleaning up data using AutoFilter

Video for 4.1.1 part 2 – Cleaning up data using AutoFilter

Video for 5.1.1 – Perform an Advanced Filter

Video for 5.1.2 – Advanced Filter using Wildcards (search text within cells)

Video for 5.1.3 – Advanced Filter for multiple search criteria

Video for 5.1.3 – Narrowing search results using Advanced Filter

Video for 6.1.1 – Inserting a Pivot Table

Video for 6.1.2 – Filtering data in a Pivot table

Video for 6.1.3 – Sort dates by month in a pivot table

Video for 6.1.5 – Changing the value field settings in a pivot table

Video for 7 – Creating pivot table charts

Video for 8.1.1 – Get months values using the Choose function

Video for 8.1.2 – Show grades for student results data using CHOOSE function

 

Our new video references match the many exercise tasks you can complete to master the skills taught in the videos. Everything you watch in the videos you can re-produce using the exercise files that come with the course. The training workbooks contain step by step instructions so you can print them out and practice where-ever you are.

If you are an existing EzyLearn student with LIFETIME access you’ll have access to these new videos and all new content that we create. Stay tuned for more updates soon as we create new videos for the other advanced Excel topics covered in courses 308 and 309. Plus we’ll show you how to create your own macros.

If you like what you read and want to enrol to take advantage of lifetime student access as well as access to all levels of Microsoft Excel for just one price, use our enrolment form. Enrol into the Excel course today and start by 5pm tomorrow (next business day).

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

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 — 2 Comments

Want to operate your own online training business?

Online training course and support business for saleEvery business owner makes decisions about how they want to grow the business and the different “channels to market” are discussed in strategic management textbooks regularly. In 2010 EzyLearn made an executive decision to build a Partner program so that other companies can benefit by working with us and our training courses and content.

We explored many options including affiliate marketing and in 2012 our line up of available partner plans has evolved completely. You can start with

  • some code which can go onto a page on your website and receive a commission for each sale,
  • you can have a new website commissioned with all the information about our online courses and an enrolment form where you receive the payments, or
  • you can plug right into the EzyLearn enrolment process and receive payments from the general public.

If you are interested to learn more complete our online training business opportunities application form and begin your journey.

Posted on by — 1 Comment

Can MYOB repay it’s debts with its head in the clouds?

cloud-accounting xero vs saasu vs myob online training courseWe wrote back in early 2010 about what appeared to be a revolutionary move at the time about MYOB founder Craig Winkler jumping ship and moving to Xero. In the recent bad press about the bug-ridden upgrade of MYOB AccountRight 2011 there is an interesting mention about Cloud Based accounting and MYOB’s goals to get into that space.

In the past 12 months we have worked with as well as provided training for many virtual assistants (remote contractors) and we’ve come into contact with other cloud-based accounting/bookkeeping services you might like to know about. Our pick of the bunch would have to be SAASU at this stage because they have a product that is perfect for remote contractors or micro businesses.

It appears that Xero and SAASU own the online accounting market space but it will be interesting to see how MYOB go as they diversify into cloud accounting as well as their many other products like website hosting, which we’ve never really understood when there are market leaders like MelbourneIT and NetRegistry as well as thousands of small providers.

While we’re on the topic of cloud, here’s a little plug for virion business grade voip. Our trainers have compiled an Excel spreadsheet to demonstrate the cost savings of VoIP over traditional telephony and this year we will have some training for IT Consultants about the Siemens Gigaset office phones.

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 — 3 Comments

Accountants now refusing to recommend MYOB

As part of our commitment to create new training content every quarter for our online MYOB training course we’ve added some addendums to the bank reconciliation and payroll courses in line with the latest version of MYOB AccountRight Plus available. Many Accountants however are not recommending that their clients make the upgrade.

We received some complaints from students about issues they experienced with the MYOB Bank Reconciliation and Payroll Intro courses and as a result our Registered BAS Agent and MYOB Tutor, Jacci, went through the course and wrote some notes to help students come up with the correct results.

Just as we suspected after speaking with bookkeepers and accountants it appears there are major flaws with the current version of the software and it’s affecting the revenue of MYOB Professional Partners and Consultants (who are being encouraged not to share the information).

It’s times like these that we are all tested as trainers, installation consultants, bookkeepers etc to be confident that we are doing our best to use the software to provide the information that we need. It’s also a good time to understand the benefits of having alternative ways of working with your data (ie. using a spreadsheet like Microsoft Excel) to perform calculations for PAYG and Superannuation.

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

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 — 3 Comments

It’s time to thank YOU

It’s only days before Christmas 2011 and from all of us at EzyLearn HQ we want to thank you for watching our training videos, using our training worbooks and completing our knowledge reviews, reading our blog posts and telling your friends about us. I personally also want to thank the core EzyLearn team for enabling us to grow and provide a great online training solution for thousands of Australian’s and international students.

Thank you Frankie, Yvette, Richard, Jacci, Ross, Amy, Luke, Iroshini, Warren and Allison. Also a big thanks to Simon, Scott, Amy J, Faisal, Jennifer, Nicholas and Mathew. You have made a real difference to EzyLearn this year and to our students and the hard work you’ve done will reward students for years to come.

This year has been one of our best years because we made a commitment to be the best online training company for

  1. MYOB accounting software and bookkeeping
  2. Microsoft Excel & Microsoft Word, and
  3. WordPress website Content management system and blogging platform.

Other training companies spend their time and energy trying to provide hundreds of courses with the aim of trying to get anyone they can. We decided to focus on our core skills and give everything we could. We also tried to make our online training courses affordable and inclusive so you don’t have to worry about your availability or skill level.

Here are some highlights during the year:

Creating a WordPress blog post

online WordPress training course - blogging and website designSocial media has gripped us all this year and if you are a business that didn’t know about websites, blogging, Facebook pages and Twitter you were considered lost. We’ve used WordPress to create our own websites for years and this year we introduced the WordPress Training Course.

You might find it interesting that we were writing blog posts about WordPress back in 2007 and even earlier, but this year we expanded our content significantly and included Google Analytics, Feedburner and other skills in it.

LIFETIME student membership

In January 2011 we introduced lifetime access to our online MYOB Training Course. This gave students access to all courses (Setup, Day-to-Day, Bank Reconciliation, Payroll Introduction) and it also provided them with a safety net and a resource when they are in the workplace. Rather than say thank you and goodbye once our students have completed their online course we welcome students to come back as often as they need.

A significant benefit to this offer is that students get access to all new content that has been created for the course or updated content for the existing material. An excellent example of this is our online Microsoft Excel course. We have training material since 1999 on Excel version 2000, 2003, 2007 and 2010 and as we create new content for Office 365, existing students will have access to the new material for no extra charge.

Welcoming Entrepreneurs as Business Partners

Our Business Partner program has enabled other dedicated professionals to use and promote our training material as part of their own business activities. This has enabled us to focus on the delivery of training materials and management of a learning platform while other business owners earn money by their promotional and sales activities.

We are 100% dedicated to this program going into 2012 so if you are interested please ensure you make contact with us.

Testing your MYOB knowledge and skills

Online training assessments and tests for coursesOnline training is still relatively new for many prospective students so we introduce the concept of knowledge reviews and skills tests to demonstrate how they are a learning tool as well as a testing tool.

We created a significant volume of new tests and quizzes as part of our online training courses this year and as a demonstration of their efficacy we introduced a free public MYOB skills test to see how much you knew about MYOB. It was also a great way for students to discover a new way of learning something online.

Partnering with Bookkeeping Industry groups

A significant number of our online training students complete their training to perform bookkeeping tasks as an employee or as an independent contractor. To demonstrate our commitment to “would-be” MYOB Bookkeepers and provide you with reputable accredited MYOB courses we became an accredited training provider of the Institute of Certified Bookkeepers. EzyLearn is also a member of the Australian Institute of Training and Development, the Australian Web Industry Association and the International Coaching Federation.

We join these associations to support the online training and coaching industries, demonstrate our commitment to professional industry ready courses and keep abreast of all new training techniques and technology.

More than just an online training course

Support is an important aspect of online learning and it is also a source of significant costs for organisations like EzyLearn. In balancing the costs of maintaining our current team members will the benefits of some rudimentary customisation of our courses we introduced EzyLearn Q&A. With a separate Q&A service for Microsoft Excel, WordPress and MYOB.

We’ve subsequently called this service EzyLearn ANSWERS. It’s a way of providing new training materials based on questions from our students. Students ask questions relating to their needs and our software specialists create a short answer to lead students to a solution. We use this service to increase the breadth of topics covered in our courses.

More team members to serve your needs

This year we added 8 new team members to help create new training content, manage our online learning site, answer questions and provide support. Most importantly it has helped us significantly reduce the time it takes between when you complete your course and when you receive your certificate.

You’ll meet more of these team members during 2012 and we hope to bring more people into EzyLearn to support your learning needs.

Faster loading videos and better online learning tools

We listened to the feedback from our students to improve as much as possible and to complement the addition of new team members we significant upgraded our video hosting capacity to ensure faster and easier viewing and navigation of our online training video tutorials.

This technology update enabled students with new devices like iPads and other Apple products to view our training videos and participate in mobile elearning regardless of their chosen devices.

Training for office administration for small businesses

virion small business telephone systems using voipThis year we formed a partnership with virion business grade VoIP to provide online training tools for their installation partners. As part of this project we included some new training materials to help office admin staff not only configure their new VoIP telephone systems, but we also provided spreadsheets for them to use as part of their phone bill analysis reports for customers to demonstrate how much money they could saving using Voice over IP.

We started looking at VoIP solutions for our own business in 2008 when we tried out the features of MyNetFone. In our constant search for better technology and support people we discovered the VoIP solution dedicated to small businesses, virion.

In 2012 we will strengthen this relationship by providing more in-depth training videos and tutorials. Our commitment to online training is focused on providing students with the tools they need to be efficient and productive in small business across Australia as well as provide these small businesses with the tools they need to operate great businesses.

Conclusion

If you think we have made a lot of improvements in 2011, just wait until you see what we have planned for 2012. We will:

  • create more training content for our MYOB course and WordPress /  Webmasters course
  • implement more services to help support your online learning
  • help you find more customers (for small business owners using your website and Google adwords, Analytics and SEO)
  • provide more tools to help you find a job (for job seekers by helping you write better resumes, perform better at interviews and be more confident in your work)

Thanks again for reading and following our progress we want to demonstrate your successes in our 2012 blogs posts.

All the best from the EzyLearn Team.

Sincerely,

Steve Slisar