Posted on

3 Things You MUST Do in Excel!

Business owners and job seekers take note!

learn xero myob excel online training course videos
Excel isn’t just for budding bookkeepers; it’s a great tool for all business owners to know.

MICROSOFT EXCEL IS THE most widely used spreadsheet application in modern computing. That said, it’s also one of the more difficult programs of the Microsoft Office Suite to learn, which is why we recently updated the content of our Excel training courses.

A lot of people do our Excel training courses to help them “skill up” to find a job, find a position better suited to them, or develop their career path. However, Excel is a fantastic tool for small business owners as well.

But whether you use Excel to create a pivot table or a database, there are a few things you should do each time you open an Excel document. Here we present you with three:

1. Vertical align: always centre

Always align the text in the cells of your Excel spreadsheet to the centre, or the top in certain circumstances. But never, ever align it to the bottom. It’s hard on the eyes and, when you’re looking at lots and lots of data in lots and lots of cells, it becomes difficult to know which row, column, etc, you’re looking in. Centre alignment, always.

2. Build error-checking into formulas

There should never be an instance where one of your workbooks is showing a #DIV/0, #N/A, #REF, #NAME?, #NUM!, or #NULL! error. This is especially true if you’re sharing these workbooks with your business partners or accountant or whomever.

Seeing an error in a financial report may cause the reader to doubt the accuracy of the entire workbook, so ensure your workbooks remain error free by using the simple IFERROR() error-checking function in Excel.

3. Print preview your work

Again, if you intend to share workbooks with other people, you should always ensure that your Excel workbooks can be printed nicely and easily, even if you don’t intend to ever print the document yourself. This is easy enough to do via File > Print Preview and adjusting the print margins before sharing (or printing) the document.

However, judging by the number of times I’ve printed an Excel document only to collect 87 sheets of paper off my printer to read the contents one 4×4 table, the function is seldom used by anyone else but me!

***

For more Excel formatting tips and tricks, download our FREE Beginners’ Guide to Excel, or enrol in our intermediate or advanced online Excel training courses to learn how to create databases, pivot tables, charts, graphs, and much more…

Read more about our beginners, intermediate and advanced Excel training courses on our website, or enrol to start learning by 5pm tomorrow!


learn xero myob excel cheap online training courses videos

At EzyLearn, we’re committed to helping students of our MYOB, Xero and Quickbooks courses gain employment as a bookkeeper or even start their own bookkeeping business; it’s why we provide you with lifetime access to our online cloud-accounting training courses as part of our commitment to continuing professional development


 

Posted on

EXCEL: Other Data Sources You Can Use to Create a Pivot Table

The latest versions of Excel are jam-packed with new features!

learn online training excel cheap best online training excel course videos
How are your Excel skills? Brushing up or learning how to use Microsoft Excel as a business tool could see you brimming from ear to ear too.

WE’RE ALWAYS UPDATING OUR Excel training courses, and as we do so, we’re reminded of just how useful Excel continues to be for small business owners — particularly the latest versions of Excel which include a boatload of new features that make it easy to create and manage relational databases, which you can also use as the data source for a pivot table.

But supposing, for whatever reason, you don’t want to use an Excel database as your pivot table’s data source? Well, there are some other options to create a pivot table without manually entering the information into Excel first. Here are a few more data sources that you can use to create a pivot table in Excel.

Office data connection files

The office data connection (ODC) file extension was created by Microsoft and contains properties to connect to and retrieve data from an external data source. It contains a connection string, data queries, authentication information and other settings. Microsoft recommends that you retrieve external data for your pivot tables and reports using ODC files.

External relational databases

If, for instance, you’re using another relational database program, like Microsoft Access or Filemaker Pro, you can also import data directly from these programs into your pivot table, rather than manually entering the data into an Excel worksheet. In the case of connecting data from an MS Access database, you can do this quite simply by selecting Access from the ‘data source’ dialog box. For all other external databases, you would select the ‘from other sources’ dialog box and follow the steps in the data connection wizard.

Using another pivot table

Each time that you create a new pivot table, Excel stores a copy of the data for the report in memory, and saves this storage area as part of the workbook file. To use one pivot table as the source for another, both must be in the same workbook. If the source pivot table is in a different workbook, copy the source to the workbook location where you want the new one to appear. Keep in mind that when you refresh the data in the new pivot table, Excel also updates the data in the source pivot table, and vice versa. When you group or un-group items, or create calculated fields or calculated items in one, both are affected.

Create a database in Excel first

The easiest and most efficient way to create a pivot table is to create a database in Excel first. Here, you can update and manage as much information about your business — including customer data and financial data — and then use that as a data source for a pivot table.

***

Creating databases and pivot tables are part of our advanced Microsoft Excel training course, but you can start your Excel journey with our FREE beginners’ Excel course. Read more about our beginners, intermediate and advanced Excel training courses on our website, or enrol to start learning by 5pm tomorrow!


learn Xero online learning videos cheapest

Our Xero online training courses include EVERYTHING for ONE LOW PRICE. Furthermore, if you select our Lifetime Membership option, you’ll have LIFETIME access to our ongoing course updates. All EzyLearn courses are accredited by the Institute of Certified Bookkeepers (ICB) and can be counted towards Continuing Professional Development (CPD) points. Find out more about our Xero online training courses. 


 

Posted on 1 Comment

Explaining Why Excel’s Pivot Tables are So Mighty!

No amount of data is too big for Excel’s pivot tables

using microsoft excel pivot tables
Go You Excel Pivot Table! Excel’s signature function, the pivot table, is still as useful for making sense of large amounts of data as it ever was.

WE’VE RECENTLY BEEN UPDATING the content for our Excel training courses and were reminded of just how useful Excel is for small businesses. In Excel, you can easily create and manage client databases and then export part or all of that data into a Word document, your accounting software, an email marketing service, or use it in other Excel documents, such as a pivot table.

A pivot table is Excel’s signature, and most powerful, feature — Microsoft trademarked the words ‘pivot’ and ‘table’ in their compound form PivotTable back in the 1990s. So if you intend to use Excel in any meaningful way for your business, knowing how to create and work with pivot tables is an essential skill, one which we cover in our newly-updated, advanced Excel online training courses.

What are pivot tables used for?

A pivot table is a way to quickly summarise and analyse large amounts of data, and the pivot tables you can create in Excel are especially designed for:

  • Subtotalling and aggregating numeric data
  • Summarising data by categories and subcategories
  • Creating custom calculations and formulas
  • Expanding and collapsing levels of data
  • Drilling down on details from summary data
  • Filtering, sorting, grouping and conditionally sorting data
  • Presenting concise, attractive, and annotated reports
  • Moving rows to columns and vice versa (‘pivoting’) to see different summaries of source data.

Pivot table data sources

There are a few ways that you can create a pivot table, though the most common way is to use an existing Excel worksheet — a database, for example — as a data source. Here are a few ways to create a pivot table in Excel:

  • Excel tables: Excel tables are already in list format and are good candidates for pivot table source data. When you refresh the pivot table report, new and updated data from the Excel table is automatically included in the refresh operation.
  • Using a dynamic named range: To make a pivot table easier to update, you can create a dynamic named range, and use that name as the pivot table’s data source. If the named range expands to include more data, refreshing the pivot table will include the new data.

Create a database in Excel first

The most efficient way to create a pivot table is to create a database in Excel first. Here, you can update and manage as much information about your business — including customer data and financial data — and then use that as a data source for a pivot table.

***

Creating databases and pivot tables are part of our advanced Microsoft Excel training course, but you can start your Excel journey with our FREE Beginners’ Excel Course. Read more about our Beginners’, Intermediate and Advanced Excel training courses on our website, or enrol to start learning by 5pm tomorrow! We cover ALL levels for ONE LOW COST.

And with EOFY looming, be sure to take advantage of our specials!


learn xero myob excel cheap online training courses videos

At EzyLearn we offer online training courses to help you up-skill and find employment. Choose from our range of cloud-based online accounting software courses, to business start up and management courses, to marketing and sales courses, or update and further your skills in a range of Microsoft Office programs (ExcelPowerPointWord) or social media and WordPress web design). 


 

Posted on

The Do’s and Don’ts of a Compelling Resume and Cover Letter

Is your resume up to speed?

do's and dont's of writing a great resume
If you thought you’d never have to write another resume as a contractor or self-employed business person, then think again.

STARTING YOUR OWN BUSINESS does not mean you’ll never need to write a resume or cover letter again. We’ve written about this topic before — indeed, when you first start your own business you’ll probably spend a lot of your time applying to work with other businesses directly or through a recruiter.

And the truth about being a freelancer or contractor is that you’ll most likely spend the rest of your working life applying for work. If you don’t like the idea of this, well then maybe being self-employed isn’t for you! Why? Because in order to find the best work; the kind that you’ll love, you need to be always looking for it — or always be closing, if there any fans of Glengarry Glen Ross in the house tonight.

The truth about being a freelancer or contractor is that you’ll most likely spend the rest of your working life applying for work. 

Do pay attention to design

I’m choosing to exclude the “grammar, spelling and punctuation” portion of this list, because if you don’t already know that’s important by now, then oh boy, I can’t help you. But formatting and design are important, whether you’re looking for work in a creative industry or not.

The key is to grab attention in less than half a minute. You can use different fonts, for instance, a larger plain font for headings and a smaller (perhaps serif) font for the body text. You can type your resume up in Word or use PowerPoint or some other design tool. But just don’t get ahead of yourself and use something too fancy that you don’t have a proper grasp of and end up with a resume that is hotchpotch and messy.

These days, some recruiters will even upload your resume into their own “system” which “parses” your content and basically re-formats it all into plain text. If this happens, your gorgeous CV will look very different on the screen of the employer. The simpler the design and layout of the original resume, the easier it will be for them to read if they indeed use this system for getting through the applications of hundreds of job applicants. But don’t feel disheartened, there are others ways to get spotted amongst the crowd.

Don’t use jargon

The next hurdle, once you’ve got the recruiter or hiring manager reading your resume or cover letter, is to urge them to call you. Do not, I repeat, do not use jargon of any kind in either your resume or cover letter. The minute someone reads a sentence that starts with or contains “experienced in”, “team player”, “responsible for”, etc, etc, they switch off.

These phrases mean literally nothing. Nothing. Telling someone you’re a team player: redundant. Everyone should be a team player, and there is no one, not a single person ever, who has written on their resume that they’re not one. Instead, tell the employer what you like about working in a team. (On a similar note, also avoid the term “able to work autonomously” by explaining the times you’ve had to and how that’s gone.)  

When you go to use the words “experienced in” try to remind yourself that this is something that happens to you — not something you proactively go out and do. Instead refer to your background in terms of achievements. Search “typical jargon to avoid on a resume” for more.

Do show your personality

Remember that employers are people too. Work culture is important to lots of businesses, so they need to know that any potential new hire, freelance or otherwise, will be able to fit in and work with them. And if you can make the person reading your resume laugh, oftentimes you’ll get a call back.

Don’t list silly interests

I should add a qualifier to that, which says that it’s okay to list a really silly interest if you know and make a point of noting that it’s a silly interest. This makes you seem thoughtful, and definitely not as dumb as a person who says they like reading or sports on their resume. Reading what? It implies novels, but it could also mean signposts, Aldi catalogues, Post It Notes. And if you like playing cricket more than once a year on Boxing Day, then for the love of all that is holy (cricket on Boxing Day), say that. Otherwise, put down interests that you actually are interested in — they reveal a lot about the type of person you are, which again, goes to help with the point above.

***

If you’d like to learn how to create a resume in Microsoft Word or PowerPoint, or if you’d like to learn more about starting your own business, you can be enrolling in our PowerPoint training courses or our online Word training courses, or our Business Start Up Course.


learn xero online training course videos

At EzyLearn you can choose from a range of XERO online courses, depending on your skill level — or you can access ALL courses for ONE LOW PRICE. All our courses are accredited by the Institute of Certified Bookkeepers (ICB) and can be counted towards Continuing Professional Development (CPD) points. Find out more about our Xero online training courses. 


 

Posted on

What Does a Typical Staff Roster Look Like?

What Does a Staff Roster Need to Include?

staff roster sheets
Staff roster sheets have come a long way since the time of punch in-punch out cards; let us show you how to create intricate rosters that include RDOs, leave, breaks and so forth. 

IF YOUR BUSINESS RELIES on staff to work different shifts, then you’ll need to provide them with a staff roster. We’ve written about the three ways you can create staff rosters for free before.

One of the exercises in our Microsoft Excel Training Course shows you how to create your own staff roster, so we’re not going to do that here. Instead, we’re going point out the things you need to include in a staff roster.

Different employment types

If your business employs a combination of full time, part-time and casual staff, you’ll need to prioritise the full time first, then the part time staff, as by law, they’re guaranteed a certain number of hours each week — 38 hours for full time staff, fewer than 38 hours for part time staff.

Employee RDOs, leave

A rostered day off (RDO) is a day in a roster period that an employee doesn’t have to work and these can be paid or unpaid depending on individual agreements. Both full time and part time staff members will have annual and sick leave entitlements. Make sure you mark these up on your rosters. It’s not just easier to schedule the rest of your employees when you can see who’s working and who’s not working, but it’s also useful for the rest of your team to know this as well.

Staff breaks

Depending on the modern award and the duration of the shift, certain staff members will be entitled to different kinds of breaks — two 15 minute breaks and one 30 minute lunch break, is common in retail, for example. Mark these break times up in your staff roster, so the staff member can see when they’re due for breaks.

Employee signature

Leave a column on your roster, so each employee can sign off at the end of each week to confirm they worked their rostered shifts. This is important, particularly if any of your employees ever claim a discrepancy in their pays due to shift changes, etc.

*** 

Our Microsoft Excel training courses will show you how to modify margins and set up templates, skills you can use to create your own free staff roster in Excel — or Google Docs, if you prefer. Visit our website for more information on our suite of Excel online training courses.  


learn excel online training course

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


And of course, all of our online training courses can be counted towards your Continuing Professional Development (CPD) points!


 

 

 

 

 

 

Posted on 2 Comments

We Give You 3 FREE Ways to Schedule Staff Rosters

Scheduling for Rostered Staff Can Be Easy — and Free

staff roster sheets for free
If you have rostered staff members or shift workers in your business, check out our three suggestions for creating free roster sheets.

SHIFT WORK TYPICALLY EXISTS in businesses that operate outside of regular business hours — on weekends, the wee hours of the morning, late at night — and to be fair to all of the business’ employees, the shifts are rotated. Other times, as in the case of home care nurses, it’s because the employee has to visit a different patient each day of the week.

As such, it’s necessary for these businesses the provide staff members with a roster each week, fortnight or month. Although there are lots of roster programs available, we’re going to look at 3 great ways you can create staff rosters for free.

1. Use Microsoft Excel

One of the exercises in our Microsoft Excel training courses is to create your own staff roster, because once you understand how to change the margins and set up a worksheet correctly, Excel is still one of the most common programs to create a roster in. Most businesses ensure a new roster is available at the premises on the same day each week, fortnight or month, with at least a week’s notice so each employee has time to check their shifts when they’re at work. Other times, they’re printed and emailed to staff, again with at least a week’s notice.

2. Google Sheets

Once you’ve had Microsoft Excel training, you’ll find little difference between Excel and Google Sheets, as the former was so efficient that not even Google could find a way to improve its offering (ditto for Google Docs). Once your roster has been created in Google Sheets you can likewise print it out, email it or, if your staff have Google accounts, share it with them.

3. Google Calendar

This only works if your staff are all using the same domain — i.e., they have a company email address — but if you open up Google calendar, you can start scheduling events as shifts. This may be suitable for call centres or businesses whose employees work in their office, both of which only have a handful of employees and a few shifts to cover. Scheduling lots of staff members across lots of different shifts this way can be tedious.

***

Our Microsoft Excel training courses will show you how to modify margins and set up templates, skills you can use to create your own free staff roster in Excel — or Google Docs, if you prefer. Visit our website for more information.


Xero online training course

At EzyLearn we offer online training courses to help you up-skill and find employment.

Choose from our range of cloud-based online accounting software courses, to business start up and management courses, to marketing and sales courses, or update and further your skills in a range of Microsoft Office programs (ExcelPowerPointWord) or social media and WordPress web design). 


 

Posted on

Should You Take Out a Loan to Avoid Delaying Payroll Payments?

Repayments on a business loan may be less than super and PAYG combined

Small business loan to finance PAYG and super
It’s not uncommon for small businesses to take out a business loan to meet their super and PAYG obligations – but this should never be a knee-jerk reaction to lean times.

IN A PREVIOUS POST we talked about taking out a business loan to cover payroll if you anticipate that you won’t have enough funds to do so otherwise.

Naturally, it’s always better to use your business’ own funds to meet your obligations, whether it’s paying staff or suppliers. This said, getting a business loan to cover payroll can be a good idea for small and growing businesses in certain circumstances. We look at these now.

Loan repayments are usually small

Depending on how many employees work for you, the repayments on a business loan are typically smaller than all of your payroll obligations — this includes superannuation and PAYG — combined. If you get a loan to fund 12 months of your business, payable over a 24 or 26 month period, the repayments will be far easier to manage each month.

Interest is usually a tax deduction

Businesses are able to claim the interest from any business loan as a tax deduction, so even if the annual percentage rate (APR) adds a few additional thousands of dollars to your capital amount over the period it takes to pay the loan back, the interest will still go towards reducing your taxable income.

This is a more favourable option to delaying payment to your employees (illegal) and delaying payment of PAYG and superannuation withholdings, which could incur a Failure To Lodge (FTL) penalty, plus a general interest charge (GIC). Note: Fines and penalties cannot be claimed as a tax deduction and are therefore dead money.

Do your sums first

taking out a small business loanDon’t forget that, while a business loan to cover payroll for 12 months will be easy to repay initially, your business’s profits will need to improve substantially over the next year so that you can continue to meet your loan repayments AND your payroll obligations for that year.

***

You can easily work this out using Microsoft Excel. Our Intermediate Microsoft Excel training courses show you how to determine if you can afford to take out a mortgage, but because all of our fields remain “unlocked”, you can easily modify them to suit a business loan scenario. Visit our website for more information on all of our Excel training courses.


 

learn excel online training course
Our online training courses feature real-life case studies to make our learning more relevant and true to life.
Posted on 1 Comment

Turn Your Wage Payments into a Business Loan

Only Managing Payroll on an Ad Hoc Basis? We Show You How

managing ad hoc payroll
If you know that you can’t quite make payroll, a short-term business loan may see you through and avoid penalties.

WE’VE RECENTLY UPDATED THE course content in our Intermediate Microsoft Excel training courses to include a workbook and spreadsheet (that you can use in your own business) showing you how to manage ad hoc payroll using Microsoft Excel. This will enable you to calculate your PAYG and superannuation obligations in Excel.

Using Excel to work out your PAYG and super obligations is a great way for small businesses, with a small number of employees, to save money. It saves you having to purchase this extra module in MYOB or Xero, for instance, when you may rarely use it. Saving money for small business is crucial as often it’s these same small businesses that have trouble making payroll payments each week, fortnight or month — and then wind up incurring further fees from the ATO when they’re late with their reporting and payments. It’s a vicious cycle.

When you can’t make payroll

If you’re finding it a stretch to make payroll payments, don’t worry, you’re not alone. Lots of business owners have trouble making payroll. But there are things you can do about it. We find that it frequently comes down to poor credit management processes or perhaps a downward trend in a business’ cycle that’s been missed due to poor or inefficient accounting processes. All of these can be rectified.

If the reason your business can’t make payroll is due to one or more shortcomings in your business’ operations, remedy the problems now. Similarly, if credit management is the issue, and late-paying clients are partially to blame, then tighten up or implement a credit management process. If it’s the result of bookkeeping that’s not up-to-date, find a bookkeeper to manage this for you.

How you can make payroll when cash is tight

Get financing. There are lots of ways to do this, but a common method, particularly if you need access to funds quickly, is to get a short-term business loan. Many short-term business loans don’t require businesses to have a great credit score, and will offer funding of as little as $5,000 right up to $500,000.

You’d have between 3 and 36 months to pay back the loan, but you need to be aware — the annual percentage rates (APR) are usually high. Most lenders require the business to have been active for a minimum of 9 months, and have revenue of more than $75,000 per annum. However, if paid off quickly, these can be an alternative to incurring penalties — it will obviously depend on your business’ individual circumstances.

Keep on top of bookkeeping

If you stay on top of your bookkeeping, you’ll either reduce the likelihood that you won’t make payroll, or as a worst case scenario, be able to foresee the periods when you won’t be able to, and be able to arrange finance in time to cover it.

***

Use the Ad Hoc Payroll Guide included in our Intermediate Microsoft Excel training courses to determine the rate of PAYG tax to withhold — and the required super contribution amounts in Excel. Visit our website for more information on our entire suite of Excel training courses.


Xero online training course

At EzyLearn we offer online training courses to help you up-skill and find employment. Choose from our range of cloud-based online accounting software courses, to business start up and management courses, to marketing and sales courses, or update and further your skills in a range of Microsoft Office programs (ExcelPowerPointWord) or social media and WordPress web design). 

All of our online training courses can also be counted towards Continuing Professional Development points.


 

Posted on

We Don’t Lock Our Microsoft Excel Course Content

You Can Use the Calculation Fields in our Excel Exercises as Often as You Like!

learn Excel online training course unlocked calculations and formulas
We keep all the calculation fields in our Excel course exercises unlocked so you can play around with different figures of your own as often as you like.

DESPITE THE POPULARITY OF cloud-based accounting software applications like Xero and MYOB, Excel still remains one of the most indispensable software programs for businesses and individuals alike. That is why we always make it a priority to constantly update our Microsoft Excel Training Course.

You can apply Excel to so much

Accounting software, even robust packages like MYOB, only allow you to perform a finite number of functions that relate to business accounting. However, Excel can be used for a multitude of different purposes — both business and personal, merely one of which is to develop a financial forecast for an investment.

EzyLearn courses provide real-life case studies

learn excel online training course

Our Intermediate Excel Training Course uses the construction of a granny flat for investment purposes as a case study example. We chose a granny flat for the case study because most people construct them as an investment, whether they’re in business or not, so it’s a good real-world example.

It also deals with depreciation, which you can claim in your tax, regardless of whether you’re in business or not.

Our calculation fields remain “unlocked”

But even though, with the current property booms in our major cities, granny flat construction has become more common, it is not so common that every person taking our Excel courses is planning to build a granny flat for their next investment. That’s why we decided not to lock our course content.

What does this mean? It means that all the calculation fields in the exercise files of our Excel training courses are unlocked, so that your education remains unlocked too. You’re free to play around and replicate them as you need, so you can get a proper handle of how to use Excel in business or for work.

***

Visit our website for more information on our Microsoft Excel Training Course, with its new granny flats case study. We provide a range of online Excel training courses for beginners’, intermediate and advanced students.


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 3 Comments

What Happens if You Have Backlog of PAYG and Super Payments?

Don’t get lumped with penalties when you don’t need to!

failure to lodge penalties how to manage payroll in Excel online training course
It’s not only frustrating and disheartening, but a waste of business funds to be penalised for lodging your financials too late.

A LOT OF SMALL BUSINESSES have trouble managing their payroll, especially when they only have a few employees and paying to access a payroll system in their accounting package is an unnecessary expense. You’ll learn how to use Excel to manage your PAYG and super contributions in our Intermediate Microsoft Excel Training Courses. However, sometimes you may have a backlog of PAYG and super payments. Let’s take a look at how to manage these.

Rescue bookkeeping

A backlog of PAYG and super payments that date back more than three months is known as rescue bookkeeping, although it can often include other bookkeeping issues, like bank accounts that don’t reconcile with statements.

PAYG payments

For businesses that only withhold up to $25,000 each year, you’re supposed to make PAYG payments and file a withholding report each quarter. You have 28 days from the end of the quarter to do so, after which time, you may incur a Failure To Lodge (FTL) penalty.

Superannuation payments

As with PAYG payments and reporting, you can also incur a FTL penalty for not lodging or paying your employees’ superannuation contributions in time. All businesses, regardless of size, have to make superannuation payments each quarter — the ATO sets out the due dates for each period on their website.

Lodging late PAYG and super payments

The ATO only applies penalties for failure to lodge reports or make payments for each period of 28 days (or part thereof) that a document or payment is overdue. Each period incurs one penalty unit for each document, up to a maximum of five penalty units.

From 2015 onwards, the value of a penalty unit is $180 (previously it was $170) for small businesses, which are defined as entities with an assessable income or GST turnover of no more than $1 million a year.

The maximum penalty a small business will pay is $900 for each document or payment that is overdue. Note too that FTL penalties will also incur a general interest charge (GIC), applied on top of the penalty.

Managing late PAYG and super payments

Use the Ad Hoc Payroll Guide, a new case study that is included in our Intermediate Microsoft Excel Training Courses to determine the rate of PAYG tax to withhold and the required super contribution amounts in Excel. Once you’ve worked out the required amounts (visit the ATO website for tax tables prior to 2017), lodge the necessary PAYG payments and reports to the ATO; pay super contributions using the SuperStream super clearing house.

The ATO will write to you if you are required to pay a penalty — sometimes they are waived for first-time offences, or if the amounts are small.

Our courses now include real-life case studies

learn excel online training course

Our Intermediate Microsoft Excel training courses will also teach you how to create a payroll spreadsheet from scratch to suit your own business, so you can easily work out your PAYG and super obligations. Visit our website for more information on all of our Excel training courses.


learn PowerPoint online training course

Create brilliant presentations and graphics for all kinds of business purposes.

Gone are the days of excruciatingly dull PowerPoint slide presentations. Nowadays PowerPoint is the hidden gem used to generate animations, videos, movies, advertising and graphics. It’s a great ally to the marketer or social media person in your organisation.

This creative program can also be used to conjure up the most beautiful and modern pictorial slides to enhance any presentation or induction. Find out more about our 2016 version PowerPoint courses.


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

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

Free Microsoft Word Beginners Training Workbook

Get Your Free Microsoft Word Training Workbook Now

Microsoft Word Beginners Training Course WorkbookWe’ve been hard at work on our Microsoft Word courses in readiness for the launch of our 2016 Microsoft Word courses and I’m happy to let you know that we are offering the first of our Microsoft Word Course Workbooks to you for free. It’s the 201 Course workbook and it includes exercise files that explain all of the different types of tools available in Microsoft Word.

Interested? Register Now for the Microosft Word Beginners Workbook and Exercise Files

Microsoft Word Exercise Files

The image in this blog is of one of the exercise files we’ve created that has loads of different Word formatting, including:

  • Font formatting (colour, size)
  • Paragraph Formatting (alignment, spacing)
  • Heading Styles
  • Headers and Footers
  • Images and Graphics
  • Tabs
  • Background shading formatting
  • Inserting hyperlinks
  • much more..

Sales Letters, Proposals and more

The “Content Marketing for Real Estate Agents” exercise file included with the free Microsoft Word workbook is one of dozens of files we include in our MS Word Courses and as a Microsoft Word student you’ll also get access to new training content we’re including Sales Letters and Proposals.

The exercises in all of our courses and the object for every course is to use software for practical purposes in every business. The Sales Letters and Proposals exercise files we’re working on combine software skills with marketing strategies we go through in our Small Business Marketing Course. Not only will you learn strategies to grow your business by increase your customer base and enhancing your product service offering, you get to create your own marketing materials using Microsoft Word.

Register for the free workbook

Posted on

Intermediate skills in Microsoft Word can help you create great sales letters

Microsoft Word Training Course is Being Nurtured With New Content

203 Microsoft Word Beginners Courses for sales letter, flyers, resumes, cover letters and tender proposalsI recently wrote about the content in our Microsoft Word Training Courses and because its a couple years old we’ve been offering the Microsoft Word Courses as a FREE BONUS to anyone who enrolled in our Excel or MYOB courses (with certificate options). If you’re a regular reader (subscribe here) or an EzyLearn student you’d also know that we offer either 12 month or lifetime access to courses and that includes access to brand new content.

[highlight]We’re in the process of create brand new content for Microsoft Word, including training on the creation of great sales letters, resumes and tender proposals.[/highlight]

I’m happy to share with you that we’ve been working on our Word course feverishly for the last 3 months (and there is still a couple months of work to go) to make sure that we have training on the most recent version – Microsoft Word 365 (the clould-based Microsoft Word program that you can purchase on an annual subscription that costs less than the previous versions). The new Word course content is now also aimed at helping you create documents to make sales (for businesses) or find work (for job seekers).

If you’ve always wanted to improve your skills using this popular program and write documents faster, make them look more professional or take advantage of tools like Mail Merge then you’ll get some great value out of this course. We’ll be going through some exercises to help you create

  • A great sales letter to highlight the call-to-action for your direct marketing campaigns as well as
  • A resume for the job you’re looking for (and a focussed cover letter).
  • Proposals and tender documents to win new business for your company

Sales Letters, Resume’s, Cover Letters and Proposals

[highlight]Can you see what they all have in common? They are all marketing focussed.[/highlight]

Each of these documents are used by people EVERY day to show how professional, smart, committed and capable they are. Most companies need to write sales letters and proposals to try to win new business and maintain or increase their annual revenue. Job seekers create resumes and cover letters to convince employers that they are the best person to choose for a job vacancy.

In creating this updated Microsoft Word Course content we’ll also be working on some real life examples of creating marketing materials as part of the Small Business Marketing Courses AND our Career Academy that aims to prepare students to confidently search and apply for job vacancies.

Sales Letters for Bookkeepers and Website Designers

Bookkeepers and website designers need new clients all the time, sometimes because they just don’t have enough work but sometimes because the nature of their work is project driven so it’s [highlight]important to always be spending some time in the sales department[/highlight] (even if you are a one person band). Some people do this with content marketing, or Pay-per-click advertising on Google or Facebook, while others actively seek to meet new people and give them a reason to engage their services.

[dropcap]W[/dropcap]e’ll be working on sales letters as part of a direct marketing effort to reach potential clients and give them a [highlight]reason to act on the sales letter using a special offer and a call to action[/highlight].

You can create sales letters for your marketing campaigns using beginners skills in Microsoft Word, but when you develop the Intermediate or advanced skills you’ll find a dramatic difference in the quality of your documents.

Special Prices & BONUS Courses are for a LIMITED TIME ONLY

free online training course in Xero or Microsoft Word with MYOB or Microsoft Excel CourseAre you planning on doing a Microsoft Word Course in the new year? Why not enrol now and save at least $50?

After we’ve completed all the new course content and support exercise files we’ll be bringing the Microsoft Word Course prices inline with our other course prices, so when you enrol now you can get the Word course free if you enrol into Excel or MYOB (Certification option) or you can enrol directly into Microsoft Word and get the current discounted price. Enrol now and you’ll get the benefit of the new Word course material when it’s published but you’ll get it at today’s price.