Posted on Leave a comment

Graduation & feedback for Online MYOB Training Course

Graduating Students

We want to send a congratulations to some of our students and their success in our online MYOB training course and all the best for their future using the software for bookkeeping and managing company accounts. If you are seeking new employment we also wish you the best in your searching, resume writing, applications and interviews. Congratulations to:

Katya (ACT), Katayou (NSW), Linda (QLD), Veronika (QLD), Jenny (VIC), Denise (NSW), Natalie (NSW), Jacqueline (WA), Sara (NSW), Gopan (NSW), Matthieu (QLD), Kelly (NSW), Rhonda (QLD), Sarah (WA), Pia (VIC), Wayne (QLD), Geri (WA), Kerry (VIC), Robyn (NSW), Darlene (NSW), Celeste (NSW), Michelle (NSW), Cassandra (VIC), Angela (WA), Erica (WA).

What students say

We also want to share some of the comments that current students have made regarding what they enjoyed most about our course and training material:

“My experience with Ezylearn was great. I am going to recomend your website to all my friends and family members”

Katayoun

“All of the course information and also the knowledge tests”

Geri

“(The best part of the course was) the walk through videos”

Celeste

“The explanations were good”

Gopan

“I thought the course was very thorough and easy to find information especially if I need to review a task… It was very convenient to do the course in my own time when i had available…. and at my own pace”

Veronika

“Having workbooks to supplement the videos and able to practise simple exercises. Also, the opportunity to be able the myob program for free rather than having to buy it”

Michele

“Steve is quite good and makes the video enjoyable and makes it easy for me to learn how to navigate around MYOB”

Linda

“Ease of use. Convenient – study when you feel like it and have the time to do it. The videos are easy to follow even though I was using a (different) version of MYOB than those in the videos. This didn’t seem to matter because differences between them were very basic, and are mostly only aesthetic”

Jenny

“Easy to understand”

Natalie

“Most of the course was good and the support documention is helpful so I can alway go back to it”

Denise

Scheduled Improvements

Don’t worry, we’re not sitting on our laurels just because students have praised our online training courses. There’s also lots of work to be done to make some parts of our courses even better and we want to let you know about them:

  1. New content for the online MYOB training course (including Payroll and Reporting)
  2. More practical Microsoft Excel exercises for things like PAYG and manipulating MYOB reports
  3. Demonstrations on how to perform some calculations in Excel and enter them manually into MYOB
  4. More website measurement statistics for WordPress courses using Google Analytics
Please feel free to send us some suggestions.

 

Posted on Leave a comment

Creating images with transparent backgrounds using freely downloadable software

FREEBIE: We thought we’d share this demonstration video with you because it is very handy when working with images for your website.

GIMP is an open source image editing program that gives you very powerful functionality for editing images. Get to know a little about this program and you won’t need to struggle with Paint or pay for Adobe professional image editing software. This video is one of the free videos in our online WordPress training course.

You’ll want to use this when you want your logo to appear in a WordPress website. There’s nothing quite so unprofessional as a logo with a white rectangle background behind it.

Enjoy. If you receive this information via email and cannot see the video, click on the title to read this at our blog site.

 

Posted on Leave a comment

Another 11 training videos about image editing, featured images and WordPress premium themes

WordPress online training course

NEWS FLASH: Yet another 11 training videos have been added to our WordPress Training Course!

Only recently we announced the addition of 23 new training videos for our online WordPress training course and that is only shortly after the launch of our exciting new website design and blogging course. Why are we populating this course so vigorously? Because we are working with 3-4 students who are building their live sites right now using the content of our course, everytime they come across a stumbling block, we solve it and create more content for our online course. LIFETIME student membership means that you get access to all these new training videos at no extra charge EVER.

This time we’ve focused on teach you how to work with images to get a really professional looking website using a featured slider. We’ve provided  great sources online for royalty free images, show you how to get images in just the right size for your website AND get the featured slider working with our recommended premium themes.

Here the video list and if you are an existing student you can simply click on the link, login and get straight to the new learning resources:

If you are not a student yet, but you want to learn more visit our website dedicated to our WordPress online training course.
Remember that you can subscribe to these blog/news posts by visiting our blogsite at www.ezylearn.com.au/wordpress.
Posted on Leave a comment

We’ve just added 23 training videos to our online WordPress Training course

NEWS FLASH: If you are an existing WordPressCourse.com.au student you’ll be thrilled to hear that we have created and made available 23 new videos about becoming an expert in WordPress. These new videos are available to you at no extra charge and they are part of our growing range of WordPress, Google and Social Media topics that are coming shortly.

The topics we have covered in this videos includes:

  • Blogs, Posts and RSS Feeds
  • File Management and File Transfer Protocol (FTP)
  • Website Statistics and Google Analytics
  • Backing up your website
  • Features of Elegant Themes Premium Themes
  • Social media and commenting
Nareev Bhatt was one of Australia’s top bloggers back in 2009 and he and other top bloggers like Karen Cheng use a simple website with Google Feedburner to deliver their news to anyone who wants to read it. This course will show you how to have your own newsletter using your WordPress Blog and FeedBurner.

This video from Channel 10 in 2009 explains how three popular bloggers make a lot of money by working from home.

 

 

Read more about our WordPress Training Course and join in to take advantage of our current prices and LIFETIME student access

Posted on Leave a comment

Navigating the EzyLearn Online Training Site

Come on a short journey to learn how to navigate the EzyLearn Online Training website. We’ll take you on a quick tour so you know what to expect as a student when you start your training with us. You’ll see one of the great benefits of joining and having at your disposal a learning resource for the rest of your working life.

Your student administration area enables you to quickly jump from course to course if you wish and the bread-crumb menu at the top gives you complete knowledge of which course you are in and gives you the ability to get back to your home page and course outline.

Take a look at our popular online Courses in MYOB Accounting, Microsoft Excel spreadsheets and WordPress website design and blogging: http://ezylearnonline.com.au/courses/

Here’s the video on how to navigate our training website.

 

Posted on 1 Comment

How valuable are words?

It seems that Google has brought back the magic of words. Why? Because they can be indexed and used in search results.

Can you index an image or a video? You can, but you need to index them using words.

You can find almost anything on Google but you need to use words to do it. When you click on a paid Google Adwords advertisement its usually due to the words the advertiser used to catch your attention. If you want to improve your Google organic search ranking you need to use the right “key”words on your website, they call that Search Engine Optimisation (or SEO).

Keywords, SEO, marketing, Google Adwords, resumes

Can someone in the Phillipines, India or Eastern Europe Write Like You?

You might be aware of the value of words these days because you need this skill to be effective in marketing your business online. The role of the copywriter is often undervalued because you can now hire someone in the Phillipines, India or Eastern Europe to write the content of your website or blog for a couple dollars per hour, but would you? After testing out individuals, copy-writing services and other international contracting companies we realise that the quality of the words we use and the ability to relate to other Australians is something only another Australian can truly do effectively. With all the talk about workers in developing countries taking jobs away from Australian workers, we realise that it’s their knowledge of Australian lingo, Australian tastes and Australian attitudes that makes their writing style truly Australian – and that makes it valuable to other Australians.

Work at Home

There is a way of getting good quality words for your website or blog for a reasonable price and that is by using a Virtual Assistant (sometimes called a remote worker, home worker or a remote contractor). There are some great writers out there who choose to work from home and if you use the services of an organisation like Virtually Yours you’ll find top quality writers and remote contractors with many other skills that are part of an organisation designed to find good virtual assistants and promote them as well as provide them with tools to be effective small business owners.

While we are on the topic I want to share the success of Terry from Ramancorp. He operates a small wholesale business supplying a range of framing, hanging, display and packaging materials and he lists them all on his website. Because he has gone to the trouble of providing as much information as possible he uses some very niche words that attract customer looking for the exact product they need. As a result Terry is getting a good amount of NEW customers EVERY month without having to pay a cent in Google Adwords advertising.

Words are Valuable in Resumes, Website and LinkedIn

Words are just as valuable in your resume so the next time you think about what kind of job you are looking for, think about the words that the advertiser might use to attract the right candidate and make sure your resume has these words in it.

Posted on Leave a comment

EzyLearn Provides Online Microsoft Excel Course for Bookkeepers Institute

Institute of Certified Bookkeepers - online Microsoft Excel Training CourseAs an Accredited Training Provider for the Institute of Certified Bookeepers, we are proud to provide our online Microsoft Excel course to the institute as part of their Professional Development Program.

Along with all levels (beginners to advanced), members of the Institute of Certified Bookkeepers also receive the LIFETIME Membership and other benefits that come with being an EzyLearn student. Microsoft Excel is a perfect companion for accounting programs like MYOB Accounting.

For more information about EzyLearn Online Microsoft Excel course, please visit our Excel course website.

Posted on Leave a comment

Microsoft Excel Online Training Course: LIFETIME Student Access & Start Tomorrow

Common Questions for Computer Courses

Can I repeat the course if I don’t remember everything that is taught?

This was a common question that came up when we had our three Sydney based training centres. To make it easier for students we offered Free Repeats so that students could come back and learn the skills again. We then created training videos to complement our workbooks and in 2006 we closed our last training centre to focus on Online Computer Training Courses.

Can I start the Microsoft Excel course this week? I have Mondays and Wednesdays available.

This is a question about timing scheduling your calendar for an available course and we overcame this by recording the content of our classroom Microsoft Excel and Office training sessions as screen based videos so that students could come and visit whenever THEY had the time, not when WE scheduled the courses.

Online Microsoft Excel and MYOB training courses

With Broadband Internet and fantastic new learning technology we are able to delivery Microsoft Excel Training to you via our online course. This means you can enrol today and start by 5pm tomorrow. It also means that you can progress through the training course at your own pace using a combination of training video tutorials, training workbooks with exercise files and knowledge reviews to test your skills.

Who uses EzyLearn for Microsoft Excel Online Training courses?

Government departments, insurance companies, private companies and home users all use EzyLearn Online Computer Training courses. We recently interviewed a corporate training customer to find out why and this Case Study reveals how a leading energy reverse auction company, Energy Action, used EzyLearn’s Microsoft Excel training to manage the large amounts of data they receive to save their customers tens of thousands of dollars in energy costs: Energy Action Case Study

Posted on 1 Comment

EzyLearn’s Excel Course: Helping Energy Action Show Savings in Energy Cost and Consumption

IN THESE TIMES OF GLOBAL WARMING the need for businesses to reduce energy consumption and greenhouse gas emissions has never been more important.

Australian company, Energy Action, prides itself on helping businesses reduce energy usage and save money. Energy Action provides an innovative flagship service it terms the ‘Australian Energy Exchange’ through which energy suppliers can competitively bid against one another for the supply of an organisation’s energy. With a best-fit contract usually secured in only 15 minutes, more than 5000 businesses have now partnered with Energy Action to maximise their energy savings, culminating in more than $5 billion worth of energy contracts.

Energy Action provides their clients with quality monthly reports showing clients’ energy demand, power factor, load factor, energy consumption, emissions and more. Their daily monitoring flags when clients’ demand targets are approached or exceeded.

Microsoft Excel Online Course 308 - pivot table value field settings
Microsoft Excel Online Course 308 - pivot table value field settings

Read how Energy Action staff learnt about Pivot Tables and Charts, Conditional Formatting, VLOOKUP and much, much more to provide a higher level of knowledge to their customers: Energy Action Case Study

Posted on Leave a comment

MYOB Training Course: Dedicated video tutorial server

Are you happy with your current skills?

Do you like to learn new things?

We’re the same. We love to come into contact with new software and internet technology and anything that will help us to remain a market leader in online MYOB training. We also like to receive feedback (positive and negative) from our students so we know what we are doing well and what we can improve on.

Recent feedback has been about the navigation around our online training video tutorials. These videos are full audio visual demonstrations using the software, just like you would expect in a training classroom using a data projector.

With online training video tutorials you can go over our material again and again until you understand it. You can also go over it in the future when you come across a problem you need some help with. Combine it with our step-by-step training exercises and knowledge reviews and you have a complete learning solution.

So, what’s the news?

[box] We’re putting all new content and upgraded training course materials onto a new dedicated video hosting server![/box]

What does this mean?

It means that the videos are hosted on a separate service to the learning course so that both will operate much faster. All new training videos will also have a navigation panel and the ability to scroll through the video to the place you want to be and finally you’ll be able to expand the video so that it takes up your entire screen.

What the video below to see what we mean.

Posted on Leave a comment

MYOB Training: Exporting MYOB Data for an Excel Mail Merge

MYOB Training Course Exported Accounts list

We recently created 9 new training videos for our online MYOB training course and one of them demonstrated how to export and import data from an MYOB training company datafile. Exporting and importing is used to extract transaction and sales information and also customer or supplier card files from MYOB to use with Microsoft Excel in performing mail merges.

We have included the simple accounts list that we use in our online MYOB bank reconciliation course as a file you can download and open up in Notepad or Microsoft Excel. The image above shows what the file looks like when opened up in Notepad. It’s called a TAB-DELIMITED text file and this example includes a header record that gives you the name of each field (column)

ACCOUNTS

If you want to learn more about TEXT format (including CSV – comma separated values) files and how to manipulate this type of data using Microsoft Excel, take a look at our Microsoft Excel course 307 (visit this link and scroll down until you see the course contents of course 307: http://ezylearnonline.com.au/courses/microsoft-excel/excel-course-outline-2/).

If you need training on Microsoft Excel and data storage types you’ll be thrilled to hear that this course is one of 9 courses that are all included for one low price and LIFETIME student membership at the EzyLearn online Microsoft Excel course. Click here to enrol.

Posted on Leave a comment

MYOB Training Q&A: Printing Cheques using MYOB

MYOB Training Online - Printing cheques
Image of a cheque from http://www.afl.com.au/tabid/208/default.aspx?newsid=55721

We recently introduced the EzyLearn Q&A service for our MYOB online training course students to give you more specific answers to your MYOB questions. The service is available for existing EzyLearn students only and there is no extra cost for this service. If you are an existing student and you need an answer to an MYOB question please feel free to use the service!

One of our students in Perth is having some issues printing cheques and the bookkeeper for their organisation is being a little cagey with the information so we jumped in to help.

In a nutshell you need to make sure that whether you create a cheque from the banking module or the Purchases module, you need to ensure that when your payment is entered that it is NOT marked as printed. So that when you do search for Cheques to be printed the one you want will show up.

Keep the questions coming and stay tuned to the EzyLearn blog (register to receive them automatically) to see what MYOB Online Training students are looking for.

If you are an existing student simply follow this link to see the Printing Cheques using MYOB training guide we created to answer the question. Just log in with your student login details.

Posted on 1 Comment

You should now have your certificate

Iroshini - Online Training CoursesYou may recall that we identified a GAP in our internal resources last week (ie. we needed an extra team member) to help us with the backlog of assessing and issuing of certificates for our online Microsoft Excel and MYOB training courses.

Well, here she is Iroshini has performed small tasks for us over the last month or so, but she’s now on board to ensure that the results of knowledge reviews are assessed quickly so that you can receive your  certificates faster. The result is you should have your certificate now 🙂

Our Online MYOB Training Course has proven to be extremely popular and along with the announcement of Iroshini’s arrival we want you to know that we are currently building our MYOB Payroll course to include more detailed information about the Payroll liability accounts and how to create and setup a new employee, and create the pay slips.

All of this new content will be available for existing students at no extra charge as part of our LIFETIME Membership offer. Stay tuned also for announcements about our new Microsoft Excel Online training materials… We have some new content in our advanced Microsoft Excel courses, some new knowledge reviews and updated training workbooks.

 

Posted on Leave a comment

Online MYOB training is better than just CD’s or workbooks

In the evolution of our online training courses we originally started with a flash based player that operated in our training centres. It was easy to use and accessible on all computers. We then took a look at how to deliver the same consistency of experience using our training videos in your home, an environment that could be completely difference and that we have no control over. At first we thought about CD’s and after trying some different technologies, we came to the realisation that the experience different from user to use and computer to user. Will online learning really be the best way?

One issue that we came across in delivering our courses online was whether customers have a good enough broadband connection to receive the relatively large videos files through to them. The other question we had was how long should students have access to the training materials. In the end, we decided to go as OPEN as we possibly could. We opted to use technology that would enable all students to access the materials, whether they were on a Windows based computer or Mac.

The result is that you can now use our training material for life (no need to try to locate those scratchy CD’s) and you can use a combination of videos (with live demonstrations and audio commentary), Workbooks (with actual exercises you can try) and Knowledge Reviews (to test your skills) and it works on all platforms.

See our online MYOB training course outline.

[button link=”http://www.myobcourse.com.au/training/page_enrol.html”] Enrol into our online MYOB course[/button]

Posted on 5 Comments

Do you have an MYOB bookkeeping question?

When we introduce a new service linked to our online training courses we announce it here at the EzyLearn blog. Today we announce the EzyLearn Q&A Service for the MYOB Accounting Course. This service will be rolled out to all online courses over the coming year.

This is the time of year that forces most MYOB questions to the surface. It’s the time of year when all of a sudden you need to know how to enter a transaction or where to put a value.

EzyLearn’s online MYOB Training course is popular because the lifetime membership gives you the ability to go over the material as often as you like and when you like. It also gives you access to new material that we create. Businesses vary greatly and the needs of each small business are very different and we want to do something about it for you.

Our partner program puts us in touch with many people in the accounting, training and bookkeeping sectors and we are introducing  a new trial service called MYOB Q&A. The service is only available for students enrolled into our online MYOB training course and it works a little like this:

  1. Go to any Learning Outline page in the learning site
  2. Look for the MYOB Q&A section on the right
  3. Enter your details, the category of question and type in your question.

We will do our best to work through student questions with a Certified MYOB consultant to provide you with even deeper knowledge about how to use MYOB.

See what’s included in our online MYOB training course.

Enrol into our online MYOB course today and start learning by 5pm the next business day.

online MYOB training course and support communityUPDATE: This service, available to MYOB, WordPress and Excel students is now called EzyLearn ANSWERS.

Posted on Leave a comment

Advanced Excel: eliminating errors in functions

Microsoft excel online training course

Forward this email to your friends so they can subscribe themselves. Click on the heading to visit the EzyLearn Blog

One of the most efficient features available in Microsoft Excel is the ability to create a formula and then copy it into a large number of subsequent cells. When you perform a dbroad copy and paste like this, Depending on the type of data, you’ll get either a #DIV/0 or a #VALUE error if the source cells don’t contain the correct data. You could scan the spreadsheet manually and modify each cell that contains such an error or use the IFERROR function when creating your original formula.

The IFERROR function is composed of two parts – the original function that you wanted to create (such as dividing two numbers) and a value to use when this function doesn’t make sense (like trying to divide by 0 or a word).

Let’s take a basic table of data that contains three columns. The total amount of a restaurant bill is in the first column, and the second column is comprised of the number of people in the party that received the bill. In the third column, we want to calculate the price per person.

Advanced Excel Functions - IFERROR - online Excel course

Task: Use the IFERROR function

(1)     Create the spreadsheet above using the data in columns A & B.

(2)     Perform a simple calculation to divide the Total Price by the number of people to get the answer in Colum C

(3)     Notice the error messages

(4)     Click on cell C2 and type the following function =IFERROR(A2/B2,”Unknown”)

(5)     Use the fill handle to copy it down the column. Notice that where-ever the error normally occurred; it has been replaced by the word Unknown.

(6)     This time try =IFERROR(A2/B2,””) and notice that the cells where an error occurred are now showing no value.

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 trained 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.