Category: Online Excel Training

Posted on by

Excel Can Prove that Granny Flats Don’t Always Add Value

Using Excel to Financially Forecast the Viability of Your Investment

financial forecasts excel online training course
Excel is the tool you need for developing a feasibility study so you can assess the viability of any kind of investment.

When you are planning to invest in a project, you naturally have to weigh up the risks. One of the chief ways of doing this is to complete a financial forecast to determine the viability of your investment. One type of investment that has been exceedingly common and popular with the current property boom has been the investment in a granny flat.

Many homeowners and investors who own a property with adequate room and the right conditions, have chosen to build a granny flat on their existing property as a means of earning extra income.

In our Microsoft Excel Intermediate Training Course, we feature a brand new case study, using a granny flat as a way of demonstrating how you determine the viability of an investment.

Granny flats earn income, not add value

Of course, you need to consider whether you’re legally allowed to rent out a granny flat, which in some Australian states — Victoria, South Australia and Queensland — you aren’t. If you’re found renting a granny flat in any of those states, your local council can ask you to remove the granny flat from your property.

You may determine that a granny flat will earn around $12,000 a year in rental income, but it could take up to 10 years to break even on construction costs. Although some of those costs can be deducted as expenses and the dwelling depreciated over time, depending on where the property is located, property values may not increase by that much. This is amplified if you’ve just purchased the property, compared to a person who’s owned their property for 5 or 10 years.

Granny flats can reduce your rental return

Depending on how the granny flat has been constructed, its proximity to the main dwelling, and whether there are any shared or common areas, there’s also the potential to reduce the rental income on the principal dwelling. If the property has been previously tenanted, the shift from single to dual occupancy will reduce the rent of the principal dwelling. This could be offset by the existence of the granny flat, however, it moves the goalposts for your break even date. You may also experience more tenant churn, which will see more of your rental income going to real estate agents in letting fees, and greater wear and tear on the dwellings. You may also experience longer than average vacancy rates.

How to develop a financial forecast that can be used to determine the viability of a granny flat as an investment is covered in our Microsoft Excel Training Course, with its new Investing in a Granny Flat Case Study. Visit our website for more information on our full suite of online training courses. And don’t forget — EzyLearn online training courses can be counted towards your Continuing Professional Development Points! 

learn excel online training courseAt EzyLearn we are constantly refreshing the content of our online training courses. Where possible, we draw on real-life case studies as examples, to help you learn, and apply your skills, in a relevant way that makes sense. Visit our Micro Courses page to learn more.

 

 

Posted on by — 1 Comment

Linking a Financial Forecast with Xero and Excel

Excel Will Help You Work Out the HOW of Depreciation

learn excel online training courseWe recently updated our advanced Microsoft Excel Training Course content. It now contains a case study, by way of an extra exercise workbook, using a granny flat building project to create a financial forecast.

We chose a granny flat building project for our case study because it’s an investment decision quite a lot of people with or without a business have made. It’s also a capital asset that can be depreciated over time. Therefore it has the potential to affect your taxes in lots of different ways.

Our Excel Training Course, with its granny flat financial-forecast case study, will teach you how to use Excel to create a financial forecast, which you can then replicate for your own investment — whatever that may be.

Your bookkeeper uses Excel to calculate depreciation

When you build a new structure, such as a granny flat, which you intend to rent out or use for businesses purposes — i.e., it’s an investment and not for your own personal use — the building can be depreciated along with some of the fittings and finishes (floorings, curtains, paint, etc). That’s despite the value of the land upon which the granny flat is constructed increasing in value over time.

Once you’ve set up your financial forecasting file in Excel using the correct formulas that will update as the investment progresses, you’ll be able to track all of the future costs, income and depreciation in that spreadsheet.

Input depreciation into Xero

Excel will calculate the depreciation amounts for you, which you should then enter into Xero. We cover how to deal with depreciation in our Xero Bank Reconciliation Course, because lots of businesses own, or will own, a capital asset at some point.

However, this doesn’t tell you how to determine the depreciation amounts, which most business owners have to get their bookkeeper to work out for them. Most bookkeepers work this out in Excel based on the depreciation rates provided by the ATO. However, if you have already created a financial forecast in Excel, you won’t need to get your bookkeeper to do this for you.

Individuals can claim depreciation too

Even if you’re not a business owner, but you’ve still built a granny flat that you intend to rent out, you can claim depreciation in your tax returns. Instead of entering the depreciation into Xero, you’d include it on your annual tax return, so it’s really important that you work this out in Excel first and regularly update it.

***

Once you know how to use Excel for financial forecasting, you can use the same formulas and modelling for any financial forecast — be it for a granny flat project, business investment, anything that requires you to make a financial decision. Visit our website for more information on our advanced Microsoft Excel Training Course, with its new granny flats case study.

Do you want to brush up your Xero skills? Or perhaps you use MYOB but want to get a handle on Xero? Check out our suite of Xero training courses — all available for one low price. 

Online bookkeeping accounting training courses for CPD points

EzyLearn Excel, MYOB and Xero online training courses count towards Continuing Professional Development (CPD) for bookkeepers and accountants. We’ve been an accredited training provider of the Institute of Certified Bookkeepers ever since the organisation started in Australia. Find out how CPD points can be of benefit to you.

 

Posted on by — 1 Comment

Which Granny Flat is a Better Investment?

A Real-Life Granny Flat Construction Scenario

learn excel online training courseChoosing between a one-bedroom and two-bedroom granny flat is a decision you’ll need to make early on in the project, and it’s largely a financial one.

EzyLearn’s Microsoft Excel Training Course includes a new case study, “Investing in a Granny Flat”, which uses the construction of a granny flat as a real life example to help you to better understand how to develop a financial forecast for an investment.

Determine construction and ancillary costs

How much it will cost to construct both a one-bedroom and two-bedroom granny flat is the first step. You need to work out how much it will cost to get each granny flat constructed to the point that someone can move in, as well as any ancillary costs, like council fees and levies, real estate management fees interest rates and so forth.

Determine rental income

Some granny flat companies will give you rental income estimates, but you’re encouraged to investigate this yourself. Rental incomes are heavily dependent on your local area and the demand for that type of property. In Sydney, the demand for rental property far outweighs the demand in regional NSW. Take into consideration vacancy rates in the area and the types of property that are in demand. Areas with high vacancy rates and low demand for one-bedroom units could indicate there’s little demand for a permanently rented one-bedroom granny flat, which will put the rent down.

Determine depreciation amounts

Both granny flats will be subject to the same depreciation rate, however the amounts will differ due to the differing value of each dwelling. In addition to an annual depreciation rate on the dwelling, consider other elements of the granny flat that will also be subject to depreciation. Floor coverings, for example, can be depreciated over time. Carpeting is typically depreciated at a rate of 20 percent, where tiles are depreciated at 2.5 percent because the latter has a longer lifespan.

Determine the best investment

Add all of these costs into Excel to determine the average annual rental yield, expressed as a percentage of the property value. Rental yields are used to show the return on an investment. The higher the rental yield, the better the return is. Taken in combination with your own personal circumstances and plans for the future should help you to determine which option represents the better investment.

***

Our Microsoft Excel training courses, featuring the new granny flat case study, go into much greater detail. Or view our full suite of training courses. 

***

learn excel online training course

At EzyLearn, we’re committed to helping students of all our courses find better employment opportunities, become their own boss and upskill. To this end, we constantly update our courses with new, highly relevant content — it’s why we provide you with the option of Lifetime access you can always refer back to our courses as you progress in your skills’ development. 

We’re thrilled to announce our new Micro Courses which are be added to our existing courses, or can be purchased alone. These are based on real-life case studies and relate to real people in genuine, real-life scenarios. Subscribe to our blog and be alerted of updates.

 

Posted on by — 1 Comment

Calculating PAYG Obligations Without a Payroll System

Third Quarter is Looming; Are You Up to Date with Payroll?

ad hoc payroll payments ExcelMost businesses using an accounting program like MYOB or Xero will use the included payroll package to manage their employees’ payroll. For businesses with only a few employees, however, the additional payroll function is an unnecessary expense.

In our recently updated Advanced Microsoft Excel training courses, we have included a micro course on ‘Ad Hoc Payroll’, featuring a detailed spreadsheet for calculating PAYG and superannuation obligations. In this instance, our micro course is a detailed spreadsheet based on a case study, so it’s relevant and applicable to real life.

PAYG and the businesses it applies to

Every Australian business with employees who are each paid more than the tax-free threshold has a legal obligation to withhold tax on their employees’ behalf. This is known as the PAYG System (or Pay As You Go), where amounts of tax are withheld from each employee’s wage payments.

Businesses that withhold up to $25,000 each year only need to make payments to the ATO each quarter; businesses withholding amounts greater than $25,001 may have to make payments to the ATO each month or as regularly as each week.

At the time of writing, the tax-free threshold is currently $18,200, which is equivalent to:

  • $350 a week
  • $700 a fortnight
  • $1,517 a month

Superannuation contributions

Again, any business that pays its employees more than $450 each month must also make regular superannuation contributions on their employees’ behalf. We’ve written in the past about the government’s clearing house called SuperStream, which allows you to easily make super contributions — for free.

But first, you need to work out how much super you need to contribute for your employees. The superannuation guarantee is currently 9.5 percent of your employees’ gross wages, which is payable on top of their wages — not deducted out of.

Using tax tables to calculate wages

Each year, the ATO produces a range of tax tables to help you work out how much to withhold from payments you make to your employees. In our Ad Hoc Payroll Micro Course, we’ve already added the most current tax tables to the accompanying payroll spreadsheet, as well as the superannuation guarantee tables.

***

We feature a number of real-life case studies, which we have turned into micro courses. You can use the Ad Hoc Payroll Micro Course to determine the rate of PAYG tax to withhold and the required super contribution amounts in Excel, rather than paying to access the payroll functions of MYOB or Xero. Our Intermediate Microsoft Excel training courses will also teach you how to create a payroll spreadsheet from scratch to suit your own business. Visit our website for more information on all of our Excel training courses.

***

online bookkeeping courses to earn cpd points

 

EzyLearn Excel, MYOB and Xero online training courses count towards Continuing Professional Development (CPD) for bookkeepers and accountants. We’ve been an accredited training provider of the Institute of Certified Bookkeepers ever since the organisation started in Australia. Find out how CPD points can be of benefit to you.

 

 

 

 

 

Posted on by — 2 Comments

The Wonders of Microsoft Excel’s 3D Formulas

Excel’s 3D Formulas Work Across Worksheets

Excel formulas online training courseWe’ve recently updated our Microsoft Excel Training Course content, because it remains one of the most indispensable tools for small businesses — and we’ve included a new exercise workbook which takes you through all the steps involved in developing a financial forecast for an investment.

We used a granny flat project as the case study in our financial forecasting workbook, but the beauty of Excel is that, once you get the formulas right, they can be replicated for any kind of investment, not just one for building a granny flat.

The wonderful 3D formula

3D formulas are one of the other many wonders of Excel. A 3D formula is basically a reference to the same cell or a range of cells within multiple Excel sheets. They’re a convenient way to reference several worksheets that follow the same pattern, with cells that contain the same type of data.

All functions work with 3D formulas

3D formulas can be used with all Excel functions — SUM, AVERAGE, PRODUCT, etc — which means that, using a 3D formula, you can easily create a financial forecasting sheet for any stage of an investment, and easily reference that data in another financial forecasting sheet. This is invaluable because there are very few projects or investments that can be contained in just one Excel worksheet.

A project like the granny flat case study in our online Excel Training Course, contains many moving parts — there’s the initial construction, then there’s the ongoing maintenance, and the rental income to manage. It would be impractical to keep all of this information contained within the one Excel worksheet.

3D formulas can be modified with time

The best part about using 3D formulas is that you only need to specify the start and end sheets (which for ease-of-use, you could just label ‘start’ and ‘end’) and the formula will reference all the worksheets between the start and end sheets, including those two sheets.

This means that, as your investment or project grows, once you’ve got the 3D formulas set up correctly, you can just add and subtract worksheets as necessary, and the calculations will update automatically.

***

Once you understand how to create and work with 3D formulas, you can use them for any project or investment that you create a financial forecast for — be it for a granny flat project, business investment or anything else that requires you to make a financial decision.

Visit our website for more information on our Microsoft Excel Training Course, which covers 3D formulas.

***

online bookkeeping courses to earn cpd points

EzyLearn Excel, MYOB and Xero online training courses count towards Continuing Professional Development (CPD) for bookkeepers and accountants. We’ve been an accredited training provider of the Institute of Certified Bookkeepers ever since the organisation started in Australia. Find out how CPD points can be of benefit to you.

Posted on by — 1 Comment

Depreciation and Tax Deductions Associated with Granny Flats

Working Out Your Depreciations with Excel

excel online training course financial forecasting
Ok, so you may or may not have the room for a granny flat, but either way, Excel is the foremost tool for forecasting financial investments.

If you have the room, building a granny flat on your property can prove to be very lucrative. EzyLearn has recently created a new Microsoft Excel exercise, using the construction of a granny flat as a case study, which forms part of our online Excel Training Course.

It was created to help students understand how to use Excel for financial forecasting, but it’s also useful to those interested in constructing a granny flat on their property.

Costs that will be depreciated

In a recent post, we mentioned claiming depreciation on the property’s existing dwelling. If the existing dwelling on your property is rather old, it may not be able to be depreciated. Depreciation rates are determined by the ATO, while an quantity surveyor will be able to determine the value of your dwelling. The cost of the new granny flat will be depreciated over time. Keep in mind that individual elements of the granny flat, such as the floorings, can also be depreciated in addition to the capital structure.

Most expenses can be deducted

The ATO has a long list of expenses relating to rental properties that can be deducted. If you visit their website, you’ll find that most expenses relating to a rental property can be claimed as a tax deduction, depending on the type of rental property. If your granny flat is intended as a long term rental, as the granny flat in our case study is, then nearly all expenses, including the demolition of the old garage and other capital works can be deducted right away.

***

How you treat these expenses and depreciable assets is covered in the granny flats case study of our Microsoft Excel Training Course. Visit our website for more information on our full suite of training courses.

***

EzyLearn online training courses count towards CPD points

EzyLearn Excel, MYOB and Xero online training courses count towards Continuing Professional Development (CPD) for bookkeepers and accountants. We’ve been an accredited training provider of the Institute of Certified Bookkeepers ever since the organisation started in Australia. Find out how CPD points can be of benefit to you.

Posted on by — 1 Comment

Use Excel to Manage ALL Your Investments

Once You Master Excel You Can Do Anything!

using excel for financial forecast granny flat2
Excel is one powerful tool. Its formulas can be extrapolated to most any accounting software program.

In our Excel training Course there’s an exercise workbook on granny flat investments, which takes you through all the steps involved in developing a financial forecast for a granny flat. It can also be used to determine the financial forecast of any investment, not just granny flats.

Even though lots of cloud-based software applications have come along in recent years — Xero and MYOB and CRMs like Zoho — which have made it possible for lots of business owners to keep track of their financials and customer sales history without ever needing to open an Excel spreadsheet, Microsoft Excel is still the software used by accountants and analysts in nearly every profession.

Excel is flexible

Microsoft Excel may be difficult to master — indeed, it’s probably one of the most difficult in the entire suite of Microsoft programs — but it’s also the most flexible. The formulas sitting behind nearly every cloud-based accounting software can all be replicated and modified in Excel, where in MYOB or Xero, they can’t.

You can’t enter the details of your granny flat project or other investment into Xero and MYOB and create a financial forecast, even though near similar formulas are being used each time you run a profit and loss statement.

Cloud software is Excel plus PLUS

Before computers and Microsoft Excel came along, accountants used a pen and paper to keep track of their clients’ business financials. And before that, before the numeral system was invented, the abacus was the main accounting tool used by merchants and traders to keep track of their finances.

You probably have no use for an abacus anymore — although in some parts of Eastern Europe and Southeast Asia people still do — because, as an accounting tool, it’s too basic. But the same cannot be said about Excel, which is capable of handling complex formulas and rendering an answer.

Export accounting data into Excel

Because cloud-accounting software is essentially a very user friendly version of an elaborate, however inflexible, spreadsheet, it means you’re able to export your accounting data into Excel. Financial analysts and accountants do this when they need to carry out further analysis on a client’s financial data, and you can too.

Once you know how to use Excel for financial forecasting, you can use the same formulas and modelling for any financial forecast — be it for a granny flat project, business investment, anything that requires you to make a financial decision.

***

Visit our website for more information on our Microsoft Excel Training Course, with its new intermediate-level ‘Granny Flat Case Study’.

***

online bookkeeping courses to earn cpd pointsEzyLearn Excel, MYOB and Xero online training courses count towards Continuing Professional Development (CPD) for bookkeepers and accountants. We’ve been an accredited training provider of the Institute of Certified Bookkeepers ever since the organisation started in Australia. Find out how CPD points can be of benefit to you.

Posted on by — 2 Comments

When Building a Granny Flat, Here’s What You Need to Consider

Excel Can Help You with Financial Forecasting

using excel for financial forecast granny flat
Excel is a great tool if planning a big ticket project like developing a granny flat on a property.

If you have the room, building a granny flat on your property can prove to be very lucrative. EzyLearn has recently created a new Microsoft Excel exercise, using the construction of a granny flat as a case study, as part of our Excel Training Course. It was created to help students understand how to use Excel for financial forecasting, but it’s also useful to those interested in constructing a granny flat on their property.

The first thing to consider is whether it’s viable to borrow money to fund your entire granny flat project. Most people add a granny flat to their property to earn an additional income by renting it out. If this is your intention, then you need to determine whether the granny flat will become a positive cash flow investment or a negative one.

The existing property

To begin, you must determine the value of the dwelling or existing property on the land you own. Is it brand new, relatively new, older style, or very old? You should have a quantity surveyor determine the value of the existing dwelling, to determine how much of the entire property’s value — that is, the house and land — is based on land value. In most cases, land value will far exceed the value of the dwelling, however many people are surprised to learn by how much, especially if the dwelling isn’t very old. Once you know the value of the dwelling, you may be able to claim depreciation as a tax deduction.

Development costs

You should now start to factor in the development costs associated with the project. This includes the cost of demolishing any existing structures — a garage or shed, for example — and remediation of the site in the event asbestos is present. You should also have a fairly good idea of what it will cost to construct the granny flat up to the stage where you can move in. Not all granny flat construction companies take you up to this stage, often exiting at lock-up stage instead. Don’t forget to include any council fees or levies associated with constructing your granny flat.

Expected income

In the Microsoft Excel case study, both the existing dwelling and the new granny flat will be rented out as investment properties. However, you may not do the same. You need to determine how much rental income you can reasonably expect to earn from your granny flat. You should also determine whether you’re located in a region with low rental vacancy rates and high demand for long term rentals. This will determine not just the net weekly income you can expect to receive, but also the frequency at which it will be occupied, which will also factor into your bottom line.

***

Considering each of these areas is just the first step in developing a comprehensive financial forecast of your granny flat project. Our Microsoft Excel Training Course, with its new granny flats case study, goes into much greater detail. Bookkeepers can also keep up their certification and earn CPD points with our Excel, MYOB and Xero courses. Visit our website for more information on our full suite of training courses. 

Posted on by — 2 Comments

Video: Receive an Automatically Discounted Price for Online Course Enrolments!

Specials and Summer Training

2016-12-20 How to use the EzyLearn website to get discounts and special pricingIt’s Christmas time and we’ll be open every day (except the public holidays) which means you can make contact with questions or support during your course.

But best of all, we’re offering a fabulous special offer with a saving of over $300. Check out the quick video below which shows you how to get $663 dollars worth of training for just $296 — a saving of $337!

All you have to do is choose your courses at our Online Course Enrolment page and the discounts will be applied automatically.

Get New Skills for A New Year!

discounted Myob QuickBooks online courseWith the New Year coming fast we find most of our students are looking to change careers and/or up-skill so as to feel confident with their computer skills in job interviews and the like, so our current special offers will train you up to be your best, cheaply. Here’s all you need to do:

  1. Choose Microsoft Excel course (12 month’s access, all 9 courses and Certificate).
  2. Scroll down to the discounted courses section to see the Xero Training Course available for $30 less.
  3. Scroll down further to see the Microsoft Word Course (12 month’s access, all 9 courses and Certificate), which is normally $267 is now FREE
  4. Tick the box next to “Yes, I have a discount voucher code” and enter 8881818 to receive a further $70 discount off the Microsoft Excel course!

If you don’t have the time right now, don’t worry, you’ve got 12 months to complete all these courses at your own pace — so just enrol now to get the current special offers.

Watch this video to see how to get the discounts

New Online Courses for the New Year

It’s been a very busy year for new course creation and we’ve just launched two new courses that are all based on new online cloud-based services in bookkeeping and marketing/advertising. Read about them here:

QuickBooks Online

Provide quotes on your tablet computer, convert them to invoices when you get the order and take photographs of your receipts for expenses — works on your smartphone too. These are the features of America’s most popular accounting software program that is now aggressively promoting itself to Australian small businesses.

And what do we think? We believe QuickBooks is good software — find out more about our Intuit QuickBooks Daily Transactions Course.

Our New Digital & Social Media Marketing Course

Facebook and social media online training course
Tired of struggling to post consistently on Facebook and other social media sites? We’ve had a WordPress course for several years to teach you how to create your own website and blog, edit images, and optimise it for search engines (like Google). But if you’ve ever struggled with fleshing out a Facebook Page, or want to start promoting yourself or your business in social media, try our Digital Business and Social Media Marketing Courses.

We show you what you should include on a modern day website as well as including Facebook Page, Content Marketing and Facebook Advertising training (which we used to help Derek Farmer show up on Page 1 in Google for the competitive Cammeray Real Estate Agent search query).

***

Most of all, from all of us here at EzyLearn, HAVE a FANTASTIC and SAFE Christmas — doing things you love!

Online computer training Christmas specials_comp

 

Posted on by

Announcement: New Bundle Microsoft Office Word, Excel, PowerPoint, Outlook Courses

Critical Office Skills and Job Seeker Confidence with Microsoft Office Essentials

EzyLearn Microsoft Office Beginners Essentials logo croppedA HUGE PERCENTAGE of EzyLearn students complete an online course with us because they are looking for a new job. However, many people lack confidence because they are not competent using Microsoft Office software programs.

At EzyLearn, we have always included Beginners to Advanced-level training content for our software courses; we don’t want students wasting their time worrying about whether they should do Beginners, Intermediate or Advanced. That said, we’ve consistently had requests for a combination course.

Introducing our Microsoft Office Beginners Essentials software courses — One low price and free student inclusions.

Dropbox included

dropbox-logo-online training courseOne of the most powerful internet based applications that we use everyday is Dropbox. It’s powerful because it enables you to automatically backup any files you save into your Dropbox folder AND it enables you to access your files from any computer. When you delve deeper into Dropbox and start using it on your Smartphone you’ll also discover that every photo you take on your phone (and screen shot) can be automatically saved into your “Camera Uploads” folder within Dropbox so no matter how much phone storage space you have you’ll always have a copy of images in Dropbox.

The Dropbox Course is a Free Student Inclusion and compliments the Microsoft Office Beginners Essentials courses beautifully.

Microsoft Outlook Courses included

Microsoft Outlook product box software training courses 188wideI personally use Google Apps for emailing, contacts, calendar etc because many years ago when I made the switch it was free and Google’s email program (gmail) had the best SPAM filtering on the market so I was guaranteed to only receive the emails I wanted and not all the rubbish — before then I used Microsoft Outlook for many years. Our Microsoft Outlook courses will teach you how to:

  1. Manage your emails
  2. Manage your calendar and meeting appointments
  3. Manage contacts and use Outlook as a CRM
  4. Manage tasks and checklists

Our Microsoft Outlook training course is not available separately but is included as part of our Microsoft Office Beginners Essentials training courses. With a confident knowledge of all of these Microsoft Office Productivity programs you’ll perform better in any job interview and who knows maybe even be able to help other people in the organisation!

Would you like to be an EzyLearn Trainer?

earn money working from home using and teaching how to use MS Office, MYOB, WordPress, Facebook, Xero and moreWe’ve beefed up our EzyLearn Partner program — if you want to earn a couple hundred dollars a week OR make a living out of using and teaching people how to use computer software, Internet services, accounting software and online marketing, then take a look at our EzyLearn Partner page.

Posted on by — 1 Comment

Release: Concreting Business Case Study for Xero Training Course

Case Study: Tradespeople Using Xero Cloud Accounting

Concreting business uses Xero for jobs, purchasing and progress payments - online training case studyTradies across Australia are getting onto the cloud for their accounting and there’s a good reason for it — many busy people can use the system from remote locations to get their work done.

This means the estimator can use it to generate a quote at a site, the office administrator can convert quotes to orders and invoices and the remote contractor can sign in and do accounts receivable calls from their home office. This is good news! All major accounting programs now offer cloud access — MYOB, Xero and Intuit Quickbooks.

I wrote in the past about Rohan from Painters, Men in White; Ken the home theatre installer and Jason the kitchen appliance repairer. Today I’m happy to announce that we’ve released a case study in the Xero Daily Transactions course that relates to the building and construction industry — in particular a concreting business that quotes for the pouring of a 3 level apartment building. Sue, a contract bookkeeper from Yarra Junction helped me write this Case Study based on her experience in the building sector and in particular with concrete companies.

Bookkeepers Upskilling with EzyLearn

Sue is typical of the students who enrol with us to broaden their skills in cloud accounting — existing bookkeepers who want to upskill. She has a lot of experience in the day-to-day management and accounts for tradespeople and found that she could perform the bookkeeping from her own home at any time.

We’re Constantly Updating Online Course Content

While I’m blowing my trumpet I may as well add that this is an example of what we promote with our online courses — that during your student access period you’ll have access to ALL the courses you’ve enrolled into including updates and new content. This is particularly useful for MYOB and Excel Course students who enrol using the LIFETIME course access option.

Xero Course Student Testimonials

I haven’t posted any new pages with student testimonials to the website for a while (but they come in with every course) but today it must be trumpet-practising time for me because here I blow again! When Sue completed the course, she commented:

“I would recommend this learning site to others and I am thinking about studying Excel next with this learning centre“. She also commented: “Convenient in that I can do it from home at my own leisure. The price was very reasonable.“

While Sue was working with us we put her through our Microsoft Word and Excel courses at no cost and the main thing that really stands out to me is how much everyone benefits by doing a Microsoft Word course!

Use Microsoft Word to Create Xero Courses

Helen from Bright learnt how to use WordPress and got leads for website design work using our WordPress course
Helen from Bright is a registered BAS agent who did our WordPress course and got paid creating a website with out help!

Many students enquire about the Microsoft Excel courses because spreadsheets are complicated for people who don’t know how to use them. However, I never cease to be amazed at how many people confidently state, “I know how to use Word, that’s easy”.

Microsoft Word is used in so many aspects of a business yet too many people think that just because they can type they are good at Word. Things like:

are covered in our 203 to 205 courses (so they are considered beginners to intermediate Word skills) yet I am surprised at the number of people I meet who don’t truly understand how these work!

When we work with a new contractor, even as part of our National Bookkeeping Network, we ask new members to write up an education guide if a bookkeeping customer is looking for a certain task to be completed. We end up putting the bookkeeper through our Word course and they discover a whole new world of computer skills that enable them to do more office admin work for their employers or customers — particularly when it comes to long form documents like instruction guides, tenders and even eBooks which are becoming increasing used in online digital marketing.

Bookkeepers Can Be Great Web Designers!

One EzyLearn student helps another from MYOB bookkeeping to designing websites for baby massage using WordPressAs I’m sharing so many EzyLearn student stories, I’ll provide another example of a recent student, Helen from Bright in Victoria (check out where Bright is located in Google maps and you’ll see just how far away she is from the nearest capital city — again, the beauty of working from home using the internet!)

Helen is a Registered BAS Agent and has been for a long time. She performs all the bookkeeping tasks that many of our students aim to offer by being a BAS agent, but she is also interested in being a little more visually creative — at least part of the time — so she completed our WordPress Course and as a result we’ve introduced her to some clients. Since then she’s actually been paid for creating and editing websites! One website she created and continues to edit as required is for ANOTHER student, Sonia who completed our MYOB course years ago to help her with her husband’s business!

Sonia now spends a lot of her time teaching mums (AND dad’s) about baby massage and how they can use infant massage to build a bond with their new baby and help them relax when they are uncomfortable. With a nursing degree and a huge amount of experience with children, Sonia is able to help parents and babies alike create a special bond through touch, and ease new parents into the sometimes stressful experience of welcoming a new baby into their family.

PROMOTED: Corporate Training Licence

If you like the sound of all these courses you may like to take a look at our special bundled offers or even a corporate training licence for your staff or team members.

Referral Marketing is Something We Like

I hope I’ve managed to share with you how we genuinely like to support our students and clients in their journey. We welcome your feedback and love to hear directly how you’re progressing along the way, how we can improve what we do, and any other input you may have.

If you’re looking for a new job, we can advise you on our comprehensive courses with lots of content and examples and a fantastic price. If you’re looking to start a new business we can help you with our Business Startup Course. If you’re a small business in need of a good bookkeeper, writer or website designer — we can connect you.

Stay tuned for some new training content releases about Selling Your Property, Facebook Marketing and Intuit Quickbooks.

Posted on by — 1 Comment

Announcement: Free Courses for EzyLearn Students

Free Excel, Word, WordPress and PowerPoint Courses

Horizontal Banner with software training courses in MYOB, Excel, WordPress, Word, Xero, Facebook and digital social media marketingWe’ve secretly been offering these courses for free for at least 6 months so students (if you’re already one) will have known about it, but I wanted to tell everyone that this is available. What does it mean? It means if you enrol into an MYOB or Xero course for example that once you log into our training site using your student account login details you’ll automatically be able to click on these courses and enrol yourself into the beginners course without paying any money or entering any course password!

We’ve always made samples of our training workbooks or videos available to students who want to learn more about EzyLearn and how we work so we want to do MORE for students who have made a commitment to pay for a course with EzyLearn.

How does it work

The first thing is to choose the course you want to do (or the combination of courses – to get a special offer discount!) and then enrol. Once you are a student in our system you’ll then be able to explore each of the other courses. When you get to the Free Courses (we use the term Free Student Inclusions) you’ll be able to enrol yourself and jump right into the course.

The great thing is we literally give you EVERYTHING in that course: videos, workbooks, exercise files and knowledge review tests, and not just a couple of training resources, so if you’re a beginner with any of those courses you’ll have the fundamental skills under your belt!

facebook marketing and advertising course onlineShare the love

My team and I have been doing a LOT of work lately on social media to help real estate agents build strong online profiles (check out the free video about inserting Youtube videos into a WordPress website!) so we understand the benefits of a Facebook page and to build a community so please feel free to “Like” us and share our details with your friends, family and contacts. Heck, that’s even easier to do now that you can give them some free stuff!

Posted on by

To Job Seekers MYOB is Still Number 1

Most existing business use MYOB

Job Seeker Super Special Discount Offer for MYOB Course, Excel Course and Word Course with certificate 1I love the power of being able to login to our accounting software to resend invoices or create them when I have some idle time and I’ve discovered that lots of trades people and independent contractors love it too, but most enquiries we have from prospective students is about MYOB accounting software because that’s what most small businesses need help with.

That is also why we’ve bundled the most popular software requirements for those who are applying for office admin or accounting jobs – MYOB, Microsoft Excel and Microsoft Word – AND created a special bundled price for the lot!

Superannuation companies need Excel

I was speaking with the risk model manager for a very large superannuation fund earlier this week and we were discussing the course outline of our Microsoft Excel courses and how that fits into the needs of their own workforce (he was exploring a corporate training arrangement) and I mentioned something that resonated with him.

If you are learning a program like Excel or Word from scratch the training materials can be quite generic and cover almost any topics, but as soon as you head into the Advanced Excel Course topics you may also be looking at customising that course using tools, formulas, functions and macros that are specific to your own business – particularly as a large company.

Cafes and Restaurants use Word and Excel

New Morisset Cafe owners at Cafe Limejay use Microsoft Excel to create their new menu-smallI was speaking to a local business owner of a cafe in Morisset, close to my home (yes, I’ve escaped the Sydney property prices, lack of space and high traffic!) about their new menu when they confessed that they used Microsoft Excel to create the menu after struggling with Word to do it. They are a mother and daughter team and worked together to get the new menu ready for their customers.

What stood out in the conversation is just how complicated Microsoft Word is once you start exploring the more intermediate and advanced capabilities. We use these advanced tools when we create our Training Workbooks and it’s worth using the skills because you can save a lot of time for repetitive tasks or when you make changes, but for smaller or more creative tasks like forms and tables Excel is often a simpler program to use.

Save $397 and do the lot

Online Training Course special offers for MYOB, Xero, Excel, Word and moreWe’ve bundled the MYOB, Excel and Word courses, with assessment and certificate options and all you need to do is select these courses at our enrolment page to receive the automatic discount. This offer is called the Job Seeker Offer and is available for a limited time so enrol now and take the saving. Then feel free to share the results of your work if you want to.

Posted on by — 1 Comment

Microsoft Excel 2016 & Gantt Charts for Your New Website/Business/Project

Project plans and gantt chart templates in Microsoft Excel 2016 training courses online

 

GANTT CHARTS ARE just one of the many wonderful features  Microsoft Excel and help enormously in the workplace. 

Many project managers oversee the project management and implementation of, say, a staff induction system, a new computer system or procedural changes.

Our Online Excel Training Course includes training on how to create your own project plan using Gantt charts. Continue reading Microsoft Excel 2016 & Gantt Charts for Your New Website/Business/Project

Posted on by

Learn MYOB and Microsoft Excel, get help finding work with Career Academy

Learn MYOB and Microsoft Excel and get Microsoft Word Course for free

One more rest for Australia Day before the year REALLY gets under way and it’s a great time to set your priorities straight for 2016.

Our two most popular online training courses are our MYOB Course and our Microsoft Excel course. They’re complicated programs and most businesses need them for their financial management, reporting and forecasting so they’re great skills to learn if you are looking for a new job.

MYOB AccountRight Sign In Screen for MYOB Training Course

If you’ve followed this blog you’d also be aware that despite significant growth in the number of enrolments for our Xero Cloud Accounting courses the dominant player in the Australian market is still MYOB and MYOB accounting software also has cloud-based capabilities that make it more and more powerful.

Continue reading Learn MYOB and Microsoft Excel, get help finding work with Career Academy
Posted on by

Start Now and you’ll have until 2017 for MYOB, Xero, Excel, Word and WordPress

Corporate Training for Microsoft Excel, Microsoft Word, Accounting and WordPress Courses

Online Training Course special offers for MYOB, Xero, Excel, Word and moreWith these software programs you can run most aspects of a business and we’re including them all in our new Corporate Training Business Software Training Licences for businesses with a team of people who all want to improve their software skills.

Our Business Software Training Licence enables up to 5 staff members have unlimited access to all training resources for all of our software training courses for 12 months for a low fixed cost. We also have discount prices for larger numbers of staff.

If you look at the total retail price for all of this it is well over $6,000 of value in online corporate training courses and at the current price you’ll only pay less than 25% of the price. That is a saving of over 75%!

Software corporate training course licences for discounted online coursesIn 2015 we experienced a significant increase in the number of corporate enrolments for our Microsoft Office courses and have created this package to make life easier for corporate who want to enrol their staff easier, while also taking advantage of the discounted prices.

Bookkeeping Course Combos and Enrolment Vouchers are also available

If you are looking to up-skill in a number of accounting software or office application programs you’ll also discover some discounted course combination offers for popular courses.

[button link=”http://ezylearnonline.com.au/how-it-works/special-offers/” newwindow=”yes”] See our Special Offers[/button]