3 Things You MUST Do in Excel!

Business owners and job seekers take note!

learn xero myob excel online training course videos
Excel isn’t just for budding bookkeepers; it’s a great tool for all business owners to know.

MICROSOFT EXCEL IS THE most widely used spreadsheet application in modern computing. That said, it’s also one of the more difficult programs of the Microsoft Office Suite to learn, which is why we recently updated the content of our Excel training courses.

A lot of people do our Excel training courses to help them “skill up” to find a job, find a position better suited to them, or develop their career path. However, Excel is a fantastic tool for small business owners as well.

But whether you use Excel to create a pivot table or a database, there are a few things you should do each time you open an Excel document. Here we present you with three:

1. Vertical align: always centre

Always align the text in the cells of your Excel spreadsheet to the centre, or the top in certain circumstances. But never, ever align it to the bottom. It’s hard on the eyes and, when you’re looking at lots and lots of data in lots and lots of cells, it becomes difficult to know which row, column, etc, you’re looking in. Centre alignment, always.

2. Build error-checking into formulas

There should never be an instance where one of your workbooks is showing a #DIV/0, #N/A, #REF, #NAME?, #NUM!, or #NULL! error. This is especially true if you’re sharing these workbooks with your business partners or accountant or whomever.

Seeing an error in a financial report may cause the reader to doubt the accuracy of the entire workbook, so ensure your workbooks remain error free by using the simple IFERROR() error-checking function in Excel.

3. Print preview your work

Again, if you intend to share workbooks with other people, you should always ensure that your Excel workbooks can be printed nicely and easily, even if you don’t intend to ever print the document yourself. This is easy enough to do via File > Print Preview and adjusting the print margins before sharing (or printing) the document.

However, judging by the number of times I’ve printed an Excel document only to collect 87 sheets of paper off my printer to read the contents one 4×4 table, the function is seldom used by anyone else but me!

***

For more Excel formatting tips and tricks, download our FREE Beginners’ Guide to Excel, or enrol in our intermediate or advanced online Excel training courses to learn how to create databases, pivot tables, charts, graphs, and much more…

Read more about our beginners, intermediate and advanced Excel training courses on our website, or enrol to start learning by 5pm tomorrow!


learn xero myob excel cheap online training courses videos

At EzyLearn, we’re committed to helping students of our MYOB, Xero and Quickbooks courses gain employment as a bookkeeper or even start their own bookkeeping business; it’s why we provide you with lifetime access to our online cloud-accounting training courses as part of our commitment to continuing professional development


 

Will the Self-Education Cap Deter You from Further Study?

Online study is flexible and cost effective.
Online study is flexible and cost effective.

For a country that has long considered itself the “clever nation” — the land responsible for the cochlear implant, the hills hoist, and the black box flight recorder — the Federal Government’s proposed $2,000 cap on self-education expenses seems a little surprising.

The Government announced the self-education cap two weeks ago and since then, speculation has been rife that the cap will deter employees and businesses from undertaking further study.

Annette Tsouris, Director of Studies at Australian Workplace Training has been quoted in the website, Smart Company, as saying that though the $2,000 cap was reasonable, for people currently employed and looking to up-skill, “the average price of a course is around $3,000.” While the cost of post-graduate studies at university usually run into the tens-of-thousands.

Online Training — The Cost Effective Alternative

Of course, costly face-to-face study and post-graduate degrees aren’t the only learning methods available. Online training courses — in all kinds of areas for instance, MYOB, Excel and WordPress — have become popular, not just because of their flexible delivery method, but because online study companies don’t have the same overheads as face-to-face institutions and can offer courses at considerably lower prices — the average cost of an online training course at EzyLearn, for instance, is less than $270!

Although the cap on self-education expenses could do well to be a little higher — $5,000 per person, say — the cap itself won’t deter people from further study; from gaining the power of knowledge. It will only serve as an impetus for individuals and businesses to investigate other non-traditional learning options, such as online study and training methods.

Our Online Courses Below the Cap

For budding entrepreneurs or individuals seeking the skills to start their own business, or to manage a small business, our Small Business Management course is currently only $1,397 — well below the proposed cap.

We have reduced the price of our Small Business Management course, which is usually more expensive, for a limited time to allow you the opportunity to gain the necessary skills you need to start their own business or gain employment managing a small business without exceeding the self-education cap.

Take advantage of this great offer now and enrol in our Small Business Management course; discover the valuable skills you need to successfully manage a small business, including writing a business plan, conducting market research, legal and risk management, and much more!

Should we offer MYOB Training Courses to group buying companies?

group-buying-sites-choice-review-discounted-MYOB-training-course
Image from Choice website

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.

choice_group_buying_reviewAnd 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…

As far as discount coupons, we make them available to you. Just tell us what you are looking for in a training course and you’ll automatically receive a discount coupon code for our MYOB, WordPress and Excel training courses.

Learn all software programs for $99 per month

You can now learn Beginners to Windows, file management, Email and web browsing, Microsoft Word, Excel, PowerPoint, Outlook, MYOB and much more for a low monthly subscription fee. It’s computer training online so you can learn in the comfort of your own home or office and there’s no extra cost.

 The training is video based too, which means you receive a combination of video, audio, workbooks that you can print out and exercise files that are used in the workbooks so you get to practise what you learn.

Visit the website for more information: www.computertrainingonline.com.au

FREE Computer Software Training Courses in Microsoft Office (Word, Excel, PowerPoint, Outlook, even MYOB & more..)

Ezylearn and it’s partners are able to offer you free computer training on Microsoft Word, Excel, Outlook, Publisher, plus MYOB and softskills courses like time management and goal setting if you fit the following criteria:

  1. Are an Australian permanent resident
  2. Are over 25 years of age
  3. Do NOT have any certificate II or higher qualifications (in any industry)
  4. Have not completed Year 12 or equivalent 

If you fit this criteria, the Australian Federal Government will fund the cost of your training. That’s  $3000 value at no cost to you. Click Here for more information about the free computer software training course.

What type of people could use some updated computer skills? 

  • Do you run a business and struggle to understand how to use computer software?

  • Are you employed, but have no formal qualifications and want to improve your skills?

  • Are you a mum or a carer that wants to get back into the workforce, but are worried you are under qualified to gain employment?

  • Are you self-employed? Would you like to improve your business skills by increasing your administration and bookkeeping abilities?

  • Are you a job seeker and would like a qualification to help gain employment?

We can provide you with a Certificate II in Business and you can complete the training in three locations across Australia: Chatswood, Dee Why and Perth. You can start anytime you want and you can learn from home using the EzyLearn online computer training system.

Click Here to access the free computer software training course enrolment form and begin the enrolment process.

Please feel free to call us, or Click Here to find your nearest EzyLearn computer software training centre..

OFFER ENDS JANUARY 31st so HURRY, conditions apply

FREE Computer software training course enrolment form