Posted on

How does $20,000 mortgage repayments equate to $47,598.02?

Master your mortgage and financials with the Complete Excel Course package - upskill for office admin jobs too

All eyes will be on the announcement from the Reserve Bank Governor today to see what is happening with interest rates. If you are like most people your cashflow would have been affected in the years since Covid because of the increasing interest rates.

There has never been a more important time to master your household budget and spending than now and good knowledge of Microsoft Excel will give you these skills.

The COMPLETE Microsoft Excel Course Package now includes a mortgage spreadsheet

Microsoft Excel Training Course can help you halve your mortgage

A mortgage for your home is a huge debt, particularly for those living in the swelling capital cities with soaring house prices. The pro and cons of buying your own house and living in it are:

  • You don’t pay capital gains tax on a property you live in, but
  • You can’t claim the interest component of your loan

The big problem with this is the interest charge – you can’t claim the cost of it yet it’s a massive component of each and every payment you make on your mortgage.

You’d need your house price to go up at least at the interest rate you are paying to make it a good investment – and right now you’d be doing fine (perhaps except in Perth now).

Bigger payments reduce the interest paid

Our Microsoft Excel Training Course now includes an Excel spreadsheet file that will help you see just how much money you’d save if you paid even a small amount off extra each month!

You can use the mortgage comparison file to compare two mortgages, make extra payments or even shorten the term of the loan to see how much you’d need to pay each month if you want to pay your mortgage off quicker.

If you are an existing Excel Course student you’ll find the new file at the end of our Microsoft Excel Advanced Course 309.

Take 10 years off your mortgage when you can

There are several reasons to open this spreadsheet and start seeing the resulting figures to workout the best way to allocate the money you earn. 

  • Interest rates are at record highs,
  • house prices ‘may’ be peaking,
  • some people say that Australian banks are so highly leveraged to the residential property market that they’ll need to hold more capital reserves.

Either way you look at it, why not use your Microsoft Excel skills and play with some calculations to see how much better off you could be if you are financially prudent now.

You can also use this Microsoft Excel file to do a stress test and see how much your mortgage would be if interest rates do go up as many people expect they will.

free online training course in Xero or Microsoft Word with MYOB or Microsoft Excel Course
50% OFF the normal price for Microsoft Office courses

See our currently discounted Microsoft Office Courses

Posted on

Cyber Security for Bookkeepers – How are scammers trying to get you

Cyber Security for Bookkeepers - How scammers are using MYOB and Xero to get you

Every contract bookkeeper loves receiving these emails but they can wreak havoc with your computer

Emails like these usually means you have a new client and the client has invited you to start doing the bookkeeping for them on their MYOB file.

Everything about the email looks good but here is what to look for and the steps to take:

Continue reading Cyber Security for Bookkeepers – How are scammers trying to get you
Posted on

Engaging a New Worker? Here Are The Things You Need To Do, particularly if you’re classified by the ATO as a withholder:

There’s lots to do when businesses engage a new worker.  As an employer, you’ll be busy going through the onboarding process and showing your new employee the ropes, but there are other important things to do when you add a new member to your team.

Keeping accurate records complete with the right information is essential for businesses to maintain, and that means updating and adding data when engaging a new worker.  Here are some things to keep in mind as you go through this process:

Continue reading Engaging a New Worker? Here Are The Things You Need To Do, particularly if you’re classified by the ATO as a withholder:
Posted on

COMPLETE Xero Course includes Beginners to Advanced skills

Xero COMPLETE Training Courses Online Suite - EzyLearn

This Xero course is the most popular with job seekers and business owners because it gives them the training they need to do almost anything using Xero. These are the course topics:

The Complete Xero Course takes most students 3-4 weeks to complete but you can learn it at your own pace and in your own time.

12 months or LIFETIME access – your choice

Ezy Learning Lifelong training platform for Xero, MYOB, Excel, Digital Marketing training courses

Enrol at our original enrolment website and you can learn everything about Bookkeeping using Xero with LIFETIME course access.

This includes all additional content we create and updates to training material. It also includes access to EzyLearn ANSWERS!

If you want the cheaper option you can enrol into the course here with 12 months course access and support.

Join us as a Tutor

If you have industry experience AND you complete our courses you can also become an EzyLearn Tutor.

Accounting Tutor for Xero, MYOB, QuickBooks Online Training Courses & Support - cropped

As an EzyLearn TUTOR you become our partner and work part time, while also earning an income online as our affiliate – this is just one of our Career Academy membership options for students.

Enquire with us today and get the FREE Xero course sample – as well as Microsoft Office and Word training!

Frequently Asked Questions and Answers

If you have any other questions you’ll find answers to most of them at our FAQ’s.

Here are just some of the most common questions and links to their answers.

Get the FREE sample and enquire now

EzyLearn Course Enquiry

* indicates required
Mobile number
Posted on

Why MYOB makes you log in after inactivity

ATO makes MYOB improve login security for inactivity of users - MYOB courses

Have you noticed a change in how MYOB makes you login? They’re starting to do as they are told by the Australian Taxation Office (ATO), that’s why.

We’ve seen lots of login issues with Xero in the past when they focused on authentication for their users and now it’s MYOB announcing improvements in their security – this time for inactivity.

Continue reading Why MYOB makes you log in after inactivity
Posted on

Are you Selling Your Property?

Selling Your Property Facebook page cover image

They say that Spring is the season to sell your home but is that the case this year?

Property buyers seem to be holding off leading up to Christmas in the expectation that the economy will be better in 2025. There is an expectation that interest rates will be coming down.

What does that actually mean?!

Continue reading Are you Selling Your Property?
Posted on

Do I need one to one training to learn MYOB and Xero?

When I see this comment I wonder if it’s not just based on the fear some students have about learning by themselves.

They’re worried about what happens if they get stuck on something, what happens if they don’t understand the instructions and wanting to know that someone will be available to help them.

I started teaching students how to use computer software on a one to one basis and thought to myself,

“these people are all spending a lot of money to go through the same basic steps”.

The problem with a lot of courses is that they just dump you with information and then get you to answer some questions in an assessment or test – not EzyLearn, we guide you through learning journeys.

Continue reading Do I need one to one training to learn MYOB and Xero?
Posted on

Just follow the messy trail and you’ll learn Xero and MYOB

https://ezylearnonline.com.au/courses/myob-training/myob-courses-faqs/#myob19

The purpose of a well designed course is to provide a series of steps for students to perform that gives them the knowledge and practical experience they need to learn.

We use a number of different tools and case studies and one of my favourites is the Jerry Lame “. He’s like many people that you’ll meet every day.

Continue reading Just follow the messy trail and you’ll learn Xero and MYOB
Posted on

Has it all become too complicated?

Don't be sad - Microsoft Word & Data Entry Training Courses from $29 or $20 per week for beginners to advanced Certificate

I’ve tried and tested hundreds of software programs over the last 25 years and I’ve noticed something very interesting in the last 12 months – they’ve gotten so complicated!

Email marketing is commonplace these days and you know it’s a money spinner when Intuit buy Mailchimp.

Email Marketing is complicated

The cost of email marketing software has gone up and up and up and all the software vendors are increasing their prices at the moment. I thought Xero was pushing it with their yearly price increase but Aweber is similar to Mailchimp and they recently increased one of their monthly packages from $10pm to $55pm – that’s OVER 500% increase.

Is it worth it?

Continue reading Has it all become too complicated?
Posted on

I’ve never actually done it

Frequent updates and infrequent use of software like Excel can really leave you stumped - that's where Lifetime Membership for Excel Online Courses comes in real handy!

People are interesting aren’t they?

I recall when we opened our first Sydney training centre how I took people through a needs analysis to determine what they knew and didn’t know. I could quickly see the difference between what people say and what they do.

We were doing most of the training for clients of Commonwealth Rehab Services when the Internet was in it’s infancy and lots of people were learning about how to send an email!

Continue reading I’ve never actually done it
Posted on

What most students ask about MYOB courses

EzyLearn Online MYOB Training Courses logo - training & student support

This website page answers 99% of students questions about online MYOB courses and certification. It has evolved as we’ve added content and support services so it’s pretty thorough.

The answers to these questions have become a little more complex since MYOB created separate versions of their software:

  • MYOB AccountRight, and
  • MYOB Business (Lite and Pro)

The Bookkeeping Academy MYOB course combination includes training and support for both of these versions.

See the most common questions students ask us.

Continue reading What most students ask about MYOB courses
Posted on

My son asked what my favourite formula is

30_year_mortgage_calculator image from Wikipedia - Advanced Formulas in Microsoft Excel Online Courses - EzyLearn

All I could think about what the financial formulas in our Excel Courses!

He is learning about Pythagorean theory and all I could think about is how to reduce my mortgage!

I’ve spoke to hundreds of people about real estate, land and building new homes in the last few months and the cost of living is such a major issue in most of our lives.

Continue reading My son asked what my favourite formula is
Posted on

Bunnings receipts (tax invoices) straight to your MYOB Business software

Smart receipts stored in MYOB from Bunnings - Learn MYOB with online courses from EzyLearn

Unless you’re a tradie with a Commercial “PowerPass” account with Bunnings you probably wouldn’t know about their fantastic system of keeping track of all your tax invoices.

It’s actually quite easy to get a PowerPass account and it’s very similar to using Flybuys. You go and buy all the things you need – like I did to erect the garden shed in our Job tracking and Projects case study for the MYOB and Xero Courses – and scan your card when you pay. You get a discount and your tax invoice is recorded in the Bunnings PowerPass system.

Bunnings-forge-partnership-with-Bunnings-for-Smart-Receipts-for-PowerPass-members-MYOB-AccountRight-and-Essentials-Online-Training-Courses-EzyLearn

You just log into the PowerPass admin area and EVERY SINGLE invoice is available to you there!

Xero made a big deal about their Hubdoc purchase and how it was included for all users when they increased their monthly subscriptions by $2 in 2019.

This was the start of what seems to be an ongoing increase in the monthly subscription price for Xero. Xero appears to come across like a money hungry landlord that has you hooked on their software and wants to see how much they can extract from you.

It’s a big job to change accounting programs and like many software publishers Xero need to increase their subscription rate or earn more money by selling addons that they own – or they can charge a per employee rate for payroll services!

If you are starting a new business or switching back to MYOB Business from Xero learn how to use MYOB Business online with us.

If you are looking for work you are best to learn both version of MYOB: AccountRight and MYOB Business. They are available in our MYOB & Xero Bookkeeping Course Bundles.

Posted on

Over 100 Microsoft Excel files to practise and FREE Excel Beginners sample course materials

Learn how to use Microsoft Excel in our Beginners, Intermediate and Advanced Excel Training Courses

I don’t think I’ve spent much time mentioning how many sample files you get when you enrol into the Excel Complete Microsoft Excel Course Package.

There are over 100 Excel course practise files and they cover all sorts of different topics including:

  • databases,
  • calculations and formulas, and
  • graphs and charts.

Most of these files come from the work that I have been involved with over several different businesses.

These Excel course practise files are all unlocked and open so you are also free to use them for your own personal use or business use. Some of the personal uses include calculating your mortgage repayments and figuring out how to reduce your mortgage faster.

There are also practise files to help with forecasting, managing a large contact database and visually showing what the numbers mean using useful charts.

Here is some other information you might not be aware of about our online Microsoft Excel courses:

Excel online training course FREE sample course workbook
Posted on

Learn MYOB one skill at a time

MYOB is now better value for money than Xero and online

MYOB has struggled for a long time against Xero but now seems to be in a sweet spot for price vs features.

MYOB is used by more than 1,000,000 users in Australia so it is a very good skill to have if you are looking for bookkeeping jobs or business admin jobs.

When we started delivering MYOB courses in a classroom in Dee Why in the late 1990’s I realised early that learning bookkeeping skills is best to do one step at a time. When I say 1 step I mean in training sessions that last no more than about 2-3 hours.

That’s why we created Micro courses in MYOB.

Visit the MYOB Training Course information page and see each of these different skill levels. You’ll see that it is based on the case studies I’ve written recently about like Flockana Cafe and Trim and Styles Hairdressing Salon.

See the MYOB Courses separately

MYOB Business and AccountRight pricing plans - Learn MYOB online

MYOB costs less than Xero but now have similar features and that makes it an attractive choice of accounting software.

Xero on the other hand are constantly increasing their monthly subscriptions and that has caused a bit of an up cry for some users.

Bookkeeping Academy to find accounting jobs. Learn how to use MYOB and Xero with online training courses - Employer Recognised and Industry Accredited.

Bookkeeping Academy course packages are discounted courses which include MYOB & Xero Courses as well as combinations of Xero and Microsoft Excel.

Explore the Bookkeeping Academy courses and current specials.

Posted on

Microsoft Excel skills are important this time of year

Microsoft Office Excel Online Advanced Training Course - pivotTables, vlookup, MAtch, nested functions

Are you finding work quiet this time of year? We’ve just been handed down our budget and emails are starting to fly around showing what it means to us.

Its the time of year where we find out how well we’ve done financially. It’s the time of year where workers will see how much they can borrow to buy property in the 2025 financial year and where they need to cut back.

Most of this financial information will be worked out using Microsoft Excel.

Continue reading Microsoft Excel skills are important this time of year