Posted on 4 Comments

Can a Bookkeeper Give Online Marketing Advice??

National Bookkeeping - How to Earn More Money

Outsourced Online Content Marketing and Bookkeeping

What is Content Marketing and Does it Work?

Measurement of success of content marketing campaign

I recently wrote about content marketing and how we have used it for years to ensure our MYOB and Excel Courses appear in Google’s organic search results. I touched on the topic of “who is your audience”, why it’s important and how it may affect your writing style – in reality you just need to write like you are sending an email to a friend, don’t you think – but one of the most important things is to measure the results of your work.

We started using WordPress as our website development platform because it’s relatively easy to use, but mainly because millions of people use it around the world and there are LOT’s of great tools within the platform. These tools are called plugins and they enable any business owner to take control of their website and improve it bit by bit every week or month.

WordPress is like the Microsoft Word of content management systems (CMS) and enables all of the functionality that most people want to see in a professional website, including the capability of enabling a mobile friendly site (important with the new changes in Google for mobile optimised websites).

If you are starting a content marketing strategy I recommend you work at your website every week or two, writing great new content that is relevant to your customers and prospects.

The above chart demonstrates the success we had helping one company improve their organic rankings (in a pretty competitive market). All they did is kept adding relevant text and images to their website that helps website visitors find them and answer their questions.

Want To Learn How To Do This?

Can anyone do this? Yes they can. Like most things there is a formula to success and it takes constant work and regular improvement. I’ve teamed up with a content writer and a digital strategist (could you imagine seeing that job description even 15 years ago?!), to create a course designed to help you learn how to plan and execute a content marketing strategy.

Can a Bookkeeper Do Content Marketing?

I was speaking with Ray from the Startup Academy and we were talking about what makes a good bookkeeper. He mentioned a conversation he had with an experienced bookkeeper he knows who has been bookkeeping for quite a few years and she mentioned that her focus is changing, that she is now starting to spend time on all sorts of aspects of the finance and administration of the businesses she works for. Because of her knowledge and experience she is able to take over many of the other “operational and administration” aspects of her clients businesses and as a result she can:

  • Do more work for fewer clients (easier to manage, yet still spreads her risk between several clients)
  • Perform more varied tasks for her small business clients
  • Earn a higher rate of pay

Can a Bookkeeper Become a Small Business Manager?

How bookkeepers can earn a higher rate

Have you read about our relatively new initiative to help people start their own bookkeeping business? One of the training courses we include is the small business management course and we’ve included it because it helps you clearly define the operational aspects of your business plan. Things like

  • how many customers do you want,
  • how much do you want to charge,
  • what type of work do you want to do etc.

Although there are fairly standard rates that bookkeeper charge for bookkeeping work, these rates can increase if your skill base is broader and you can become more valuable to your clients.

I read a recent article in the Sydney Morning Herald (from Feb 27, 2015, by Alexandra Cain) where she talks about the number of bookkeepers there are in Australia (estimated to be 250,000) compared to the number of bookkeepers who are registered with the Tax Practitioners Board as How to become a Registered BAS Agent (12,000). Alexandra introduces the topic of what type of work bookkeepers do and it’s highly practical for them to venture into many other parts of the business.

Every Course To Be Included in National Bookkeeping Package

Start a bookkeeping business not a franchise

This is the news that I have been waiting to announce – that we will be including ALL of our courses and any future courses to people who join our new bookkeeping business opportunity, National Bookkeeping. New members will receive thousands of dollars worth of training courses in EVERY course we have so they’ll have knowledge (and access to a knowledge base) about

  • Marketing,
  • Website design, Blogging and Internet Marketing
  • Content marketing, plus using Microsoft Office Applications like,
  • Microsoft Word, Excel, PowerPoint etc

We have courses on using help desk software like ZenDesk (that we use), Dropbox and stacks of other short online courses, PLUS we’ll be creating new ones during the year (and the next and the next) that National Bookkeeping Licensee will have access to.

If you are interested in exploring this opportunity further, feel free to go through the Bookkeeping Business Opportunity FAQ’s or make contact with us for more information.

Posted on 5 Comments

Content Marketing Gives You Organic Success on Google

content-marketing-by-blog-postsWhen I started my blog more than 5 years ago, I felt a bit like a computer nerd. I mean, who wanted to read about how to do bookkeeping and accounting using MYOB?

Then cloud accounting became a thing and software once more became exciting.

MYOB vs Quickbooks vs Xero Training Courses
Share price information for MYOB via Comsec

Incidently, the big fight to become the most successful Cloud Accounting Software is now well underway with MYOB having just been relisted on the ASX and its share pricing diving very quickly.

They’re competing with Xero and we wrote about the fierce competition looming against MYOB in 2010 when Craig Winkler (the man who build MYOB into the success it become now being a significant shareholder in Xero).

What made bookkeeping exciting to so many more people?

Bookkeeping became exciting, in large part, because of the flexibility it offered busy people wanting more control over their working lives, and busy parents trying to juggle priorities.

We could create a content marketing strategy about how cloud accounting makes bookkeeping faster and easier for small business, while also making it possible for parents to work closer to home (or at the family home), performing bookkeeping tasks and avoiding traffic, congestion and time you never get back commuting.

I should also confess that, at the time, I didn’t realise how important AND time consuming content marketing would be. Every blog post takes at least an hour!

You may ask how what appears to be a relatively simple blog post can take that long? In reality, a well researched blog post, including topic research, finding images, finding the right page(s) to link to can take several hours and that’s what we’re going to share in our soon-to-be-launched Content Marketing Course & Services.

Why does it take so long to write a blog post?

content marketing training courses and services
Content Marketing is worth the effort and now is the time.

If it were the case of just writing some sentences, it wouldn’t take that long at all. But what’s the point of that?

I’m not going to insult people, particularly people who have proven that they take the time to read my blogs on a regular basis, with poor quality, rushed content.

Furthermore, everything I write relates to something else we do and it involves:

  • Carrying out research to back up what I write about (like the above information about MYOB shares and a previous blog about both MYOB and Xero getting smashed by a huge US based competitor)
  • Referencing our own landing pages for the services we provide, and
  • Linking to relevant blogs that I’ve written.

Getting found: Optimising your blog posts for Google

I haven’t even mentioned the time and effort in optimising each and EVERY blog post for the keywords that are important to us. That involves:

  • Tags
  • Keyword density
  • Relevant landing pages
  • Keywords in headings
  • Images

Outsourcing blog writing to the Philippines, India or the Ukraine?

Tempting isn’t it? The thought that you can get someone to write a great blog post for your business for $2-3 per hour!

I mean in one day you could get all your writing done and then just schedule the blog posts to be published in something like your WordPress Blog over the next month or two. But it’s not that easy it is?

We are in an age where just stringing some words and sentences together isn’t going to get any one to pay much attention, particularly if there is a hint of broken English or disconnect with the topic. And anyway, if you’re going to write content you need to be an expert don’t you? Who wants to read some words that have just been sprayed onto a page because they have relevant keywords?

Content Marketing Strategy — who is the reader?

Like many tasks involved in small business, the most important part of the work is creating the Content Marketing Strategy; the plan for:

  1. Topics that will interest your readers and potential customers
  2. The keywords to be used in those articles (blogs)
  3. The landing pages that will convert potential customers into customers

Some of these components have nothing to do with the intended reader, but if your content marketing is going to be effective you’ll have to have a clear description of your reader in your head — I like to give them a name, imagine how many children they have, where they live, why they’re using my products/services, who their friends are, how they are going to talk about our company etc.

A wise old business owner I use to speak with regularly kept asking me the question, “Who is your customer, Steve?” This relates to everything. It relates to content marketing, but it also relates to when our courses are available, how we combine several features into one offer, how we try to do more for that market, like find other ways for them to benefit by using our service, hence National Bookkeeping!

What are you doing for your reader?

Start a bookkeeping business not a franchiseMost of our online training students use our services for MYOB Training Courses, Excel Training Courses, Xero Courses and Small Business Management Training.

For most people it’s because they’re looking for bookkeeping work or want to start a bookkeeping business. Finding out as much as possible about why our students do our courses enables us to develop products (and write content about) what they need.

Join our Bookkeeping Directory TODAY

We partner with a bookkeeping directory which is aimed at helping people (our students primarily) find bookkeeping work or start a bookkeeping business. It’s also a great way for small businesses to find bookkeepers who are close to them. 


Find out how you can promote your bookkeeping services to a much wider circle of people by engaging in content marketing.

List yourself on National Bookkeeping

Posted on 2 Comments

MYOB Accounting – Fighting to Stay In Control?

Is MYOB Just Another Program In Your Control Panel?

MYOB Accounting software online training coursesI was cleaning up my computer this morning and went to my Microsoft Windows Control Panel to discover MYOB Accounting Software sitting in the program list. I was removing any programs that I may have installed to test or get to know with a goal of REMOVING all that I didn’t need, when I saw MYOB software in the list.

I didn’t see WordPress and I didn’t see Commonwealth Bank Internet Banking in the list and at that moment I felt a little sad, realising that if I changed computers that I would need to go through the program installation process with my accounting software AND that EVERY person who needed to access our bookkeeping software would have to go through the same process.

Cloud Software Doesn’t Need to be Installed On Your Computer

I’m used to going to websites, logging in to do my work and then logging out at the end. Yes, with some I have to change the password regularly and others there is 2 level authentication using a mobile phone number as well, but the great thing about these “cloud-based” services is that I don’t even need my own computer! I can log in using an iPad, laptop or even my smart phone.

Cloud accounting should be like Xero and Quickbooks onlineWith services like Google Apps, we can run our entire company “server” in the cloud and have experts make sure it is up and running all the time for the cost of less than $100 per month, compared to several thousand dollars to buy the hardware (and have the floor space, data, power and air conditioning) , thousands of dollars in software licences and then having to hire an expert IT service person to manage it all for thousands of dollars per year – particularly if something goes wrong.

I’ve always wondered why MYOB didn’t focus all of their efforts on building a fully featured accounting program for the cloud only and wrote about how it seems like MYOB is computer based accounting program with the functionality of Dropbox. Some people think it’s more secure or safe to keep your accounting information local, but I’m not convinced.

How does MYOB compare to Xero and Quickbooks Online

I recently wrote about Ken from Love My Home Theatre and why he loves Xero Accounting Software (not Zero) and also about how the new market for cloud accounting software is not only introducing new competitors like Xero, but also enabling MASSIVE competitors like QUICKBOOKS back into the Australian market for accounting software once again.

If you are a regular reader you’d also know that we’ve had Xero Training Courses for quite a while now and that our focus is to help people looking for bookkeeping work AND small business owners learn bookkeeping software to help them run their business more efficiently and be compliant with the ATO.

The most impressive features of Xero Accounting Software are:

  • Xero can be accessed from anywhere at any time
  • Xero can accommodate multiple users (accountant, bookkeeper, business owner) no matter where they are located (which is great for virtual assistants doing bookkeeping from their own home)
  • Xero integrates with other cloud software programs (watch the video interview about Xero accounting with a small business that love it)

The best thing about cloud based software services (apart from having experts making sure it is always up and running) is that when new features are built they are available to you immediately. Xero recently announced the capability to create quotes and manage inventory which brings it even closer “feature wise” with MYOB and although I haven’t had a chance to see it in action, Margaret Carey (who contributed to our XERO vs MYOB feature comparison) notes that:

[quote]Any business that requires more than basic tracking will need to continue to look at the add on solutions such as Unleashed or Dear but it is a promising start.[/quote]

Xero is Definitely Becoming More Popular

Whether Xero has just done some great marketing this year, or that people genuinely want the benefits of a cloud-based accounting program, we are experiencing increased enrolments into our Xero Training Courses.

It could also be because all of our Xero courses are included for the one low price – we don’t sell them separately AND we include new content during a students membership period.

We use all of the major cloud-based accounting programs and I can say personally that I like what I have seen with Xero and Quickbooks Online. The fact that you don’t have to go through that labourious process of downloading, installing and registering your software (for each user) is a great bonus, but the fact that you can use these programs from any computer is even better.

Stay Tuned for QuickBooks Online Training Courses

This year will become a very interesting year as online accounting software companies fight for your business as well as loyalty from bookkeepers and accountants. I can reveal that we have started writing the content for our soon to be launched Quickbooks Training Courses! Jacci, our Register BAS Agent is working to replicate the small business accounting processes we use in our MYOB and Xero courses to teach students how to manage business accounts using Quickbooks Online.

If you want to receive updates and launch information about this course please visit our Quickbooks Online Training Course page.

Is there a wave of innovation in online accounting from Canada?

Wave accounting has 1 million users and is free_freeWould you like to hear about MORE innovation in accounting? Want to learn about a cloud-based accounting program that boasts more than twice as many users as Xero?

I was speaking with an insurance agent who is contributing to the risk management components of our Small Business Management course and he was telling me about this great accounting software that is completely free unless you use their merchant services and/or payroll. I haven’t confirmed any of these features of the software, but a quick visit to their website shows an interface that looks very much like Quickbooks Online with the navigation panel on the left of the screen.

My insurance agent friend Ruben is sharing information with us about how Workcover works for small business owners as well as public and product liability. He’ll also share with us how these relate to contractors who might work for you and go to perform work at a customers site.

If you decide you’d like to take a look at Wave Accounting or you are already a customer of this accounting program please share your opinions with us at our Facebook page.

 

 

Posted on

Beginners to Advanced Microsoft Excel Course for $197 inc Exercise Files

$197 Beginners to Advanced Microsoft Excel Course includes Exercise Files

Microsoft Excel Training Course exercise files

One of the best ways of learning how to use a program is to use that program during your training. Some people can sit with programs like Microsoft Excel and learn by trying something out and making mistakes and then trying again.

[box type=”tick”]We’ve discovered that Microsoft Excel course students want to work with real world files in a logical step-by-step method that uses the exercise files for the basic skills and then keep using that file for the more advanced skills.[/box]

By the end you’ll have a powerful Microsoft Excel spreadsheet using advanced skills and because you learnt in a logical and methodical way, using gradually more complicated tools, you’ll have learnt most of the Microsoft Excel skills you’ve wanted and won’t even notice the time go by.

Real World Use of Microsoft Excel Spreadsheets

Excel training course exercise filesThe main uses for Microsoft Excel are as a:

  • Worksheet that enables you to lay out information in a logical fashion and then perform calculations with that data
  • Database that lists all of the information in a tabular format that can then be filtered and manipulated into a format that can be used in mail merges etc, and
  • Charts and graphs that visually present the information in a worksheet or table so that we humans can make sense of the information

Here are some of the ways that we use Microsoft Excel for our training business.

Present information for use in newspaper ads

In Microsoft Excel Course 303 we look at formulas and formatting and one exercise file we share with students and an example of what’s possible using Excel is the artwork we created for the newspaper ads for our courses at our training centres in Sydney. The table structure of Excel enables us to lay the information out precisely and if we need to change the dates

What costs us the most money

Yes, you can see the costs of running a business in a simple table, but when you put it in a chart you can visually see the differences in costs and in our 305 course on charting we’ll show you how to create the various different types of pie, line and bar charts as well as many other types. You’ll learn how to format the charts to make certain areas stand out and you’ll learn how to demonstrate trends.

Budgets and forecasting

It’s great when you have historical information to work with because you can spend a lot of time working out percentages, margins, budgets etc to try to figure out how you will go in the future. We include many exercise files in Microsoft Excel Course 306, including files to help you:

  • Maintain a household (or business budget)
  • Calculate sales margins and commissions for sales people (we have several different versions of this file to demonstrate how the file should look at the various stages of creating it).
  • Create a price list (including all wholesale product costings – that will be hidden from view)

 Making the right decisions

When we operated our training centres in Sydney we spent a lot of our time scheduling courses. We had to allocate training rooms, roster on our great trainers, print training materials and we needed to know when people where coming to courses. We discovered that most people who wanted to learn Microsoft Excel did a night class. We had these variables to work with:

  • The courses
  • What days people had come to these courses in the past
  • The time of the day that students had enrolled into these courses: morning, midday, evening or weekend.
  • Different training methods (class-based and Flexible Learning)

By discovering the best days and times that students had enrolled into courses from the past we were able to better schedule our courses to get the most students. It means we didn’t need to cancel courses.

See the contents of Microsoft Excel Course 308 for more information.

Figure out how to make more profit

In a business you can build a bigger business and make more profit by

  • increasing sales,
  • cutting costs,
  • focussing on your most profitable customers,
  • focussing on your most profitable products,
  • decreasing the time it takes to get your money (cash sale or terms).

Using Goal Seek in Microsoft Excel we discovered something that’ll help all independent contractors run a better more profitable business.

 

Posted on

5 x MYOB Training Courses and 12 Months Access

MYOB Training Courses delivered in Sydney, Melbourne, Brisbane, Adelaide, Perth, Darwin and HobartMYOB Courses

Because it’s the beginning of the year we are receiving a lot of calls from students who are looking to do an MYOB Course so we are thrilled to confirm that we offer access to ALL of our MYOB Courses for one low price and 12 months course access.

When we say ALL, we mean

Why All MYOB Courses for One Price?

You can follow our journey from operating training centres in Sydney’s Dee Why, to the decision to go 100% online at the About EzyLearn page on our website, but I’ll sum it up in 1 paragraph here:

We can guarantee consistent course content to every student, with MYOB Course content developed over 15 years in teaching people how to use MYOB and from some of the best MYOB Trainers in Australia. By creating our own MYOB courses and updating them we are able to focus on the content of our courses as well as the systems to support it online rather than paying for office rent, computers and software licences, trainers and advertising.

MYOB Course Options

The only decision you need to make is whether you want an MYOB certificate and 12 months or lifetime course access. Remember that unlike some MYOB course providers our students can move freely from one course to the next as they please and use the course as a resource while at their new job or operating their own bookkeeping business.

MYOB Videos, Training Workbooks and Knowledge Reviews

With a 100% focus on MYOB Course content we create every form of training material for MYOB accounting software: Videos, Workbooks (with step-by-step exercises) and Knowledge Reviews that test your skills. You can watch a video and try to replicate it with the free MYOB software or follow the exercises in the MYOB Trainingg Workbooks to perform tasks that bookkeepers perform every day in their working environment.

Money-back Guarantee

When we were the first training company to offer MYOB courses online in 2008 we offered the money-back guarantee because not everybody had great broadband Internet speeds, not everyone knew how to navigate around websites and online learning management systems and people where generally scared to use their credit card online. Now-a-days we find that the biggest reason some students find it a comfort is because many students are Mac users and are not sure that they would learn by using MYOB Course content created for the Windows versions of the MYOB software.

Why Thousands of Students Choose EzyLearn for MYOB EVERY Year

We use the Content Marketing approach to building our brand and product awareness and it takes a lot of effort to put the amount of detail we put on our website and in our blog posts. We do it because it shows an ongoing commitment to openness but also to leave no doubt as to exactly what we offer and how we support it. If you want to get to know more about us read some of our blog posts or watch some sample videos. If you are ready to enrol into an online MYOB course then enrol now online and start by 5pm next business day!

Posted on

69% of MYOB Skills Test Students Failed – Would You?

MYOB Skills Test and online training coursesMYOB Skills Test

It’s that time of the year again when people are acting on their new years resolutions and embarking on training to improve their knowledge and skills. In 2011 we introduce a free MYOB online skills test that anyone can do to test their knowledge of MYOB software and it interesting to see that the average score has increased from 40% to 55% over the last 4 years!

What more interesting is that most attempts resulted in a fail score – 69% of students failed to pass. You can do the test several times if you want and if you get an answer wrong the skills test can show you the correct answer – it helps you learn.

We have a test like this at the end of each section of each course (ie. there are lots of them) and we focus on using them to help students consolidate what they’ve learnt as well as show them what the correct answer is. We see our knowledge reviews as a teaching aid rather than something to be scared of.

If you are interested in learning how to use MYOB to find bookkeeping work or start your own bookkeeping business look at what is included in our MYOB Courses (5 courses for the price of one) and start your journey on a new career or the flexibility of having your own bookkeeping business.

 

Posted on

Who really cares about Sensis? Yellow Pages? Content Marketing shows you care

content marketing versus yellow pages and sensisYellow Pages vs Content Marketing?

A client of ours showed me an email that came from Sensis and it looked a little sad. It showed how many times an ad appeared and how many people clicked for more information. The saddest part is that this Billion dollar company is now just another online directory. It’s another example of how a traditional business, that hires professional and persistent sales people to sell high cost packages is dying an accelerating death. The other large one I recall was Encyclopaedia Britannica – remember those door to door salesmen who made a good income selling these for your children’s benefit? OK, now I’m assuming you’re over 45 😐

Why Content Marketing

We decided many years ago to go down the blogging route because it makes sense. These days the correct term for blogging for business is “Content Marketing” and it’s great because it’s a way of:

  1. Constantly informing readers,
  2. Demonstrating an active business and website
  3. Informing website visitors about changes in the business,
  4. sharing stories about how people use our services and
  5. Making general announcements.

How Bad is the Yellow Pages Directory Going?

Telstra recently offloaded their majority ownership in the Yellow Pages business they branded as Sensis and in the fine print on page 15 (2013 year) and page 18 (2014 year) you can see that the revenue for this business declined by 11.7% and 22% respectively.

I remember when most local tradies (plumbers, electricians, chippies, builders etc) would spend tens of thousands of dollars per year to keep their position in the large display ads. I even remember the days of the golden phone that Yellow Pages use to make available to business to PROVE just how many phone calls would be coming in the door as a result of advertising with them. If anyone remembers the golden phone offer I’d love hear from you on our Facebook page..

Where do you spend your marketing money?

The idea for this blog post came as a result of being forwarded an email, but it ties in nicely with our Small Business and Startup Course which is now available at a hugely discounted price! Read on to see how we changed our pricing structure.

Marketing and Communication course for small businessIn this course we have two subjects which cover marketing for small business and we have some great interviews with Michael Locke who shares information about the 4P’s. Sensis would represent an excellent case study of where the marketing function may not have been submersed in the strategy business decision making to stem this significant change in their business model.

Small Business Management and StartUp Course

The recent change we made to this course was to separate the business coaching and assessment options and make them available separately. In this way the Small Business and StartUp course is much like our MYOB course where you can work through everything at your own pace and request support if you need it.

If you are interested in doing a number of different courses as well as the Small Business Management course you might want to enrol at the Australian Small Business website where you can choose our software courses at a discounted price (when combined with the small business management course). This way you’ll be able to use WordPress for your content marketing, MYOB or Xero for your accounts and Excel for any spreadsheet work.

References:

Telstra Annual Reports 2013, and 2014

PS. By the way, you can still get Britannica and online it’s just under $70 pa. You can also still buy the printed edition for under $700 and you can pay $2500 for a whopping collection of short stories, plays and poems..

Posted on

Prevent Russian Attacks on Your WordPress Website with Google Analytics

Traffic from Russia, Eastern Europe, Philipines and India?

We’ve been busy these last couple months in upgrading and optimising our websites, fine tuning our online marketing and studying our Google Analytics and came across a Russian based website that was sending a lot of traffic to several of our sites. After closely monitoring our website traffic, landing pages, bounce rates, time on site etc, we found a lot of in bound traffic from a Russian site called Darodar. It made me wonder why we’re all so scared of web traffic from the USSR. In fact it’s a reminder of the fact that labour is very cheap in some of these countries and some companies or individuals can go to great lengths to

The best thing to come from all this really is that by looking at our statistics regularly, updating all scripts and plugins and server side applications not only do we have an up-to-date website with security and protection against online risks, but we understand our website traffic in detail. This is helping us fine tune our website content constantly to provide our website visitors with what they are looking for.

I don’t normally write like this

Google Analytics - Channels, Sessions, Conversions, Sources, Aquisition, BehaviourI don’t normally like to write about all the technical details we have to go through as an online training course provider, but we’ve been assembling some marketing information about our new online business opportunities and realised this is exactly the type of information that we’ll be sharing with students who come along on our online marketing business opportunity.

As it turns out the type of traffic we were getting is called HTTP Referrer Spam or just Referrer Spam and hundreds of people are talking about it online already. Here’s a snipped of some of the sites we discovered. There is a lengthy conversation on an official WordPress Support Forum, and an article on a popular article site called Reddit.

The Best Answer

The best answer we found was this link that confirmed that this type of attack is not malicious to your website, is not a server side issue and won’t affect the ranking and traffic to your site. The biggest issue is that we spent all this time and even ended up going to the site in question (that’s one of their goals!!) and that it distorts our Google Analytics information.

We disable the Darodar Spambot and any traffic from this location. It’s not the best solution because we can’t do this for every website that performs this type of activity, but again, it gives us more clarity about what is happening with our website traffic.

Who cares?

If you want to get to know more about our online marketing contractor business opportunity go visit the StartUp Academy website for more information. I’ll be sending more information out shortly so stay tuned – including the services we are launching to help people start their own bookkeeping business..

Posted on

Did I Mention a Free Excel Beginners Course?

Free Excel Beginners Course

I recently wrote about our Microsoft Excel [link]  Training Courses and how they have the features that make all of our online training courses popular, but I forgot to mention that we make the Excel Beginners Course available for free. These free training videos AND Excel Course workbook will give you the confidence to understand the main uses for Microsoft Excel.

Microsoft Excel can be used for lots of different things, but the main uses are:

  • Worksheet (to do calculations)
  • Chart (to visually show the data)
  • Database (to store data)

Our Excel Beginners Course videos will give you the basic Microsoft Excel knowledge very quickly, but the Excel Beginners Course workbook and exercise files will give you the chance to replicate what you see in the videos and LEARN BY DOING. You’ll get the training workbook to print out and we’ll also send you the excel files that we use in our demonstrations.

Excel Intermediate to Advanced Courses

Don’t worry, once you master the basics you’ll either want to know as much as you can about Microsoft Excel or decide that you’ll just use the software when you need it.  Either way, with our LIFETIME course access option you can complete and repeat the course as often as you want and with all skills levels (from Beginners to Advanced Excel) you’ll be covered.

We’ve been teaching people how to use Microsoft Excel since we started at Lane Cove in Sydney in 1996 and we look forward to helping more people learn Excel to become more productive, more employable and more successful.

Make sure you share our free Excel Beginners Courses with your friends on social media.

[button link=”http://ezylearnonline.com.au/courses/microsoft-excel/free-microsoft-excel-beginners-course-training-videos/”]FREE Excel Beginners Course[/button]    [button link=”http://ezylearnonline.com.au/enrol/” bg_color=”#99050c”]Enrol Now[/button]

Posted on

Forecast a Positive Future Using Microsoft Excel

Time to Reflect, Thank and Plan

sales-forecasting-using-microsoft-excel-training-courseWe had our office Christmas party (for our Sydney team) this week and I went through and individually thanked each of my team for their contribution during the year. I’m very lucky to be working with a great bunch of people – although, you know what they say:”The harder I work the luckier I get” – and I used our Christmas lunch to thank each of them publicly (in front of their peers) for their efforts because I think it’s important.

We started a lot of diverse and interesting projects during the year and they include:

  1. Assembling a course to teach people how to create their own course – ideal for sites that want to create their own online Inductions for contractors,
  2. Worked with the Australian Small Business Centre to create new sales and marketing courses for their Business Management Course.
  3. Created a MYOB Bookkeeper Directory to help our students start their own bookkeeping business and find new clients
  4. Established the StartUp Academy to help ordinary people start their own business working from home

Treat Yourself as you Plan for Success in 2015

Sales forecasting using Microsoft Excel Training Courses and MYOB DataOne of our team members said she’s going on holidays and really needs the time off because she will be studying VERY hard next year. She’ll have 5 weeks off and she’s 21. I started to wonder if I am a workaholic, am a little twisted in my opinion of what makes a good holiday or that I just love what I am doing, but I offered to give her work to do while she was on holidays overseas for that long period of time – after all, isn’t it great to earn some money working from your computer, using the internet for a couple hours each day and then getting into the festivities!?

I was thinking about my ideal holiday – work a couple hours every morning (early if possible so no one is awake to distract me), then feel rewarded and REALLY enjoy the rest of the day and night. It gives me the feeling of still being connected to the world at home, while achieving something workwise and then cutting off completely from work for the rest of the day.

When I think about the festive season and the quiet time between Christmas and when most people come back to work (5th January 2015 or later) I see an opportunity to stay in Sydney where it almost becomes a pleasure to drive on the roads and spend the time in thought and contemplation to plan for the coming year. It’s usually the time when I write down my major goals for the coming year and start to clearly define them, how they’ll look and operate and what is needed to achieve them. It’s the time when I end up getting on my computer and powering up Microsoft Excel to do those once a year checks on the past and forecasts for the future.

Microsoft Excel Course for Financial Forecasting

Export Sales Report information from MYOB AccountRight to Microsoft Excel
Export Sales Report information from MYOB AccountRight to Microsoft Excel

Forecasts are those interesting things that investments are based on. Someone with a spreadsheet and a business plan will guess how much they’ll earn in the forthcoming year/quarter/month etc and back it up with all their evidence in the business plan. To many people it’s a waste of time because “who can really predict the future”, but to those people who do it it’s a way of crystalising your plans into monthly or quarterly objectives that are based on the past (in most cases) and on intelligent estimates of what the market needs.

Export Your MYOB Reports

If you already use MYOB Accounting Software to manage your bookkeeping and accounts you can easily export a report about last periods sales and use that as a basis for next years forecasts. Many slight changes can result in more sales and higher profits in 2015, including:

  • new products,
  • expanded services or
  • price increases

But your decision to no longer provide 30 days credit terms or be more diligent with late payers can help you earn your money twice as fast. Either way you do it, now is a great time to export that data from MYOB, or Xero or Quickbooks and get it into a spreadsheet (worksheet) so you can start to do some mathematics to show how much more you’ll earn in 2015.

Online Microsoft Excel Training Courses

If you’ve followed our blog posts you’d know that we have a very popular MYOB training course. I wanted you to know that we have a popular Excel Training Course too and it comes with the same benefits as most of our online courses:

  • 12 months or LIFETIME Excel Course access
  • Assessment and Certificate Option
  • Includes 9 skill levels from Excel Beginners to Advanced
  • Includes exercise files to practice
  • Includes multiple version of the Microsoft Excel Software
  • Each of the 9 courses includes an Excel Training Workbook with step-by-step exercises
  • Comes with a 30 day money back guarantee

 

Posted on 1 Comment

MYOB AccountRight Live Looks like MYOB-of-old + Dropbox

MYOB AccountRight Live OR in the Cloud?

MYOB AccountRight Live Basics - is it really cloud-based accounting software or MYOB and Dropbox 2
This is where you can see the myMYOB login and the Live wording in the cloud

We were asked by one of our MYOB course students recently how you can manage user access to your MYOB accounting file and we did some looking around, spoke to our MYOB course creator and came up with the following useful information.

MYOB AccountRight Live Basics - is it really cloud-based accounting software or MYOB and Dropbox 5 - manage admin and users
Click on Image to Enlarge – How MYOB AccountRight Live enables you to manage users

You can go to the MYOB website and click on my.MYOB to get to the details of your “participation” with MYOB AccountRight –

[quote]sorry, NERD ALERT! I happened to be reading the MYOB Terms of Service and “Participate” is the term that the MYOB legal team use to describe how companies use the MYOB AccountRight service -[/quote]

which enables you to choose your administrators as well as who you want to be able to access your file (like your bookkeeper or accountant). But you can also manage users from within the software. Note the out of place word here? – Software – Yes, when you launch the software and Open your Online data file, you can setup users and be much more prescriptive as to what they can access or not, but also which areas they have read only access as opposed to full access (read and write).

MYOB AccountRight User Access Managed in the Software

MYOB AccountRight Live Basics - Modifying User Access 2 - Role Based User Access
MYOB AccountRight Live Basics – Modifying User Access 2 – Role Based User Access

The silly part of this is we would expect cloud-based software to enable you to do everything in the cloud! If you look at the current MYOB model for their AccountRight Live product you still need to download the software to use it and you still need to update the company file if you update the software version!? We thought that this day had passed when the concept of cloud based accounting arrived.

Is it Designed to Help Current MYOB Users?

When I look at the way that MYOB AccountRight Live is managed at first it looks like it was built for people who are used to having a software program on their computer. Then when you see the capability to Open company data files that are stored “Online” you get the feeling that it would be just as easy to use Dropbox to store your datafile. The worst news comes when you expect the MYOB AccountRight Live software (that has a little cloud around the live) to work just like other cloud-based account programs like SAASU, QuickBooks Online and Xero you get dissappointed in having to install and use software on every computer you use – and I haven’t even tested to see if they have a program for the iPad.

MYOB AccountRight Live Basics - is it really cloud-based accounting software or MYOB and Dropbox 6 - company file needs upgrading
MYOB AccountRight Live Software – Company file still needs upgrading

If you are the kind of person that loves storing a local version of your datafile (and take the risks of protecting your own computer against, viruses, crashes or other corruption) this might seem like a good feature. I bet we see this product evolve until the point where it is finally an all online accounting solution.

How to change User Access Rights using MYOB Account Right Live

Although you can make some rudimentary changes via my.myob.com the best way to add users and make specific choices about what they can see as well as what they can edit and see, you need to launch the software (make sure you’ve downloaded it of course) and then go to Setup, User Access.

We used a current version of AccountRight Live Basics to perform our tests and any new content we create and publish for our MYOB Training Courses are available to existing students – whether you are on a 12 month course access program or LIFETIME course access. Feel free to enquire with us if you have any questions about our online MYOB Training Courses, or enrol today, start by 5pm tomorrow and be comforted by a 30 day money back guarantee.

Posted on 1 Comment

The Power of the Homegrown Australian Business

When ‘Aussie’ is a gold winner

Reach Accounting free course from EzyLearnIN ADDITION TO OUR MYOB and Xero online training courses, we also offer an online training course in Reach Accounting, the cloud-accounting software by Aussie-owned company, Net Registry.

Not many people are aware of this, and I’ve been quite remiss when it comes to talking about it on this blog. In fact, I’ve spent more time talking about Zoho and QuickBooks recently, than I have spent time talking about Reach.

This is partly because I’ve been quite interested to see how QuickBooks has been resurrected by it’s American-owned parent company, Intuit, as it attempts to take on Xero and MYOB in the Australian marketplace again.

Zoho is both comprehensive and cheap

My interest in Zoho, meanwhile, stems from one of my contractors, who uses Zoho Books to manage her business accounts; she was telling me about Zoho’s many features, and I surprised to learn just how comprehensive the Zoho Books software is for such a low price.

Zoho and QuickBooks are both positioning themselves as low-cost accounting packages to appeal to the substantial small business market in Australia, but there’s just one thing they can’t compete with Reach Accounting on, and that’s ‘Australianness’.

Reach Accounting is an Australian owned and operated business, and as the owner of an Australian owned and operated business, I like to support other Australians in their business ventures. Reach Accounting focus their accounting software towards people who start a business as a website designer.

Why it’s harder for Aussie businesses to compete

I’m always saddened when I hear of Australian businesses being sold to overseas conglomerates, which take the Aussie jobs back overseas with them, where the wages and materials are cheaper. It makes it all the more difficult to compete for customers in the Australian marketplace when your once-Australian competitor is now producing products or services at a much lower price at their offshore headquarters.

It’s also difficult to compete with the increasing number of overseas-owned businesses entering the fray, now that the Internet has unlocked a global marketplace. What many Australian businesses don’t realise, however, is that they possess a power those overseas businesses don’t: they speak Aussie.

Whether you’re a home-based bookkeeper or virtual assistant, one of your greatest assets is that you’re an Australian and that means you have a deep understanding of what it means to be Australian – from the accent to the vernacular, you get it.

The power of ‘G’day’

It’s also a lot easier to call an Australian company than it is to call an overseas one. My Zoho Books-using contractor was telling me of a complex situation she was experiencing with her account. Unfortunately, the nearest customer service office she could call was located in China, so she had to email.

Several confused emails later, she finally realised what had happened with her account, and managed to resolve the issue herself. She later told me: “It’s a good thing I studied semiotics at university, because deciphering those emails was like trying to interpret hieroglyphics.”

I suddenly thought about Reach Accounting, which is based in the Inner Sydney suburb of Ultimo. For the same price as Zoho Books – possibly even cheaper now, thanks to the fluctuating Aussie dollar – it would have been much easier to say “G’day” to one of the guys at Reach than it was to email China or India or Japan or wherever in the world Zoho’s customer service offices are based.

Don’t be afraid to say “G’day”

As an Australian business, don’t hide your Australianness from view. Wear it proudly, because it makes a big difference to customers trying to decide between your company and the multinational after their business.

For more information on any of our cloud-accounting courses, visit our website.

Become a Virtual Assistant and Start a Business

start a bookkeeping business
Business Opportunities for Ordinary People

While we are on the topic I want to mention our StartUp Academy because we are planning some fantastic ways of helping ordinary people start a business in 2015.

We’re using a combination of our Small Business Management Course and business opportunities from established companies who want to find people who can work from home and sell and support their products.

We’re also using our Small Business Management course to help our existing students start businesses using the skills they learn in their EzyLearn course – namely MYOB and WordPress. If you’re interested in starting a bookkeeping business read on about National Bookkeeping.

Posted on

Rapid Induct Staff and Contractors or Your Arse Can be on the Line

Online Induction Training for Your Company

online contractor inductions are important for safety training whs complianceTraining is something that I have been involved with since the mid 1990’s – sure, I don’t look that old, but it’s true – and we’ve used all sorts of tools to create our training courses, including:

  • Creating educational videos using Camtasia,
  • Creating some courses using PowerPoint presentations
  • Hosting the videos online using Wistia,
  • Writing training workbooks using Microsoft Word
  • Creating our website(s) using WordPress
  • Promoting our courses using Google
  • Deliver and managing the online training courses and students using Moodle

I spent a lot of time recently speaking with councils, city building managers, schools, aged care facilities and hospitals and have noticed a massive demand for inductions. These organisations want to rapidly induct their staff but more importantly their contractors about how things operate at their facilities. If you read my previous post about rapid induction you’ll know what I mean.

Staff Inductions

We use our own internal inductions to get new staff members up to speed quickly in how our business works, what we expect from them in customer service and most importantly how we offer, sell and support our online training courses so it makes sense to have a training program for existing staff. The most apparent need however is for contractors who come and work at your site and may never have been their before – for these contractors the biggest reason for having a contractor induction is to educate the contractors of any know risks at the site – like asbestos.

Contractor Inductions

EzyLearn free Powerpoint training course videos at Youtube for contractor inductionsContractors who come to sites like hospitals, councils, schools, aged care facilities, city buildings perform their work on complex equipment that could affect the safety of other people in the building. They need to be qualified to do the work they do and they need to have insurances to cover any potential incidents or accidents and WorkCover for their people. These aspects of a contractors work is often referred to as Contractor Management and when this term is used there is often confusion as to whether you are talking about the company or individual people who work for the company.

Many sites have a manual contractor management system which means they dedicate a certain time each week or month to go through files within folders for each supplier to make sure all of their contractors “credentials are up to date” – can you imagine doing this all of the time?! We have a system that automates this process by reminding them of when their credentials are due to expire and need updating, but I digress.

Create Your Own Contractor Inductions using PowerPoint

Startup Academy Create Online Induction Training CoursesContractor inductions are so popular these days because they are a sure fire way for site managers to demonstrate that they have informed the contractors about any potential risks at their sites – and that can save their bacon! Did you know that someone referred to as a PCBU (in WH&S law Person Conducting a Business or Undertaking), is personally responsible and liable if they neglect in their duty of care for safety at their site!

That is why it is important for everyone to have a contractor induction course. It’s also great that these courses can be initally created using software found in almost every office – PowerPoint. It’s up to you then how you want your induction to look to students, plain and simple slides or audio visual presentations.

[quote]Make sure you contact us to see how quick and easy it is to create your own contractor induction training courses and manage your own enrolments.[/quote]

Start Your Own Business Creating Online Induction Courses

If you like the thought of getting to know how to do this you should come and check out our Online Induction Business Opportunities page at the Startup Academy. My team will show you how to complete the whole process of creating a training course, starting with the creation of a simple powerpoint presentation. At the end you’ll have an online training course with test and completion certificates – just what every site needs for their contractor inductions.

Then if you want to build a business based on your new found skills you can work with us to find new clients and start living the dream of working from home helping local business with their safety training. Click on the StartUp Academy image and follow the links and you can even complete the first stage of the course for free.

 

Posted on 4 Comments

Smart TV Guy Has Feet Planted Firmly In Cloud Accounting

Smart TV Installation & Cloud Accounting Guy

As smart devices and cloud-based apps have become more popular, I’ve started to see more and more tradies using their iPhones and iPads to handle their paperwork, a task traditionally left to the wee hours of the evening – or to their wives and partners!

Now, with cloud-based accounting software like Xero and a number of other great mobile apps, tradies can quote, invoice, and even take payments for work right from their smart phones and tablet devices.

Streamlined business processes with cloud accounting

I met Ken Burrows from Love My Home Theatre, a home theatre installation, TV installation and plasma wall mounting business based in Sydney recently, when he was installing a new home theatre system for some friends, and I was taken with how streamlined his entire business processes were.

Everything – from the quote through to payment – is performed entirely online, using a couple of different apps, including Xero which is used to maintain the business’s accounts. In the video you can Watch Ken talk about how he uses cloud-based apps in his business to streamline his business processes, and make him more efficient and I think it helps 1 business owner do the work of more than 1 person – perhaps he can use more people in marketing..

EzyLearn offers a number of cloud accounting training courses, including our flagship MYOB training course, as well as training courses in Xero and Reach Accounting.

Share your cloud accounting story

start a bookkeeping business
Business Opportunities for Ordinary People

We’ll soon be running meetups for our startup academy in these locations.

  • Brookvale
  • Hornsby
  • Epping
  • Chatswood
  • Parramatta
  • Blacktown
  • Penrith
  • Bankstown
  • Liverpool
  • Campbelltown
  • Sutherland
  • Hurstville
  • Randwick

If you want to come along and share your story or learn more about the StartUp Opportunities for ordinary people, make sure you subscribe to this blog to keep up-to-date.

Posted on 3 Comments

Xero: The Tradies Choice for Accounting Software

Xero and tradies

Rohan the painter tradie uses xeroI once wrote a post about Xero and whether it had the potential to strip MYOB of its crown as the market leader in accounting software, and I’m starting to think that maybe it will.

I spoke with a couple of tradies recently, and they’re both using Xero rather than MYOB because of its functionality and the way it ties in nicely with other cloud-based apps, allowing them to spend less time in the office and more time on the road.

EzyLearn added Xero training courses to our already existing suite of MYOB training courses a little while back after it became clear that it was a major player in the cloud-accounting space. When Xero first hit the market, though, many people thought it was unlikely to have any major impact on MYOB’s marketshare (just as QuickBooks had failed to in the past), given MYOB’s long-standing relationship with accountants.

Xero perfect for tradies on the go

What most people overlooked, though, was that Xero was undeniably easy to use. Coupled with its flexible delivery – it was one of the first cloud-based accounting programs supported with mobile apps – it became an appealing option for many small business owners who previously found MYOB too difficult or time-consuming for day-to-day use.

Rohan Calvert, the director of Men in White, a Sydney-based painting company, is one those small business owners. He had been using MYOB to manage his business’s accounts for ten years, but decided it was time he moved his accounts into the cloud. After initially looking to upgrade to MYOB Account Right Live, Rohan opted to make the switch to Xero, instead.

Xero interview with a painter

Here’s what he had to say about Xero in the cloud:

EzyLearn: What features of Xero do you find most useful for your business?

Rohan: For me, the best thing about Xero is that there is a direct bank feed, so my [Xero] dashboard will show my bank balance alongside the balance in Xero, which makes reconciling [his accounts] very easy. I don’t use the mobile app very much – the functionality isn’t there for me yet. Instead I use the web version on my laptop. My office is basicallymy laptop – I have a laptop stand in the passenger seat of my car. With Xero, I can do payroll and issue invoices while I’m sitting in the parked car.

EzyLearn: How is Xero’s cloud-based software better for your business, compared to the older versions of MYOB you had used previously?

Rohan: I have a business coach in the US and we can look at my financials in real-time while we’re talking on Facetime. I have put a lot of work into simplifying and understanding my bookkeeping and with Xero my reports are accurate and tell me exactly how I’m going, and all in real-time. Previously, when I used MYOB, the financial reports were meaningless and my bookkeeper had to print them out and edit a spreadsheet, resulting in a lot of double handling.

EzyLearn: What do you like most about Xero?

Firstly, it is elegant and intuitive; secondly, it comes from New Zealand!

For more information on our Xero training courses, you can visit our website or, alternatively, click here to enrol online.

Posted on

Get Paid Faster Using Your Mobile Phone!

get paid faster using your mobile phone
You can use your mobile phone to get paid – great for tradespeople as well.

No doubt about it, one of the biggest hurdles you face as a small business owner is managing your cash flow. A big part of this is ensuring your clients and customers pay your invoices on time.

Setting up email alerts to remind customers when your invoices are due is a great way to ensure you’re never – or at least, rarely – paid late, which we’ve written about on this blog and even cover in our MYOB training courses. Continue reading Get Paid Faster Using Your Mobile Phone!