How to Reduce Your Fail Rate in Business by 50%

What You Can Do this Christmas

business start up online training course christmas holidays2
There’s lots to do in preparation for starting a business and the summer holidays is a good time for the ground work.

DID YOU KNOW research shows that by taking just one short course on small business management, the chance a business will fail is reduced by as much as 50 percent.

This is because business mismanagement is the primary reason businesses fail; the other most common reason is because owner/s fail to implement appropriate credit management processes. In both cases, this failure has come about because the owners, directors, partners or managers lacked the appropriate management skills to make it a success.

Learn the basics in business

The Christmas holidays is a perfect time for taking the steps needed to start your small business. While everyone else has gone on holidays, you’ll be ready to take on your first client or customer by the time business really starts kicking off again at the end of January.

business start up online training course christmas holidaysSo let’s get to it: there’s work to be done. And this work generally requires some rudimentary knowledge of Australian tax law, copyright law, trademarks and patents.

You should also have knowledge of particular software applications, and digital marketing.

Other key areas of business you need to know

The key areas business owners should understand before starting a business include:

Ordinarily, to become skilled in each of those areas, a person would have to take, at least, five different training courses. But few people are ever likely to do this. Instead, they’d be more likely to cherry pick the areas they’re least familiar with, and fly blind with the others. Needless to say, that’s where people run into problems.

Take Advantage of our Christmas Savings!

We don’t want you to wing it or fly blind — our goal is to help small businesses succeed which is what we’ve been doing for nearly 20 years.

We cover what you need to set up a small business in our EzyStartUp Business Course, priced at just $297. This course covers each of the key areas mentioned above that a small business owner needs to be familiar with, in addition to the following:

  • Originating and developing concepts
  • Establishing legal and risk management
  • Product packaging
  • Marketing your business

***

When you enrol you will also receive FREE ACCESS to a bunch of our other online training courses, including Xero Set Up and Beginners’ Excel and Word.

Our Last Dasher Sale is also on now with special Christmas discounts on our online training courses in social media, and cloud accounting software (MYOB, Xero) and Excel, Word and WordPress.


Don’t Wait — Become the Head Honcho Today

Use your time off from work this summer to begin working on your new small business. All of our training courses are delivered online, and can be completed at your own pace, so you can complete them while you’re actually on holidays, or relaxing at home or at a cafe.

And since one of the best ways to start a new business is by operating it as a side project to your other job, if you get all the start up stuff out of the way while you’re on holidays, it’ll be ready to go by the time you back to work.

Learn more about the EzyStartUp Business Course at our website or view all of our special offers to save on your next EzyLearn training course.

start your own business online training course videosAnd as a gift to you, remember our Bookkeeping Basics Guide is yours’ for free!


 

Don’t Wing It With Customer Service – Plan It

Great customer service doesn’t just happen.

learn online training videos about small business customer service
If you’re unsure about what makes up the kind of customer service people rave about, then perhaps you should look into our EzyStartUp Course.

HOW TO PROVIDE REALLY exceptional customer service is just one of the modules covered in our EzyStartUp Course which teaches you all about how to start up your own business.

We handpicked this inclusion as our experience is that, time and time again, good, nay excellent customer service goes a long way to ensuring a business has longevity.

We’ve mentioned in a previous post the issues inherent with Zoho’s customer service, which wasn’t bad as much as it was hampered by geographical differences and the strength of Aussie customers dealing with Aussie customer service workers and telephone operators.

Defying customer expectations

For many, good customer service is something many of us have come not to expect. Most of the time when you go into shops to buy something, you come prepared – you’ve already researched the kind of TV you want online and why, and you know the sales girl will never tell you if your butt looks big in those jeans.

Is there too much churn and burn?

Is churn and burn a problem with the quality of customer service? Certainly in many chain or department stores now, where there’s a huge turnover of staff, many employers seem to have given up on trying to teach their staff the art of customer service.

And the ambivalence toward customer service has slowly crept into other areas of business, as companies downsize, move online, or shift jobs offshore.

As a business owner, I have always prided myself on providing the very best customer service possible. When I moved EzyLearn online, one of my major concerns was how would I manage the customer service side of the business, now that my customer service resources had shrunk?

Using a ticketing support system

That’s when I decided to use the Zen Desk ticketing support system to manage all of my online customer enquiries. Zen Desk does this in a way that’s professional for my customers and also easy for me and my team to use.

Incidentally, Zoho also offers a similar support ticketing service and, like most of the Zoho products, the most basic offering is free to use forever. But even if your business decides to use a ticketing support system like Zen Desk or Zoho, remember: It’s only as good as the customer service processes you implement for your business.

Good customer service is structured

Fantastic customer service — the kind that makes people tell their friends and keep coming back to you for their purchases — doesn’t just happen. This is why we cover customer service in our EzyStartUp Course. Most people don’t realise that, like everything else in business, you have to plan to deliver good customer service. And as the business changes, your strategy can adapt and change too.

This might take the shape of a policy which outlines things such as ensuring phone calls aren’t answered before the third ring (so as to not startle or fluster callers), replying to emails within a few working hours (even if it’s just to say you’re looking into the issue), or following up on sales enquiries with a phone call (which increases conversion rates).

Definitely use tools like Zen Desk to help you fine tune your customer service policies, but remember that good customer service starts with you. Develop your customer service strategy (our EzyStartUp Course can help you) and commit to it.

***

Planning how you’ll provide great customer service — that’s what’ll give you the edge over other businesses. Good customer service is so rare these days that when people find it, they flock to it. So find your flock, and if you need help, take our EzyStartUp Course.


learn online training Xero courses videos for less

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. 


 

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. 


 

Are You Making these GST Mistakes in Your Bookkeeping?

Being Jack of All Trades can land you in hot water with BAS

find a bas agent in your local area
Don’t submit inaccurate financial documents by trying to do everything yourself by way of bookkeeping.

IT’S PERHAPS EASIER TO do your own bookkeeping these days than it used to be; particularly if you’re using a cloud accounting program like MYOBXero or QuickBooks, which are among the easiest, yet robust, accounting applications currently on the market.

But even so, there are many aspects of Australian tax that, while accounting software makes it possible to carry them out yourself (like business activity statements, for example), it’s not a good idea unless you really know what you’re doing. Here are the three GST mistakes nearly every business owner makes in their bookkeeping.

Claiming GST twice

This is most common when a business has vehicles, machinery, plant equipment, etcetera that are either being leased or are under hire purchase. The business owner’s accountant will typically claim the full GST component for in the first quarter that the business purchased the equipment, but confusion generally sets in when it comes to recording regular monthly payments.

Very often the business owner will record it as GST or a capital expense, and because both show up in their BAS reporting sheet, they end up claiming the GST twice.

Recording GST for all expenses

There are many expenses that do attract GST. They include:

  • Motor vehicle registrations
  • Bank charges
  • ASIC fees
  • Paypal transaction fees
  • Interest and director fees / drawings.

Claiming GST credits on purchases from suppliers not registered for GST

Not all business owners are registered for GST, and although they should state somewhere on their invoice that no GST has been charged, oftentimes they’ll leave you to assume that. As a general rule of thumb, if the invoice doesn’t show an amount in the GST column, there’s a good chance the supplier isn’t registered. To make sure, though, visit the ABN Lookup Page and search their ABN.

Accounting software is easier, but Aussie tax remains as complicated as ever

Even though MYOBXero and QuickBooks are among the most user friendly accounting software applications on the market, Australia’s tax laws remain as complicated as they’ve ever been. So while you can do your own data entry (reconciling your bank statements), it’s a good idea to hire a BAS or Tax agent to look after the more complicated aspects of your tax and BAS requirements.

***

Want to learn or brush up your cloud accounting and bookkeeping skills?

At EzyLearn we offer online training courses to help you up-skill and find employment. Choose from our range of online accounting software courses, as well as 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). Many of our courses come with a ONE LOW COST for ALL SKILLS LEVEL option. 


Need help finding a BAS or TAX Agent?

find a local bookkeeper

National Bookkeeping is an online directory of local bookkeepers looking to add to their customers. Visit National Bookkeeping to find a suitable and experienced person available to work in your area, or able to work anywhere in the cloud. Alternatively, if you are a bookkeeper looking to expand your client list or find contract work, you can register and become part of our network for free


 

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


 

What to Do When You Have More than One Income Stream

Why it’s important to track your income streams

keep-track-of-more-than-one-income-stream-using-excel-myob-xero-learn-online-training-course-videos
It can be easy to lose track of separate income streams; Excel is a great tool for monitoring which work your income is coming from.

IF YOU’RE AN INDEPENDENT contractor, or you’re a full-time employee about to start up a side business, then you need to be able to keep a good track of all your income streams. There are a couple of reasons for this and both of them relate to tax. 

Basically, income is income, regardless of how you earned it, and you’ll pay tax on the total amount. As an employee of another business, you’re likely to be earning money through your tax file number. Each week, your employer will withhold tax commensurate with how much money your employer has paid you. But this doesn’t take into account any other income.

If you’re also earning money from a side business, using an ABN, there’s no one to withhold tax on your behalf, so you need to keep a close eye on your income to ensure you have enough money in the bank to pay your tax bill — which you will get, I’m afraid — after your tax return has been filed.

Two tax returns? Use Excel

Although income is income, you will still have to file two tax returns, one for each income stream. That’s why you need to keep an eye on your accumulative income, and not just the money earned through your business.

There are lots of personal finance and budget apps that help you to track and manage your income, but the easiest, most flexible and most straightforward way to do this is to create an Excel spending or expense sheet, which our Excel training courses will teach you how to do.

Reasons why people have two income streams

It’s not just full time employees who are starting their own side business that have two income streams. Plenty of freelancers and independent contractors earn money through their ABN and TFN.

There are some businesses that prefer to put contractors on the payroll, usually because they’ll be working on a regular basis, onsite, and it’s just easier for the business to employ them as casuals. Often for insurance purposes, but it’s also because the work involved doesn’t conform to the definition the ATO uses for an independent contractor.

Other times, it’s because the contractor or freelancer is working in an entirely different industry on the side — hospitality or retail, for example — to supplement their freelance income, which is how a lot of people get businesses off the ground.

Focus on how to earn money

The main take away from all of this, is that when you’re tracking your income, focus on the ways to earn more income. If you discover that each month, you have a week where your income is lower, there’s an opportunity to fill that gap with another job or other income stream.

***

You can learn how to create and manage your expenses or spending in our Excel training courses, where you’ll be able to create your own spending or expense sheet, and how to perform daily bank reconciliations in MYOB or Xero in our cloud accounting training courses. For more information, visit our website.


learn to use excel online training course videos cheap best

Learn Microsoft Excel from scratch or brush up your Excel skills, at your own pace, with our affordable Excel online training courses — where you get THE LOT (that’s 9 courses in total) for ONE LOW PRICE — everything included! Volume corporate discounts are available.


 

Keeping Tabs on those ‘Little’ Monthly Expenses

Why Excel is Great for Keeping Track of Your Spending if You’re Self Employed

excel online training course using excel for monthly expenses sheet
That take away coffee that you buy each morning should be added to your business expenses sheet; even if not claimable it shows where your money is going.

WHETHER YOU’RE ABOUT TO start your own bookkeeping business, or whether you work as an independent contractor (even if you’ve been doing this for a while), it’s really important to know how much you’re spending each month.

Your Xero, MYOB or QuickBooks accounting software will help you with some of this, but the very best way is to create an expense or spending sheet in Excel — which we teach you how to do in our Excel training courses — as this gives you a far more detailed look at your expenses and spending.

Not all your expenses are 100% business ones

Sometimes you can’t claim 100 percent of your expenses as business ones — the costs of running your car, home internet, rent, utilities, etc — but you should nevertheless keep track of your spending on these items because it will affect your cash flow.

That’s why keeping an Excel spending or expense sheet is a good idea for contractors and home-based business owners. You don’t want to enter your home internet into your accounting software as a business expense, if only 30 percent of it is used for business purposes, but you still need to keep track of it, so you can manage your cashflow.

Monitor frivolous spending

One of the things we love about using Excel to track your expenses and spending is that every little expenditure is right there, in plain view.

This isn’t the case with Xero or MYOB or other accounting software. Your expenses are hidden away, and you have to run a report to get a good breakdown on where your money is going.

Not so with Excel,. If you buy a coffee every morning, it’s right there, in a category you can label as “coffee”.

Now, we’re not saying that coffee is frivolous. Far from it. Many of us need coffee just to function (!) but there are lots of small things we spend money on every day, week, month that add up. When you’re self-employed you need to keep an eye on these “little” things.

Sometimes, you’ll find that you’re spending lots of money each month on subscription services that you’re not even using. Eliminating $15 a month here and there makes a big difference.

Create as many categories as you need

That’s the other great thing about using Excel to track your spending: You can create all the expense categories you like.

Of course, not everyone wants to track each and every expense right down to their last bag of jelly beans — that actually would be a little ridiculous — and for most the most part, you can lump your groceries into a category for discretionary spending, but there are some things you might want to separate out — movie tickets, money spent on lunches and dinners, and so forth.

These things tend to add up, and if you want to keep an eye on them, separating them out is the easiest way to do that.

Back to those business expenses

Each fortnight or month or however regularly you complete your bookkeeping, you can easily add in those business expenses into your accounting software — or your bookkeeper can.

Remember, if you spend $60 a month on internet, but only 30 percent of its use is for business purposes, you should only add $18 a month as a business expense in your accounting software. In your Excel expense or spending sheet, however, you’ll put the full $60 in, as you need to have the money in the bank to cover this expense each month.

***

You can learn how to create and manage your expenses or spending in our Excel training courses, where you’ll be able to create your own spending or expense sheet. Visit our website for more information.


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. 


 

Marketing for When Your Business Strategy Changes

Where lead generation services are useful

lead generation services
Using a dedicated lead generation service can be more useful than advertising but the quality of the leads may be questionable.

CHANGING YOUR BUSINESS STRATEGY to include additional services will require an additional investment in marketing if you are to make this successful. In terms of simply paying money to advertise your additional services, as you’re probably already aware, advertising doesn’t always yield immediate results. Therefore you might consider spending money on a lead generation service.

We cover how to account for marketing and lead generation costs in our Xero training courses, which includes a new workbook that looks at what to do when your business strategy changes.

Lead generation vs marketing

Lead generation, as the name suggest, is solely focussed on generating a potential customer or client for your business. For instance, there are lots of lead generation services in the building and home maintenance trade — hipages, One Flare, Service Seeking, Quotify, etc — but there are also a growing number for people in creative services, although they’re typically referred to as online marketplaces and include Freelancer.com, Upwork, Fiverr, and so forth.

Advertising and digital marketing (including content marketing), puts your message or business in front of your target audience, but there are more steps in the process before you can capture a lead.

The benefits of lead generation

The main benefit of using a lead generation service is that it delivers active leads almost as soon as you sign up to the service. The quality of the leads tend to differ between services, and the leads also tend to be people who are focussed solely on price, and not so much workmanship. In other words, they’re looking for something done in a particular fashion, for a particular price. No more, no less.

These sorts of jobs are good when you’re getting started or as a way to keep the home fires burning, but it may not be appropriate to rely on them as your sole means of developing clientele.

The benefits of marketing and advertising

If you’re using the correct channels to reach and market or advertise your business to your target market, you’re effectively developing a relationship with those people and educating them about your business.

This means you’ll capture people at all stages of the purchasing funnel — some will be at the pointy end, while others won’t be ready to make a purchasing decision for a while. The benefits of marketing and advertising is that you’re capturing a wide array of people and building brand awareness.

A combination of both works best

If you have the resources, a combination of both marketing (advertising, content marketing) and lead generation works best, though your focus should on marketing and advertising your business to your target market, rather than trying to fit your business into the mold of all the different leads fed to you through a service like hipages or Freelancer.com.

Create a marketing budget

Run a cashflow report in Xero to determine how much cash you’ll have to invest in marketing your business. Our Xero training courses will show you how to run a cashflow report, which you can then export to Excel and use when creating your marketing budget, which should include a schedule, costs, desired outcome — i.e., number of leads, conversions each week, month, quarter — to ensure you’re getting a good return on your investment.

***

Our Xero training courses will show you how to run cashflow reports and account for your marketing costs, while our Business Start Up Course will show you how to create a marketing plan. Visit our website for more information.


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.


 

Should You Start a Business That You LOVE or a Business YOU CAN DO?

Pairing knowledge with a gap in the market

how to find the right career path
I love watching TV. And I have an opinion on many things. Doesn’t mean I can monetise the pairing of these two. Or can I? Did somebody say Gogglebox? 

CONFUCIOUS ONCE SAID: “FIND a job you love and you’ll never have to work a day in your life”. That’s good advice, although it’s not always practical.

After all, I love watching television, but it’s probably impractical to try and monetise that to start a business — not impossible; but it is impractical.

A better measure of finding something you can turn into a business idea, and then a business, is to find something you’re good at, that also addresses a gap in the market. In other words, put your existing skills and work experience to use in a new, different way.

When skills meet reality: The Open Agent example

For some people, this does mean starting a business doing something they happen to love. Photographers, writers, even golf or tennis pros are using their existing skills that they do love, but often not how they might have first imagined. Photographing weddings instead of high fashion; content writing instead of novel writing; teaching golf or tennis instead of competing professionally.

Other people may not necessarily love their sales skills or aptitude for data analysis, but these are skills that can be put to use in a business that they do love. Take the real estate comparison service, Open Agent, for example. It was started by two former McKinsey and Company business analysts, using a WordPress website they built in a single afternoon.

Three years later, it had raised $20 million in funding, and the business had doubled in size for every 12 months it had been operating. The co-founders, despite having no real estate or technology experience, put their experience working at a management consulting firm to good use, as well as their connections to the business world to get their venture off the ground.

Finding VIABLE gaps in the marketplace

Earlier in this post, I said you should find something — a skill — you’re good at and channel that into a business idea that addresses a gap in the market. But this doesn’t automatically mean your idea is viable. It just means it has the potential to be. To determine if your idea is viable, and to what extent you can expect it to start generating revenue, you should carry out some market research and competitive analysis.

Find out what sorts of businesses like yours already exist and how they operate. What’s their target market, and what are the main issues business owners or the industry as a whole are facing?

***

Find out what sorts of businesses like yours already exist and how they operate. What’s their target market, and what are the main issues business owners or the industry as a whole are facing?

If you’re not sure how to go about this, we cover it, as well as business planning and sales and marketing in our Business EzyStartUp Course. To find out more, visit our website.


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

Many of our courses can also be used towards CPD points. Find out more.


 

Thinking of Starting a Second Business? Introducing Jerry

Case Study: Costs for starting up a second, related business

microsoft excel starting a second business
Contemplating starting a second business, related in some way to your first? Excel can help you forecast start up costs.

A LOT OF BUSINESS OWNERS branch out into related fields when their flagship business becomes successful enough (just look at Jim’s Mowing). However, this can be a bit dicey if the business owner doesn’t properly forecast all the start up costs. Not doing so can not only have an adverse impact on the new venture, but also on the existing business.

In this case study, we’re going to look at the start up costs associated with starting a real estate sales business.

Meet Jerry, our budding entrepreneur

Jerry is a male in his 40’s, currently working as an agent for a local asbestos removal company, earning a commission for helping the company make sales. In this role, he works as an independent contractor, invoicing the asbestos removal company at the end of the month. Because of the work he does, Jerry meets with lots of homeowners (and business owners too) who are renovating their home in preparation to put it on the market for sale or rent out.

Because of the client contact base Jerry is always developing, and knowing that there is no conflict of interest, Jerry decides he’d like to branch and become a real estate salesperson.

Budgeting for a new business from home

Jerry decides to operate his real estate sales business from home, as he plans to operate it as a side business, at least initially. Jerry won’t need to lease office space, but there are the following costs he will need to budget for. The costs he foresees are approximate:

  • Real estate license training course: $2,250
  • Website setup costs: $300 + training (if required)
  • G Suite account: $5/month upwards + training (if required)
  • Mobile phone: $55/month upwards
  • Business cards, flyers, other marketing materials: $99 upwards

Jerry’s ad-hoc operational costs

Although the majority of Jerry’s operational expenses will be reimbursed by the vendor once the property is sold — property marketing, auctioneer costs, etc. — Jerry will need to ensure he has enough capital to cover these operational costs. Property marketing costs are determined based on a percentage of the property’s value, usually 1 percent but sometimes lower. The median price of property in Jerry’s area is $440,000.

Because Jerry is already working as an independent contractor, he doesn’t have to incur any other operational costs (office furniture, internet, information technology, etc.), however his bookkeeper may apportion these costs differently now that Jerry is operating an additional business.

Determining upfront capital required

Jerry already has two homeowners who are thinking of selling their home in the next 12 months. He estimates that based on the value of each property, he will need to spend $5,000 each on property marketing. Therefore, he’ll need at least $13,370 in startup capital to fund his new venture for the next 12 months — although he knows that the initial $20,000 in property marketing will be reimbursed to the business within 6 months.

How Jerry will measure his success

Jerry is located in Newcastle in the Hunter region of New South Wales. Clearance rates in this region hover around 70 percent and properties spend an average of 50 to 70 days on the market, as property is typically sold by private treaty rather than auction. These two metrics will be used to determine Jerry’s success. Price is not a good indicator, as the nature of property sales means Jerry should be valuing property accurately with only a 10 to 15 percent difference in the final sale price.

Jerry should also research other real estate agents selling similar property in his local area to determine how many sales they are writing each calendar year. This can become another benchmark for Jerry’s success, although only a peripheral one, as Jerry is still only operating his real estate business on the side.

***

You can use Excel to work out a budget for the start up costs for your second business, and use accounting software like Xero, MYOB or QuickBooks to forecast whether your existing business will have the capital to fund your new venture.

Our Excel training courses will teach you how to create budgets and forecasts and our cloud accounting training courses will show you how to determine the financial health of your business.


Social Media and Digital Marketing online training course_comp

Successfully promoting your business products and services to clients these days requires a sound knowledge of how to spread the word via social media. Whatever your field, we can teach you the online marketing techniques to stand out from the crowd and build your customer base! Check out what’s included in our comprehensive Social Media and Digital Marketing online training courses.


 

Making PowerPoint “Speak” with Audio

When Should I Use PowerPoint Audio?

using audio in powerpoint
You can get beyond the birds cheeping and insert your choice of quality audio into PowerPoint.

BEING THAT MOST PowerPoint presentations are created as a visual aid to accompany a speech — although there is just so much more you can do with PowerPoint — you may find yourself wondering when it’s ever appropriate to use audio in your PowerPoint presentation, and if it is appropriate, what kind of audio?  

First off, there are two kinds of audio you can use in a PowerPoint presentation: pre-recorded audio and audio you record yourself. You’ll learn how to record and insert your own audio files into PowerPoint in our PowerPoint Training Course.

When you might use pre-recorded audio

using audio in powerpointIf you’ve ever fiddled around with PowerPoint, you’d notice there are a few audio sounds you can use insert into your slides. They’re mostly generic sound effects, like the sound of waves or a bird chirping. To be honest with you, none of these are ever appropriate in a PowerPoint presentation, except in some really obscure instances. Or less obscure ones, like a training course teaching you how to insert pre-recorded audio into PowerPoint!

You can also add pre-recorded audio that you have on your computer, like a song from your music library. Again, there are few instances when this is necessary, but it’s another option nonetheless.

Adding audio you record yourself

And here is where the answer to using audio in PowerPoint really lies. You can record your own audio, using QuickTime if you’re an Apple user, or Sounds Recorder if you’re using an older version of Windows; otherwise you can also record it on your mobile or digital recorder and import it onto your computer.

You would use this audio if you were going to upload your presentation to your website for a webinar, or for people to watch online afterwards. EzyLearn uses it in some of of online training courses. You could use audio in your induction training courses, too.

learn PowerPoint online training course

Brush up on your PowerPoint skills, or learn how you can use PowerPoint to create your own online induction training courses with our PowerPoint training courses.


Xero online training course

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

Choose from our wide range of:

Enrol today!

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.


 

You Can Use PowerPoint to Create Online Induction Training

Create an Online Induction with PowerPoint

learn powerpoint online training course
When you have to train contractors or new staff about your policies and procedures, an online induction is the most efficient – and effective – way to go.

At EzyLearn we have a bit of a soft spot for PowerPoint. It’s the oft-overlooked program in Microsoft Office that is typically associated with slideshows and presentations, and often boring ones at that. But it can do so much more.

You can generate animations, videos, movies, advertising, web design embellishments and graphics using PowerPoint. It’s a great ally to the social media or design person in your organisation. This creative design program can also be used to conjure up the most eye-catching and modern pictorial slides to enhance any presentation and keep people absorbed.

But did you know PowerPoint can also be used to create an online training induction course? Induction training is imperative for any business that hires contractors to perform work for them, either onsite or elsewhere. Induction training is necessary that any contractor or employee understands your company’s policies and procedures, whether they’re going to be working at your premises or not.

Our PowerPoint Training Course takes you through how to create your own induction training course using PowerPoint, which you can then deliver to your staff and contractors using a learning management system, or we can deliver your induction training for you.

Simple inductions that work

The end goal of an induction course should be to have all your contractors complete it, and learn something from it. You need to strike a balance between an induction that includes every last bit of information about your business, how it functions, its policies and procedures, and one that only covers the bare essentials.

Use images to illustrate risks and scenarios, as opposed to describing them. This is easy when you’re using PowerPoint to create your induction training. And remember the PowerPoint golden rule: One idea per slide.

Authenticating students

After you’ve created your induction training course in PowerPoint, it’s vital that your contractors actually complete it. This is why it’s important to authenticate each contractor or student who takes your induction training course — it also helps if you include a short quiz at the end, so you can see whether they paid attention.

There are a couple of different ways you can authenticate students to ensure the correct person is taking the induction course (and not their mum or friend or partner, for example). We talk about the different authentication methods you can use on our website, but keep in mind that only inductions delivered to students via a learning management system can authenticate students.

***

learn PowerPoint online training course

PowerPoint is, quite simply, fabulous.

Brush up on your PowerPoint skills, or learn how you can use PowerPoint to create your own Online Induction training courses, with our PowerPoint training courses. Read more about PowerPoint and how it can help you with your social media and design work.


 

Hiring Someone New? Why You Need to Personally Check their References

Why It Pays to Call the Switchboard When Doing a Reference Check

reference checking
How do you really know the mobile numbers provided for references truly belong to who they say they are?

I recently had a conversation with a colleague who said she’d never once been asked to produce a copy of her university degree or her transcripts, despite stating on her resume that she’d graduated with a high distinction average.

Gee, I thought, not once? Not a single recruiter or employer had ever requested a copy of her degree? I found this fact astonishing, particularly since more professions require, by law, certain qualifications — as BAS agents are, for example. So how people know my friend wasn’t fibbing in her credentials? Fact is, they didn’t.

Check, even if you use a recruiter

I wrote a blog some time ago about recruiting on LinkedIn and why it’s so important to check references for yourself. People often underestimate the importance of checking a person’s credentials, so long as they get a reference from their last employer. Often, though, most people only provide a mobile number for their references, so whether you’re speaking to the candidate’s former employer, a co-worker, or their mum is sometimes anyone’s guess.

I was reminded of how important reference-checking is again, when I was reading a couple of articles on Longreads, and I found myself utterly fascinated by two of the biggest cases of journalistic fraud ever committed (though I admit to having never heard of them before the weekend, despite one occurring more than 30 years ago).

Sometimes people don’t just lie on their resume

In the first instance, a journalist named Janet Cooke fabricated a story for The Washington Post about an 8-year-old heroin addict. She won a Pulitzer Prize for it in 1981, and then had to give it back when it came out that there was no such 8-year-old. In the second case, Jayson Blair, a journalist for The New York Times, was found to have fabricated or plagiarised 36 out of 73 stories written over a 6-month period, in what turned out to be the biggest scandal in the newspaper’s hundred-plus year history.

What I found most intriguing, though, was that neither Cooke nor Blair had been properly vetted before their employers hired them. In fact, it was Cooke’s falsified resume that was ultimately her undoing when, after receiving the highest honour in the field of writing, a former employer noticed something was amiss with her Pulitzer biography — her education and professional achievements had been grossly overstated. (Rather ironically it was Bob Woodward, of Woodward and Bernstein — the journalists who uncovered the Watergate Scandal — who signed off on hiring Cooke.)

The same would prove true for Blair, who, it turned out, never graduated from university, and had a murky work history with the Times’ sister publication, The Boston Globe, where his superiors had been less than impressed with his less-than-high standard of work.

(Of course, the equally interesting case of Australian author, Helen Demidenko, who won the Miles Franklin Award in the early 1990s, only to later be dubbed by the Sydney Morning Herald as a ‘literary hoax’ also springs to mind.)

Benders-of-truth almost always get caught

Plenty of people lie or embellish on their resumes, and while a good majority of them go unnoticed, others are caught out — sometimes very publicly, and often only after the organisation has been very publicly embarrassed, as in the case of Cooke and Blair.

My advice, then, is to always check the references of new hires meticulously. Rather than calling the mobile numbers or direct lines of the candidate’s references, call the main switchboard and ask to speak to that person’s manager or superior.

And always ensure to ask for a copy of any credentials, like university degrees. If you’re employing someone where, by law, they’re required to hold a certain qualification — as is the case for BAS agents, for instance — it’s imperative you can verify the person’s credentials.

***

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 (Excel, PowerPoint, Word) or social media and WordPress web design). 


 

There’s So Much Cool Stuff You Can Do With PowerPoint

PowerPoint: The Great Visual Aid to What You’re Saying

PowerPoint online training course
Save densely-worded slides for university lecture rooms: keep PowerPoint slides concise and use your presentation as a way of illustrating or highlighting what you’re saying.

Many people don’t realise what an excellent design tool PowerPoint is. It can be used for a lot more than just creating slideshows and presentations and is a great marketing and design tool for all kinds of business functions.

Generally speaking, when using PowerPoint, you should feature only one idea to a slide. A PowerPoint presentation is not an essay. It shouldn’t be filled with verbose text (unless perhaps you’re in a university lecture). In fact, as you will learn in our updated PowerPoint Training Course, sometimes a PowerPoint slide shouldn’t contain any text at all, or at least, very little.

PowerPoint presentations that are going to be used as a visual aid should do just that: visually aid the audience through your presentation. It shouldn’t contain your speaking points and you shouldn’t recite from it verbatim. Ideally, you should treat it as a source of further information (or illustration) for the oral portion of the presentation.

Illustrate your points

Use shapes to illustrate information, rather than bullet points.

Okay, in a perfect world, there’d only be one idea per slide, but PowerPoint presentations are tedious enough to create, without having to use a new slide every time something we wanted to articulate contained a subtopic or, more likely, a few subtopics.

But rather than using tried and trusted (*zzzz*) bullet points, try to illustrate the points and use a small amount of text to give more detail. For example, if you’re presenting your company’s latest financial results, rather than writing out how much revenue each department generated, include a pie chart or graph to illustrate this for you.

Shape your points

If there isn’t any way to easily illustrate your points, use shapes and textboxes instead. This breaks up the monotony of a slide filled with bullet points and makes the information you’re presenting easier to digest.

It’ll make it easier for your audience to take notes, without missing any of the spoken part of your presentation. It’s also easier on the eyes, since it breaks up all the white space on your slide.

If you must use bullet points…

Sometimes there’s no escaping it, we get it. Even though we’re not fond of bullet points in PowerPoint presentations, they’re sometimes unavoidable. So don’t worry, we still teach you how to use them in our PowerPoint Training Course. We even use them ourselves.

If you must use bullet points, dress them up with shapes and backgrounds.

If you must use bullet points in your presentation, try to use them in an interesting way. Put them inside a shape, change the background of your slide, or do both!

The key to a PowerPoint presentation that really pops is knowing how to use every function PowerPoint has to offer. That way, you’ll never have to settle on bullets when there’s a more creative option available.

Brush up on your PowerPoint skills, or learn how you can use PowerPoint to create your own Online Induction Training courses, with our PowerPoint Training Course.


PowerPoint — Use it for Facebook and other social media

Powerpoint Online Training for Facebook and social media
Not sure how to create videos and movies on social media? PowerPoint does all of this – you can then upload them to social media, such as Facebook and YouTube.

Did you know you can use PowerPoint with social media? We already know you can create modern, eye-catching and memorable presentations and slideshows with PowerPoint but you can also make movies and videos, animations and advertising graphics. These can then be published on an array of social media, including Facebook and YouTube.

Check out our Facebook Online Training Course and other social media course packages.


 

Bet You Didn’t Know the Many Wonders of PowerPoint!

PowerPoint: The Great Untapped Design Tool

learn PowerPoint online training course
Wow – this PowerPoint presentation really is AMAAAZING!!

 

You know what PowerPoint is. It was installed on your computer when you bought Microsoft Office. You hate it. But have you thought that the reason you hate it is because a) you’ve never learned how to use it properly, and b) you associate it with boring corporate meetings and seminars?

If you answered YES to one or both of those questions, read on. If you answered NO, still read on!

We recently updated our PowerPoint training courses to include new content and new exercise books — so you can never say that you don’t like PowerPoint because you don’t know how to use it!

Use PowerPoint for training

In our PowerPoint Training Course, we take you through how to create your own PowerPoint presentation, and we show you some of the different ways you can use PowerPoint, aside from as a sales presentation or visual aid during a speech, seminar, meeting or conference.

EzyLearn uses PowerPoint all the time. We use it to do deliver many of our training courses, in particular our WHS Online Induction Course. That’s one of the other things you can do with PowerPoint: create induction training for new staff, contractors or visitors.

But there are plenty more. Here are just a few other uses:

Business plans:

If, for whatever reason (there are many), you find you need to write a business plan, then PowerPoint is a much easier way to do it. You can plan, write, edit, and print your business plan all from the one document. If you discover you need to reorder any of the sections, you can easily move the slides around, rather than trying to cut and paste vast portions of text. Hot tip: don’t include more than one idea or section on a slide.

Marketing or sales collateral:

You can create virtually all of your marketing or sales collateral in PowerPoint, from price lists to product / services information to instruction manuals to flyers — even online advertising or FaceBook ads. Anything you can possibly think of can be created in PowerPoint. No, not Photoshop — PowerPoint!

Flow chart / organisational chart:

Organisational charts are an excellent way to give new recruits a lay of the hierarchical land (and help them better understand their new position). PowerPoint makes creating them easy — there’s a special function that lets you select a design and style you like, and then modify as needed. You can also use this function to create flow chart for large projects you’re working on.

Resumes:

If you’re still sending employers your CV in a Word Document, stop. It’s boring and visually unstimulating. There’s also a good chance the formatting gets stuffed around when someone opens it in and older or newer version of Word. Create a visually attractive resume in PowerPoint, making generous use of text boxes, images, and the shape drawing tools. It doesn’t matter whether you’re a graphic designer or a bookkeeper. Your resume should stand out. So make it (in PowerPoint).

***

Never Fear, Help is Here…

Learn Powerpoint online training course
PowerPoint can be an invaluable addition to your business skills – as well as for online ads, presentations, an eye-catching, modern resume – the list goes on.

 


Brush up on your PowerPoint skills, or learn how you can use PowerPoint to create your own online induction training courses, with our PowerPoint training courses.