We’ve made a simple online MYOB quiz available for anyone who wants to test their MYOB bookkeeping skills. It’s a very simple test designed to show people how online knowledge tests work and also have some fun and see how much they know. We did an export of all the results (minus the students details of course) and you can see them in our Microsoft Excel Training Course.
These test results show how long it took students to complete the test, their results, overall score and more and the datafile is available in our Microsoft Excel Course 308 which includes:
Understand 3D formulas between worksheets, cleaning up data using advanced filter, create a pivot table and change the value field settings, create a pivot chart to visually show the stats, using advanced functions like CHOOSE, VLOOKUP, HLOOKUP, MATCH and INDEX, look at advanced functions within functions (Nested Functions) and how to protect the worksheet and workbooks
The knowledge reviews in our online training courses are much bigger and more complicated and they provide us with a great tool to identify areas of difficulty for students and help us constantly update and improve our MYOB training courses.
At a recent business owners breakfast I heard someone speak about blue ocean and red ocean strategies. I’m going to write some blog posts about how to build your business as part of our project to help our MYOB students start, maintain and build their own bookkeeping businesses and this article is a fitting way to start.
The Blue Ocean strategy involves finding new demand in an uncontested market which essentially means to innovate. This essentially means create something new, but I think for many small business it could means package your services so that you can demonstrate a difference between your bookkeeping business and others. The Red Ocean strategy is all about competing head to head with your competitors to try to get existing customers to move away from someone else to use your services. You can get a better idea of what Blue Ocean strategy is at their website.
We try to innovate in our services by offering lifetime access to all courses, provide all skill levels in one course (ie. beginners to advanced) so you don’t have to waste time trying to figure out which level you are at and provide different versions of training for Microsoft Word and Excel (ie. 2000, 2003, 2007 and 2010.
This table shows the key differences between the strategies. See which strategy you are pursuing.
Are you looking at starting or growing your business?
Do you want to start a business? Do you want to create a business plan? Does it all seem a bit daunting?
[quote]We are working with Maggie Richardson, author of “Starting a business in Australia” to get her Cert IV in Small Business Management online.[/quote]
This course not only gives you a well rounded education of the requirements to start and build a small business, but you will end up with one-to-one help in creating a business plan as part of the course! Read more..
One of the most popular office productivity programs in the world is almost taken for granted these days as a program that everyone knows how to use, but there is a lot to learn to really master it. We’re talking about Microsoft Word of course, and we’re currently having new training content recorded for Microsoft Word 2010.
You might recall from previous posts that we offer lifetime access to our training courses. You might also recall that our Microsoft Office courses include most versions of the software so you can enrol knowing that all versions are covered. We also include access to beginners to advanced courses all for one low price! That’s our learning guarantee.
You will have the chance over the following weeks to see some of these new videos right here so stay tuned and make sure you subscribe to receive these posts via your email.
You’ll get some insights into tabs and tables. They are extremely powerful Microsoft Word tools that help you make your Word documents look professional. If you get the wording right in your resume and use your Microsoft Word skills to make your resume look good you’ll increase your chances of getting that job.
Tables are like spreadsheets
Even though you often see the borders of a table in Microsoft Word you can change the formatting so that they are invisible and this is a great way to get some structure in the content in your work document while not showing that your using tables. Tabs are also very handy but you need to remember that tabs are paragraph formatting so if you forget to apply them to each paragraph you are working in you might find the whole process very messy. There are also the option of using the default tab stops to make text line up, or setting your own (which we recommend because you can make the text line up as centres or right aligned and even to the decimal points if you are putting a pricelist together).
Formatting your resume
If you are using Microsoft Word to create your resume you’ll definitely make it look better with the use of some structure, after all, it’s the structure and layout that often separates a professional looking resume from an average looking one. If you are not sure how to create your own resume, let one of our professional partners create a professional resume for you and provide training so you know how to make any modifications yourself.
Discount Coupon for MYOB Training Courses
We also mentioned the discount coupon available to you for our online MYOB training course, but we forgot to mention that the discount coupon actually applies to all courses!
There was a letter from the Energy company sitting on my desk today. I took a deep breath, prepared myself for a new invoice and opened it. To my pleasant surprise there was no bill, instead I received a letter with an accompanying brochure, warning me of my impending bill.
But it wasn’t really a brochure, it was my terms and conditions. I am certain that I had seen this before so why did they send it again? What I was most impressed with was how they sent these terms and conditions. Rather than send them in fine print on lengthy A4 pages it came in the form of a brochure. That alone made sifting through them easy to digest – very smart Tru Energy.
We thought we would use this opportunity to share with you a great story about how one company, EnergyAction used our Excel training course at a training centre near their Sydney office in Parramatta, to teach their employees how to create excellent spreadsheets that demonstrate how much money they can save on their electricity costs.
We’ve been approached by many different Groupon type companies. There seems to be hundreds of these sites popping up every day and they are famous for offering you almost unbelievable discount coupons for almost anything but most commonly services like pedicures, restaurant and cafe meals etc. We’ve always ensured our prices are competitive and bookkeeping students receive good value for money, but our Training Partners have tried them and we’ll share their opinions with you.
For business owners (or merchants as we are called) group buying sites promote the possibility of receiving hundreds of sales of your product (so you better make sure you can service the demand) but what do they want in return. Here’s a classic scenario:
Normal Price: $200
Group Buying Price: $100
Saving to you: $100
Margin that goes to the Group Buying Site is typically 50% of the discounted price, ie. $50
This means that a merchant that would normally receive $200 for something, will now receive $50! Is it worth it? Then why not just sell it on special for $100 and spend some money advertising it? As you can see, we are pessimistic about the future of group buying sites. Our training partners workface.com.au offered a discount on their Microsoft Excel training courses only to receive a handful of sales.
And there are hundreds of these group buying sites. See if you can recognise some of these names: Cudo, Groupon, AlltheDeals, Spreets, Living Social, Grabone, BizzBuzz etc. At the beginning of 2011 a local Australian startup in the space was sold for $40M! If you have time read a review by Choice Magazine.
The main reason we don’t like the big group buying sites is because of some of the conditions imposed.
When you buy the discount voucher the group buying site earns the money. Some of the more selfish sites will then only pass this money to the merchant when the customer uses the voucher. In other words, if the customer doesn’t use the voucher within the “valid period” the merchant earns nothing and the customer loses the benefit!
By the way, I was at a software training function last week and a birdy told me that consumer protection laws might come into affect that provides protection for buyers of these discount vouchers – if you buy a $50 product then you can receive $50 off after the offer period has expired. Watch this space…
We recently wrote about why more and more mums are looking to work from home as a virtual assistant and perform bookkeeping tasks using MYOB. Mums are also becoming website designers using the free website building software called WordPress.
We just wanted to remind you that if you are a mother or a stay at home dad and you want to learn these programs so you can work from home while bringing up your children, we want to offer you a discount.
Just tell us what you are looking for in an online training course and instantly receive your discount to one of our online training courses.
A short time after we opened our first training centre in Dee Why in 1999 we offered MYOB training courses and our trainers included some very talented ladies Maria Landrelli and Marie Di Blasio. We quickly discovered that business owners and job seekers alike wanted and needed to learn some key Day-to-Day skills so we set about creating the ideal MYOB training course for Day-to-Day Transactions.
Most of our training workbooks are based around case study examples of a practice company. This gives you a real world example of the types of processes that many businesses go through as you learn to perform the transactions using MYOB. We’ve written a detailed description of the journey we take you through in our Day-to-Day MYOB Training Course so check it out and see if it covers some skills you’d like to master.
The MYOB Day-to-Day Course uses a case study of a small business telephone system supplier as they go through the process of purchasing products, providing customer quotes, ordering and supplying products and services, accounts receivable, receiving payments and banking. It’s the perfect course for someone looking for a job where the use of MYOB is required for data entry, or a small business owner that wants to take the next step towards a computerised bookkeeping system.
Without wanting to dive into the psyche of a new born mother I noticed a warming pattern in Ebay shipments. Although my teenage years weren’t filled with the educational perspective of The Rolling Stones’ lyrics, the benefits of small parcels from other Ebay devotees fulfils the mothers need for new and interesting things.
Moving away from our usual topics of computer software training, employment services and MYOB and Bookkeeping related blog posts I delve into the stupendous success of Ebay. Ebay users share an unequalled (in the eye of this writer) desire to be rated by their peers so that they can sell to other Ebay devotees. Small children’s garments are often mailed for the cost of the packaging and freight in the knowledge that they will benefit another fledgling family as merchants are rewarded by the invisible smiles of happiness of thousands of recipients in other suburbs every day.
If business owners can act in this way the future might be filled with more specialised businesses that do a better job and are prepared to be publicly rated.
Just like Carol the kindle user and Grandpa Jack, Ebay is evidence that technology is now like electricity – a normal part of our lives. Bring on the next wave.
Employment is one of those huge questions in the mind of many mums and dads. How to ensure that the family can maintain an income from both parents while still giving your new infant the time they need.
When we operated our MYOB training courses in Parramatta, Chatswood, Burwood, Gordon and Dee Why we noticed that a lot of mums were looking for a way to work during school hours while still being able to earn good money. They were coming to our MYOB courses because they knew that they could earn good money performing bookkeeping for local customers. The same still applies today.
It is now easier for working mums to earn good money and still remain at home! With VoIP Phone Systems, accounting services in the cloud and broadband internet mums can perform bookkeeping tasks for clients anywhere in Australia.
I was speaking with Ross Miller, the blind rehab consultant who has helped hundreds of job seekers learn new computer skills, write better cover letters and resumes and improve their performance at job interviews, and he shared an interesting resume writing tip with me.
Many employers are now using technology as much as possible to help them find the right candidates for job vacancies. With the tremendous cost in time to find the most appropriate employee some companies are using OCR (optical character recognition) scanning to help them identify the best resumes for their advertised positions. This means that they are actively looking for selected keywords in the resume’s that are sent to them.
Once the domain of website designers and search engine optimisation (SEO) specialists the ability to use the most relevant words in your resume is becoming more and more important. It’s the same principle that is used to make websites more relevant to Google’s Search Engine results.
There are some excellent phrases and some simple, but important lessons in the Richest man in Babylon book which dates back to 1926! The one which we found interesting (and it stood out to us because we are an education and training provider) was the heading “Increase thy ability to earn“.
This concept applies to many industries and we’ve found there are two types of workers (whether you are a business owner or employee), those that seek new information and education so that they can be innovative and productive or those who do it because of necessity. When we say necessity there are two types:
If I don’t learn I will be out of work, OR
I need to learn to keep my job, licence etc
The Bookkeeping industry has been undergoing massive changes since 2010 and will continue to do so because bookkeepers responsible for lodging BAS’s on behalf of their clients will need to be registered BAS agents and as a result will need to always be abreast of changes in legislation. This webcast transcript from the tax practitioners board will give you some insight into how much the bookkeeping industry is changing.
You can be assured that our online MYOB training courses will be regularly updated to ensure that your knowledge on MYOB is up-to-date.
We were reviewing the course outline for the MYOB Day-to-Day Transactions course because it covers most of the topics that someone would need if they are performing daily bookkeeping data entry tasks for a small to medium business.
The course provides the foundation skills that most of the other courses are built on. Once you have the day-to-day data entry skills you will be able to more confidently perform a bank reconciliation, generate reports and prepare BAS returns as well as enter the data and prepare reports for payroll.
The MYOB Day-to-Day course uses a very common case study of a company that provides products and services. We use an IT consultant that sells small business VoIP telephone systems and supports their customers with the initial setup as well as ongoing support.
Course features
Since January 2011 our full suit of 5 MYOB training courses comes with lifetime access so you can revisit the training videos, workbooks with step-by-step exercises and knowledge reviews as often as you want for the rest of your working life. Many students use the course as a resource for when they are using
Our MYOB training courses also come with EzyLearn ANSWERS, a service that we provide to create new course content based on questions from our students. It’s a way that we increase what is covered in our courses while providing students with an level of customisation and support.
MYOB courses created by certified bookkeepers and BAS agents
Another great aspect of this course is that we go into the Inventory module of MYOB Accounting software to see how a company can sell products as well as services using the Inventory module of MYOB AccountRight Plus.
Our MYOB training courses are created using consultation with business owners and certified bookkeepers and registered BAS agents who perform bookkeeping tasks for their own customers.
Free MYOB Training Course
We want to give free MYOB training away so you get a chance to learn more about us and see if we are the company you turn to for your MYOB training courses. Follow the link below and you will automatically receive our free MYOB training resources.
The free MYOB Training Course material is now available at our new MYOB Short Courses catalogue site. Access the FREE MYOB Training Now
Tips and Tricks
We announce new course content, free tips and tricks, free training videos and much more via this blog so feel free to subscribe and be kept up-to-date and well informed about MYOB, bookkeeping, Office Administration and Website Design. Enter your email address below:
Taken from Monash University Whitepaper on loyalty
We wrote about the amazing success that Woolworths is having in the increased sale of products through their online shopping portal. Today we explore the concept of loyalty considering the loyalty war that is going on between the shopping majors Woolworths and Coles as well as ways of increasing your customers loyalty.
Imagine this scenario:
Jane is 53 years old and lives with her cat in a northern suburb of Melbourne. She works full time on the other side of town, so she prefers to drive rather than catch public transport. On the weekend Jane likes to do some gardening, and she is also fond of red wine. In fact, she drinks so much that it makes financial sense for her to buy her wine by the carton. Jane’s daughter lives a few kilometers away and has an 18-month-old girl. Jane likes to buy clothes and toys for her granddaughter, even though she has more than enough already.
There are some great discounts available for members of these loyalty programs but do you expose yourself and your complete spending profile to these huge companies. It becomes even more interesting as these companies enter more and more markets. From simple grocery shopping the retail majors are now into petrol and liquor and next it could most likely be pharmacy. With all this data about your shopping habits these companies will have an eerie amount of information about you.
This report reveals some very interesting information about how you can be profiled.
If there is one thing smaller businesses can take from this, it’s the value of having a database of your customers and the easiest database to use is your MYOB customer datafile or your email newsletter subscriber list. You can learn about these concepts in our online MYOB Training Courses and our WordPress course.
We recently wrote about the yearly returns that APRA (the governing body for the financial services industry) announces to showcase the rate of return of the top 200 superannuation funds. This information forms part of our new Bookkeeping Academy for continuing professional development (CPD).
It prompted a question in our think tank about the purpose of superannuation and whether it should be used as a tool for investing in equity?
The problem with equity is that there is no guarantee of return and its value is completely dependent on the performance of the company. Even things like dividends are only paid at managements discretion. Interest on the other hand must be paid and the capital returned to the investor at the end of the term. In the event of a liquidation, debt is repaid first and it is usually secured by something.
It all really depends upon your personal circumstances but we found a product on the market that seemed to fit very well with the thinking of the concept of super. It is the Commonwealth Banks Superannuation Savings Account. It earns interest which might not be as impressive as equity, but this is only 10% of your income and it goes along with the adage from the Richest Man in Babylon… Make thy gold multiply.
In the end, as Financial Planners will attest, the decision you make depends upon your risk appetite and your investment time horizon, but one thing is certain – you must have super as an employee and pay it as an employer. Stay tuned for the news about our MYOB Payroll Level 2 course where we go into more detail about how to manage the paying of staff. All new content generated for our online MYOB training courses is available to existing students as part of their lifetime access.
As part of our continuous improvement for our online MYOB training courses and the development of our Payroll Level 2 course we explored the superannuation market. Superannuation was established as a way for ordinary working families (sorry to steal this catch phrase from Julia’s government) to contribute to their own retirement income and as a result gain tax benefits.
There was horrendous news and publicity about bad returns for many superannuation funds in the global financial crisis and we thought we’d explore these results a little closer. If you are reading this as an MYOB student, a bookkeeper, small business owner or employee you would be aware that superannuation is compulsory for most employees and you now have the choice of where you want this money to go. APRA is the government organisation which overseas the banks and banking regulation in Australia and they announce the rate of return for the top 200 superannuation companies each year.
If you want to take a closer look yourself, check out the figures from page 5 onward in the latest superannuation report from APRA. You can download the report as Excel or PDF format.
This brings up some interesting questions. Can a superannuation funds manager outperform the Index and how do you guarantee a positive return for your super every year? We’ll explore these questions soon…
We recently had an inquiry from one of our MYOB Training students about accessing the free MYOB test drive software. We mention to students that we provide a link to the software in our course, but we happily also hand the link out to anyone who wants to get to know about the software.
Although EzyLearn is an MYOB reseller and we have sold MYOB software in the past, we know that there are much better online retailers who focus on selling MYOB software online. There are comparison sites that even allow you to compare the cost of MYOB software from different retailers of the software you are looking for.
We also assume that you can install software on your computer or have a friend or colleague or IT consultant that can help you install software.
Type the first 3 characters to discover courses, up-skilling programs and CPD articles.
EzyLearn's Career Academy
Enrolled into an EzyLearn course since 2013? Get access to new & updated course content and support by joining the EzyLearn Course Refresher Access membership Program. See how to extend your course life & support.
Xero is a great bookkeeping program for tradies who are on the go and using their phones (or a tablet) all the time. From receipts scanning to creating quotes and invoices, receiving payments and keeping track of project costs.
bookkeepercourse.com.au/produ…
We’ve made a simple online MYOB quiz available for anyone who wants to test their MYOB bookkeeping skills. It’s a very simple test designed to show people how online knowledge tests work and also have some fun and see how much they know. We did an export of all the results (minus the students details of course) and you can see them in our Microsoft Excel Training Course.
