Posted on

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!


 

Posted on

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. Continue reading Don’t Wing It With Customer Service – Plan It

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

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. Continue reading Marketing for When Your Business Strategy Changes

Posted on 1 Comment

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. Continue reading Should You Start a Business That You LOVE or a Business YOU CAN DO?

Posted on 1 Comment

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. Continue reading There’s So Much Cool Stuff You Can Do With PowerPoint

Posted on 4 Comments

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! Continue reading Bet You Didn’t Know the Many Wonders of PowerPoint!

Posted on 1 Comment

Use Excel to Manage ALL Your Investments

Once You Master Excel You Can Do Anything!

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

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

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

Excel is flexible

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

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

Cloud software is Excel plus PLUS

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

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

Export accounting data into Excel

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

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

***

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

***

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

Posted on 5 Comments

Performing Weekly Reconciliations in Xero

Why it Pays to do Regular Bank Reconciliations

bank reconciliations weekly
Doing regular weekly bank reconciliations will help avoid confusion or errors later on.

In our Xero Bank Reconciliations and Journal Entries Course, you’ll learn how to carry out each step in the reconciliation process, in particular how to set up bank feeds. Bank feeds are an important function that allows transactions on your linked bank account or credit card to automatically show up in Xero, so you (or your bookkeeper) don’t have to spend time entering the details from scratch.

Both contract bookkeepers working from home or employees working remotely or in the office can log in and perform bank recs using bank feed data. Continue reading Performing Weekly Reconciliations in Xero

Posted on

Working Out Job Costs and How to Charge Your Clients

Why You’re Underselling Yourself with Fixed Price Quotes

bookkeepers fixed price quotes
There are many reasons why you may lose out when fixed price quoting.

I’ve written a number of blogs on how bookkeepers can work out their fees and what good local bookkeepers generally charge. However, now we examine the nitty gritty of determining your on-the-job costs so you can clearly see what your hourly rate should be.

When it comes to working out fees, most business owners go: “Well, the average market rate for my profession is X per hour and this job should take around Y hours” and off they go and give their client a quote that, in today’s small business parlance, is frequently referred to as being a fixed-price quote or the project fee.

This would be fine except that you’re essentially working on an hourly rate, without the benefit of being able to charge the client if you run over your allocated timeframe. Continue reading Working Out Job Costs and How to Charge Your Clients

Posted on

What Bookkeepers Can Learn From Real Estate Agents: Facebook Advertising

Facebook – Great for Local Marketing

using facebook for bookkeeping marketing
Facebook can be extremely useful for marketing to a local audience.

In its decade of existence, Facebook has built up a wealth of data about its users, data that it likes to sell back to those who need it, in the form of targeted advertising. Facebook advertising, though similar in its approach, is very different to Google Ads in what it delivers.

Real estate agents discovered the value of Facebook advertising early, and have used a combination of images and videos to successfully deliver their marketing messages and sale pitches directly to their target market and in order to set their prices. Continue reading What Bookkeepers Can Learn From Real Estate Agents: Facebook Advertising

Posted on 1 Comment

What Bookkeepers Can Learn From Real Estate Agents: Using Video and Images

Focusing on Education Rather than Sales

how bookkeepers can use videoTHE INTERNET HAS CHANGED the way businesses market their services to prospects, from a simple sales message to an educational one.

Real estate agents caught onto this shift in buyer trends early and started creating online content to cater to these buyers.

Visit the website of any real estate agent and you’ll find lots of images and videos educating potential buyers about their services, previous sales and the local area they represent.

Continue reading What Bookkeepers Can Learn From Real Estate Agents: Using Video and Images

Posted on 1 Comment

What Bookkeepers Can Learn From Real Estate Agents: Sales Pitches

Never Fear: A “Sales” Pitch Can Really Just Be a Conversation

bookkeeping sales pitch
You actually don’t need to be ‘salesy’ at all; just find out how your services match another person’s needs.

After you’ve set the correct prices for your bookkeeping services, it’s time to perfect your sales pitch. It’s good to think about the way real estate agents sell a property to prospective buyers: Good sales agents don’t pitch to the buyer at all. Instead, they get to know the buyer and their needs.

If that happens to suit the property they’re selling, they tell them so. If it doesn’t they tell them that too. Often, they’ll mention another listing they have that might better suit the buyer.

Continue reading What Bookkeepers Can Learn From Real Estate Agents: Sales Pitches

Posted on 3 Comments

What Bookkeepers Can Learn From Real Estate Agents: Setting Prices

Don’t Reinvent the Wheel: Glean Relevant Info from the Property Industry

how much to charge as a bookkeeper
As a bookkeeper you can learn much from the humble, or not so humble, real estate agent!

As a bookkeeper, or someone thinking about becoming a bookkeeper, you may be surprised how much you can learn from real estate agents. For an example, take the way a real estate agent has to price a property for sale.

The key to selling a property quickly and efficiently, is setting the right price. A real estate agent who sets a price that’s too high for the market, isn’t doing her or his job properly. In such cases, the property will sit around for many weeks, or possibly even months, until the price is eventually reduced to one the market will bear, sometimes to well below market value.

Continue reading What Bookkeepers Can Learn From Real Estate Agents: Setting Prices

Posted on 1 Comment

MYOB, Xero or QuickBooks: Which Suits Your Business Best?

Which is the Pick of the Bunch?

xero myob or quickbooks which is best
It’s a competitive accounting software market place out there … which is the pick of the bunch for you?

IN A PREVIOUS POST, we highlighted some of the biggest differences between QuickBooks and MYOB

However Xero is also a serious competitor to MYOB (and QuickBooks to a lesser degree).

So let’s take a look at the different capabilities of each accounting application and the kinds of businesses they best suit.

Continue reading MYOB, Xero or QuickBooks: Which Suits Your Business Best?

Posted on 2 Comments

Is QuickBooks Better than MYOB for a Small Business?

How Does QuickBooks Really Stack Up Against MYOB?

compare QuickBooks and MYOB
QuickBooks is a much simpler accounting package to use than its rival, MYOB.

WE RECENTLY INTRODUCED our QuickBooks Online Daily Transactions Course because we can see that QuickBooks is fast becoming a serious and respected rival to the more established accounting software packages.

We recently wrote about how QuickBooks uses the SuperStream-compliant service KeyPay to deliver payroll services because QuickBooks itself isn’t actually SuperStream compliant. Currently, the payroll feature in QuickBooks is free for all Small Business plans, as the company further positions itself as the low-cost accounting software option for Aussie small businesses.

Continue reading Is QuickBooks Better than MYOB for a Small Business?