Hairdressing salons are all about people, scheduling and gossip. They are located all over the world and are a fascinating place to watch. I had my hair cut the other day by a recently graduated hair dresser and she did a fantastic job with the cut and the conversation.
Hair dressing salons are a simple business insofar as renting a shop, putting in comfy chairs and mirrors and washing bays and then matching a customer with a hair dresser. The biggest issue is scheduling the right number of hair dressers to match the demand from customers, particularly if there are lots of drop ins.
Trim and Styles Hairdressing was using an Excel spreadsheet to manage their staff but now they’re using Xero and here’s why.
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.
So 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:
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.
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.
No amount of data is too big for Excel’s 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.
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.
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.
PowerPoint: The Great Visual Aid to What You’re Saying
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
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?
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.
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.
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.
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.
THE 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.
Never Fear: A “Sales” Pitch Can Really Just Be a Conversation
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.
Don’t Reinvent the Wheel: Glean Relevant Info from the Property Industry
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.
Type the first 3 characters to discover courses, up-skilling programs and CPD articles.
EzyLearn's Career Academy
Enrolled into an EzyLearn course since 2013? Get access to new & updated course content and support by joining the EzyLearn Course Refresher Access membership Program. See how to extend your course life & support.
Xero is a great bookkeeping program for tradies who are on the go and using their phones (or a tablet) all the time. From receipts scanning to creating quotes and invoices, receiving payments and keeping track of project costs.
bookkeepercourse.com.au/produ…
So 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.
And as a gift to you, remember our 
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. 
EzyLearn Excel, MYOB and Xero online training courses count towards 
THE INTERNET HAS CHANGED the way businesses market their services to prospects, from a simple sales message to an educational one. 
