Search Results for:

Posted on by — 2 Comments

Using Microsoft Excel to calculate Payroll Liabilities like PAYG, Medicare and Super

Excel Training Quick Tip

Payroll Categories and amounts using Nested IF STATEMENTS in Excel Training
We recently created an Excel spreadsheet to demonstrate how to calculate the amount of PAYG, Super, Medicare levy and Flood Levy payable by a company for it’s employees based on an employees gross yearly income. It’s  an excellent example of using IF STATEMENTS and NESTED IF STATEMENTS.

You can change the gross annual income and watch all the other figures change automatically.

We’ll be using this information in our MYOB Payroll Training Course which will undergo a huge update this quarter. If you are a small business owner you can calculate your PAYG obligations on a spreadsheet and then enter the pay transaction as a journal entry or spend money in your MYOB software.

This Payroll, PAYG, Super excel file is now freely available to students of the Microsoft Excel Online Training Course, just log into Course 306 which covers IF STATEMENTS. Remember if you are an MYOB training course student you can enrol into our Excel training course for a discount. See the Course Outline for MYOB Day-to-Day (existing students only) for the details of how to claim your discount.

Posted on by

What does EzyLearn have to do with Starfish’s?


Seth Godin and the long tail, EzyLearn is a starfishIf you are into new technology and you like to know what is going on there is one man who write regular blogs from his experiences working with new technology. His name is Seth Godin and he has over 123,000 Twitter followers. Whether you use Twitter or not, this man has a wide influence and many of his very short blogs are inspirational for business owners and anyone who wants to create something.

Seth wrote an article recently about the differences between Starfish and the long tail. If this is all starting to get a little weird don’t worry, these terms are used in Internet marketing circles to describe the business model you are in and we’re mentioning it here because it confirms our commitment to be the best at a handful of online training courses: Microsoft Office (Excel, Word, PowerPoint and Outlook), MYOB Accounting, and WordPress website design and blogging. There are many companies who promote courses online and that’s what they do, promote courses online, we try to be a little different and here’s why:

  • We offer a handful of courses and do them very well
  • Our courses come with LIFETIME membership
  • As a student you get new content without paying extra
  • Where possible we provide real life exercise files so you can work with the software

We launched the EzyLearn Q&A service as part of this commitment and it’s designed to do two things:

  1. Provide existing students with an opportunity to ask questions about topics that may not be included in our course content
  2. Increase the value of our training courses to students by keeping them current and relevant.

 

Enter your email address:

Delivered by FeedBurner

 

Posted on by — 3 Comments

How’s your resume looking?

Resume writer and writing service
Resume Template

Find a job or become more valuable

Apart from our corporate customers who have their staff training on programs like Microsoft Excel to improve their productivity, many students complete their MYOB accounting or Excel spreadsheet training courses to make them more employable because they are in search of work. Their circumstances vary and include:

  • Advancing from one position to a better one,
  • Being made redundant and in search of a new job,
  • Returning to the workforce after bringing up a family
  • Want to work from home while bring up a child

Resume Writing

We are in a great position to help you with your resume writing because we understand the employment market and the needs of employers and we have team members with excellent writing skills. Some of our EzyLearn team members have written resumes and application letters for students and we want to know if you or a friend of yours needs a resume written (or re-written).

Read more about EzyResume combined resume writing and online Microsoft Word Course and use this discount voucher (eler1) to receive a $50 discount. This offer is valid for a limited time only, so be quick.

Share your resume writing experiences with us

Many of our students are looking for work in an administration and bookkeeping capacity so the format for the resumes are fairly consistent. Have you had an experience where you learnt something valuable about what to include and what not to include in your resume?

If you want to share your circumstances (including the success of your job hunting) with us please send visit the EzyLearn Online Training Courses Facebook page and let her know your successes or if you need a resume to be written.

We look forward to hearing from you.

See other blog posts we’ve written about writing resumes and tools to help you find a job.

Linkedin: Will it replace your written resume?

Social-Media and online MYOB Training coursesIn the course of our business we’ve used Linkedin to find people with certain skills and after speaking to recruitment offices and HR personnel we’ve discovered some interesting things about linkedin and how it can help you get the job (or customer) you’re looking for.

Posted on by — 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 by — 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 by — Leave a comment

New MYOB Training Content available for all students

MYOB Training Course Bank Reconciliation Tutorial Screen

If you are enrolled into our online MYOB training course you’re probably aware of our LIFETIME access feature. You might also recall that this feature enables you to log in at any time and have access to any new or updated content that we create.

We’ve just created training video tutorials for our MYOB bank reconciliation course!

The training workbook for the bank reconciliation course contains a project where you can create a new company file from scratch, import an accounts list (Chart of Accounts), import transaction journals and then enter your own transactions to complete a bank reconciliation. It’s a very satisfying feeling!

Here is a list of the 9 new training videos we created. If you are a student you can simply click on each video, sign-in and start watching.

  • Section 1 Video 1 – Export and Import using MYOB
  • Section 1 Video 2 – Working with Read Only MYOB data files
  • Section 1 Video 3 – Exporting Accounts List and Transaction Journals
  • Section 1 Video 4 – Exploring Exported MYOB Accounts list Data
  • Section 1 Video 5 – Create a new training company datafile
  • Section 1 Video 6 – Importing an accounts list into a new MYOB data file
  • Section 1 Video 7 – Importing the Transaction Journals into a new MYOB data file
  • Section 1 Video 8 – Deleting duplicate accounts and changing linked accounts
  • Section 1 Video 9 – Setting Linked Accounts for GST

    •  

    As part of our continuous improvement process we are now hosting our videos on a dedicated video hosting platform and the videos can now be paused and played and you can enable them to take up the full screen for easier viewing.

    Happy Learning!

    To learn more about our online MYOB training course and the fantastic new features like LIFETIME membership, EzyLearn Q&A and more visit: http://ezylearnonline.com.au/courses/myob-training/

    [button link=”http://ezylearnonline.com.au/courses/myob-training/”] MYOB online training course[/button]

    Posted on by — 1 Comment

    How-To Guides: Writing a killer resume?

    Example of a Resume CVIf you are like a lot of students who enrol into our online MYOB and Excel training courses you probably haven’t used your CV in quite a while. I had a situation in 2008 when I needed a CV for a project I was presented with and it was a time consuming task which took a lot longer than I expected.

    We’ve been talking to a man who operated his own head-hunting business and he has plenty of experience in not only presenting himself to potential employers, but also as a person who reads resumes, and conducts interviews on a day to day basis.

    We also spoke to a professional writer and a rehabilitation consultant and they will share their insights as well as provide tips on how to write the perfect resume, prepare for job interviews, write cover letters and much more. Their team even includes a professional bookkeeper who will share insights about how to find work as a bookkeeper.

    These career professionals are team members of our training partners, Workface, and you can read their job seekers blog as well as subscribe so you receive the tips via email.

    One of the tid-bits that I can reveal is the importance of personalising every resume so that the recipient feels like you are talking only to them. Subscribe to their blog and get some great job seeking skills.

    Want to read other blog posts about resume writing and tips and tricks to find employment?

    Posted on by — Leave a comment

    Selling horse feed in the internet age

    We’re in the internet age whether we like it or not. Our internet connection is as valuable to us now as our power supply and our telecommunications and it’s important to have a website if you are in business. In this post I want to introduce you to a small operation in King Island in Tasmania. A company that sells Kelp is learning how to play the internet game and best of all you can learn with them.

    Kelli has a WordPress website hosted with 123ezy and we are building our WordPress and Webmaster Course around her growing internet presence. To start with we have created some elementary training videos about the navigation around the WordPress themes and what different parts of the website are called. We’re learning about themes, header images, menus and widget just to get started. As we progress we’ll be talking about Pages vs Posts, tags and categories, working with images, Search Engine Optimisation and much more.

    We’ve included our Introduction to WordPress video below so if you are reading this on your phone, click on the heading to get to our Blog page where you can watch the full video.

    Posted on by — 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 by — 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 by — Leave a comment

    Are you safe in your office?

    I always thought the office was the safest place to be. No heavy machinery, no flashing lights and no hard hats gives you the sign that an office is a pretty safe to be. The pressure of deadlines however and increasing piles of work, working close to the same people all day, every day and the anxiety of dealing with people both personally and professionally could make you feel unsafe.

    I was having a chat with Brendan from our new EzyLearn Business Partner – AlertForce Pty Ltd – and he pointed out some of the issues that arise in the workplace, he also proudly commented about the success they are having with their online safety courses. Brendan pointed out

    “Every year thousands of office workers are involved in incidents and accidents that result in long-term injuries”

    and when he explained some of the common causes they seemed pretty logical to me. The key with safety training though is even though it seems logical some of the basic safety principles must be explained and followed by everyone in the office. The one that stands out most to me is the proper method for lifting boxes (they call it manual handling), it’s simple, everyone knows it, but it takes a little extra effort. I think it’s worth it.

    Another EzyLearn Business Partner, Registered Training Organisation Maxis Solutions at Chatswood offers a range of courses in many different occupations. Maxis Solutions owner, Pam Gum, pointed out to me that Occupational Health and Safety is included in Certificate II level courses in Business and Information Technology (IT) and it can include simple things like stretching and giving your eyes a break.

    So, take a look around and see if you can spot the safety issues as they occur.

    Posted on by — Leave a comment

    MYOB online course videos – Accounts list is your chart of accounts

    Even if you have used the MYOB ‘default’ to set accounts details for your company you can still change the account details after entering your Company details. This comes in handy especially if you receive account details after from the company accountant. MYOB allows you to import this new list, just click on import list.

    When selecting the type of business for your company in the Accounts list, MYOB will change the accounts relating to that business accordingly.

     

    Video Reference: 501103

    Link for existing students: http://myobcourse.com/elearning/mod/resource/view.php?id=350

    For information about our Online MYOB Training Course and new lifetime membership for all students please visit: www.studymyob.com.au

    Please feel free to send your comments to us about this video to sales@ezylearn.com.au

    Unable to display content. Adobe Flash is required.

    Posted on by — Leave a comment

    MYOB online course videos – Company information & 13th period

    Make sure all accounting details are correct in the company details. You will not be able to change any details once entered and saved. So the rule here is check and double check all details are correct.

    Did you know that in MYOB there is a 13th Accounting Period? This is not another month but is an accounting period where you can make any accounting changes if needed.

     

    Video Reference: 501102

    Link for existing students: http://myobcourse.com/elearning/mod/resource/view.php?id=349

    For information about our Online MYOB Training Course and new lifetime membership for all students please visit: www.studymyob.com.au

    Please feel free to send your comments to us about this video to sales@ezylearn.com.au
    Unable to display content. Adobe Flash is required.

    Posted on by — Leave a comment

    MYOB online course videos – Create New Company File using MYOB

    When setting up a new company in MYOB the only section which is required is the company name. This is handy to know especially when entering a number of companies. Once entered, you can go back and fill in the details.

    Clicking on the next button allows you to go to the next section which makes data entry easier and quicker.

    Video Reference: 501101

    Link for existing students: http://myobcourse.com/elearning/mod/resource/view.php?id=348

    For information about our Online MYOB Training Course and new lifetime membership for all students please visit: www.studymyob.com.au

    This video is taken using version 15. Check with the latest version and you will notice very little difference in this process. Please feel free to send your comments to us about this video.
    Unable to display content. Adobe Flash is required.

    Posted on by — 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 by — Leave a comment

    Online MYOB training for New Zealand students

    We’ve had some inquiries and enrolments from New Zealand students and this blog is to help you understand some fundamental differences between Australian and New Zealand versions.

    The first thing you need to be aware of is that the knowledge review questions used in our MYOB Payroll Introduction (course 505) use the sample company file which comes with the free MYOB Test drive. From discoveries made by our New Zealand students the sample file contains different information in different countries. You need to use the Australian version to get the correct answers.

    This brings another problem, when you try to download the Australian version of the test drive you need to enter a phone number. One of our students entered our telephone number as the contact number and we have no problem with you doing that if you are an EzyLearn student. If we hear something different from MYOB we’ll let you know.

    I should also mention at this point that this might also apply to our students from Canada, China, Korea, UK and other parts of the world.

    If you want to take a look at what students have said about our course click here.

    If you want to receive these updates in your email, subscribe to the EzyLearn blog here: https://ezylearn.com.au/