Category: Clients

This category is only for corporate members to access select content which is designed specifically for them.

Posted on by — Leave a comment

Advanced Excel Tip: IF Statements

Advanced Microsoft Excel Training Course - Sales Commission IF - intro

Advanced Microsoft Excel Training Course - Sales Commission IF - intro

IF Statements are what is called a LOGICAL test, such as is this value larger than this, if true do (or display) this, if false then do (or display) that. IF statements can be used for a lot of different things and all of them save you having to manual go through the data and perform the calculations themselves.

These are some examples of how IF statement can be used:

= IF (Question eg B17>B16, do this, otherwise do this)

OR, if you want to show text

=IF(Question eg B17>B16, “Text if correct”, “Text if incorrect”)

OR if you want to perform a calculation

=IF(Question eg B17>B16, if yes multiply sales by 2%, if not multiply sales by 1.5%)

We’ve attached the file that we used to create the image in this blog post so you can open the file and see the formulas that we have entered into cells D7 and E7. Click on each cell to see the formula. See if you can duplicate these values down each column.

Excel exercise file: Sales Commission IF – Intro

If you’d like to participate in our online Microsoft Excel training course visit this link.

Want to do a course online but not sure how online training courses work?

If you want to have a group of people training in your office or our training centre call us on (02) 9971 0000 or visit our online schedule to enrol into Class-Based Training in Chatswood, Sydney.

Posted on by — 2 Comments

What does a webmaster look like? Could you be one?

Learn how to use Wordpress and social media training course

Learn how to use WordPress and social media training courseIf you mentioned the word Webmaster 5 years ago you would imagine someone slightly geeky, who drinks cola, has thick rimmed glasses and talks incessantly about the latest technology and gadgets. Things have changed. The technology used to create websites was the domain of nerds who enjoyed writing code and getting dirty with technology using programs like FrontPage, DreamWeaver, Flash etc, but now it’s the domain of staff members, marketing people and remote contractors (Virtual Assistants who work from home). Why has it changed?

The most significant aspects of website design are:

  • The template (or theme) that’s used including colour scheme, branding and navigation
  • The  images and copy (text) used to fill the site
  • Promoting and marketing the website

Modern day Content Management Systems like WordPress, Joomla and even older ones like Drupal make everything much easier and here’s why:

  • Thousands of designers create templates that you can purchase for $20 to $300
  • Once a template or theme is designed and setup the content management is the same (just like using Microsoft Word)
  • Writing articles, creating extra pages and adding to your navigation becomes as easy as selecting a check box and picking a category.

So is it really something that you could do?

wordpress themes included in Webmaster course
wordpress themes included in Webmaster course

Have you heard about WordPress, Google, Facebook and Twitter? Can you use your computer to access your email, do internet banking and accessing other online services? Have you heard about or used PayPal? If you have, then you are at least familiar with some of the tools used by a modern webmaster. Combining these new online marketing tools and WordPress CMS driven websites you can get busy and start creating.

The Internet, smart phones, cloud computing and VoIP are making the world a smaller place and allows people to work from home but still remain digitally connected. There has been a significant shift towards remote contracting (virtual assistants) and the concept of mums working from home is now commonplace.

If you want to come on the Webmaster journey with EzyLearn we have the WordPress course. It’s a step-by-step system of setting up, creating content and images, building the contents and then promoting your own business using all the tools we’ve mentioned in this blog post. Best of all you’ll have an internet guru educating and coaching you each step of the way until your website is complete so not only will you have your own website and tools to promote it, but you’ll have the skills to promote yourself to other businesses and help them with their website management.

Posted on by — Leave a comment

Are MYOB skills good enough to be a bookkeeper?

MYOB bookkeeper with Cert IV in Bookkeeping

MYOB bookkeeper with Cert IV in BookkeepingAccounting in the past

I remember the days when MYOB was a young company called Data Tech Pty Ltd, they were based in Crows Nest and gave trials of their software on floppy disk and videos on how powerful their software was on VHS. It was also an awkward situation if you wanted to become “certified”. Many people learnt how to use the software and offered their services and it wasn’t until you had a couple customers under your belt that you could become certified by MYOB. This scenario is now very different.

Education businesses around Australia (and New Zealand) now have strict guidelines to follow when they deliver and assess their training (as part of the Cert IV in Training and Assessment) and there’s a whole new official language which includes: Scope of Registration, Units of competency, Learning outcomes, competency mapping, Core subjects, electives, qualifications, subjects etc. The great news is that we are now “mapping” our training material with the outcomes for the Cert IV in Bookkeeping!

This qualification will be mandatory by 2013 if you plan to perform bookkeeping tasks for a business whether you are an employee, contractor or a small business owner.

In fact to give you an idea of how specific and focussed this new qualification is here are the electives (based on your desired goal):

Contract Bookkeeper
• (FNSICCUS401B) Deliver a professional service to customers
• (FNSICCUS402B) Maintain customer relationship

Small Business Owner
• (FNSICORG510B) Manage own professional development
• (FNSPRAC501B) Manage and maintain small/medium business operations

Permanent Paid Bookkeeper
• (FNSICORG510B) Manage own professional development
• (FNSICCUS402B) Maintain customer relationship

Are you a BAS agent?

You might also be interested to know that “If you provide BAS services for a fee or other reward, you are required by law to be registered as a BAS agent” with the ATO.

Our offer to students

We recently announced the Lifetime MYOB course student membership for all students so you can use our learning resources (including updates as they are created) and now we are happy to inform that we are mapping our training material to the desired learning outcomes for the subjects which make up the Cert IV in Bookkeeping. We’ll be working closely with an RTO (Registered Training Organisation) in a VET partnership and we’ll be able to help you get some fundamental MYOB and accounting skills via our online course, PLUS provide you with a pathway to your Certificate IV in Bookkeeping (including assessment and certification).

Visit out MYOB course website or enrol as a student.

Make sure you subscribe to our blog to receive these articles in your email. If this has been forwarded to you, click the title of the blog post and subscribe at our website.

Posted on by — 6 Comments

LIFETIME membership for MYOB online training course

OldCoupleInLovebyErikclitgaad - lifetime MYOB and Excel training course We use the EzyLearn Blog to announce improvements, additions and updates to existing courses and training services and today we announce LIFETIME access to students who enrol into our MYOB Training Course from today onwards. This feature will be introduced to our other courses during the year.

It’s finally here. We’ve made some improvements to our MYOB Training course during the New Year period and are thrilled to announce the latest and greatest feature in online MYOB training. “Lifetime membership” for our online MYOB training course.

Lifetime membership means that after you have completed your course you are free to use the training site as a resource for the rest of your working life! As new content and online learning resources are created, you will have access to these resources for no extra charge.

If you agree with us that this offer is amazing share it on Twitter or Facebook and tell your friends. Otherwise head over to our online training course website to learn more about what we offer OR test your MYOB skills using our free MYOB online training skills test.

EzyLearn: That’s how easy it is.

Posted on by — Leave a comment

Recommend us for a reward

These days you can promote the fact you like something very quickly and easily. Twitter and Facebook accounts are free and almost everyone knows how to use them. Established blogging platforms like WordPress and Blogger are also easy and free to setup but there are even simpler microblogging platforms like Posterous.

What’s so good about all this new technology that is available? It means you can sign up for affiliate accounts and start earning money from referring good quality website to people you know or are connected to. Here’s a link to a post we wrote earlier this year which explains a bit about how affiliate marketing works.

We are trialling a new affiliate service for our online MYOB course and the reward is $25 for a successful sale from your recommendation. Don’t worry the affiliate management system keeps track of your referrals. Here’s a link to the affiliate website.

Posted on by — Leave a comment

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

Posted on by — Leave a comment

Google saves you 2-5 seconds with Instant Search

The innovator in searching through millions of web pages to find the most relevant yesterday introduced Google Instant, a way of providing you with results before you’ve even finished typing. In other words Google has a pretty good idea what most people want to find when they start typing and reveals the results as you type. Great for slow typers this new feature will give you relevant results right there on your screen.

We are pretty proud of our search engine placement for online MYOB course so please feel free to do a search using the new Google Instant and see our website appear on the first page of search results.

I tried using the search and it was fascinating watching the search results change so quickly. When I tried it a second time it just worked like the normal Search results. Go and visit the Google Instant Search page or read Google’s announcement on their blog to learn more.

Posted on by — 2 Comments

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

Posted on by — 2 Comments

VoIP Phone System from Virion

broadband speed test for voip phone system
is your internet fast enough for a voip phone system

We’ve updated our telephone system to the latest in Cisco IP phones and want to share the information with you because we think it’s ground breaking. We use our Broadband Internet connection to make and receive all our calls and that throws out the window the old concept of paying Telstra almost $40 per month just to have a telephone number. I was only just explaining to a friend today how the VoIP phone system from virion works and I’ll try to explain it again in this blog post.

Your Broadband Internet connection delivers the voice to your phones and takes it away to the people you call so this link is critical in the quality of your voip phone system. The best way of testing the quality of your broadband internet connection to run a speed test and see how fast your upload speeds are. Yes, I did say upload speeds. Most people want fast download speeds to download videos, emails and attachments, but with a voip phone system you need to have a broadband connection with good upload speeds.

In this diagram the upload speed is 0.81Mb/s (810Kbps) and the best quality VoIP phone system requires 87.2Kbps, so,theoretically 10 people in your office could be having phone conversations with your VoIP phone system using your broadband internet. But what if someone is sending an email with a huge attachment? I’ll keep you up-to-date with our VoIP experience as we use it.

If you want to test a business grade VoIP phone system and VoIP service take advantage of virion’s Instant Trial.

Posted on by — Leave a comment

How to convert a document or spreadsheet into a PDF file

If you are receiving this post as an email, click on the heading to go to our blog site and see the video that comes with it.

The benefits of a PDF file are:

  • most computers in the world will open it,
  • it maintains the look and feel of anything you can view on the screen and
  • it stops people from editing your files

Adobe Systems Incorporated are the owners of the PDF (Portable Document Format) standard and they have traditionally made money by making the viewer program available for free, but charging for the program which actually creates the PDF files. This is common with many other programs like Flash (for website animations) where you can download a player to view them, but you have to buy the software if you want to create them.

There are a number of applications available which allow you to easily convert any file you can print into a PDF. These files don’t necessarily have the full functionality that is available with the Adobe Acrobat “creator” software but many people don’t need these features.

The program we have found is CutePDF and the video attached to this post (click here or on the title if you are viewing this as an email) shows you how to download the program, install it and use it to convert files to PDF. Please feel free to send us some comments if you know of a better product or want to share your experiences.

Posted on by — Leave a comment

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.