So you want to learn Excel quickly and you’re on a budget? Buy our Excel Beginners’ to Intermediate training workbooks (with exercise files) and start getting a handle on how to master the world’s number one business productivity software program.
“Google Ads” and “Facebook Boosted Posts” are really, really popular right now. BUT the costs of these are getting higher and higher as well. A lot of businesses are struggling to measure the return on investment (ROI), and many are now turning to something far more easily measurable – direct marketing.
Direct marketing use to mean sending addressed letters using a mail merge between Microsoft Word and Microsoft Excel but these days it means email marketing.
‘Social proof’ is testimonials, reviews and feedback of others, that vouches for the product or service we’re thinking of buying. Social proof backs up the fact that what we’re considering buying is what it says it is.
Come see some social proof about EzyLearn by meeting some students from the past few weeks
Continue reading Are EzyLearn students just like YOU?
— you just might have a lot in common with them.
So you’ve switched on the job alerts with SEEK and accounting jobs, part-time or contract accounting jobs are coming into your Inbox! Jobs galore! Everyone needs accounts people, right?
IF YOU’RE RECEIVING the job alerts everyday — indeed, you may even have applied for some jobs already — but you’re still not getting called up for interview, then the following questions of doubt may be brewing:
- Why haven’t they picked me?
- Have I been filtered out for some reason?
- Was my cover letter not good enough?
MAKING THE DECISION whether to take the risk and invest in anything is hard. However, when you put the information in an Excel spreadsheet, it soon becomes very clear whether it’s worth doing.
Once you decide it’s worth going ahead, you can use Microsoft Excel to create a Gantt Chart of the project to make sure it happens right as planned.
The EzyLearn COMPLETE Excel Beginners’ to Advanced Online Excel training courses include sample exercises files which will show you specifically and exactly how much you can borrow to invest in property (including a granny flat). Also included is a Gantt chart to help you with project management. Continue reading Announcement: Excel Course Spreadsheet Says Yes to Granny Flat Investment – Now Included
Learn Microsoft Office — Word + Excel + PowerPoint + DropBox + Much, Much More! = $149
MICROSOFT BUNDLED ALL THEIR Office Productivity Suite software programs decades ago for many reasons.
The MAIN reason was so that all businesses, big or small, could use these software programs to improve their productivity and make them look more professional.
We’re now bundling them together for students who want it all.
Ways to diversify your bookkeeping skills
NOT SO LONG AGO, bookkeepers and accountants only had to learn to work with one accounting program. That was back when MYOB, the market leader, had a strangle-hold on the industry, and though a few alternatives – Reckon, Quickbooks – tried to squeeze out a space for themselves, MYOB was too embedded in the accounting industry.
But the rise of cloud accounting has changed all that. Besides the reinvention of a couple of old brands (QuickBooks and Reckon – though the latter has exited the market again), it’s also birthed a new market leader in Xero, which now has more paid member accounts in Australia and New Zealand than arch rival MYOB.
A number of smaller players to have entered market, too. There’s Zoho, which has built an entire suite of productivity apps; and straightforward cloud accounting programs, such as Saasu and Freshbooks – to name only a few.
When Xero first pioneered cloud accounting, it quickly gained popularity among new and small businesses due to the ease with which you could get your accounts “online.”
There was no big, expensive outlay to buy the software – Xero offers a free trial, after all – and for the most part, setting up a Xero account, creating invoices, estimates and recording expenses was remarkably easy.
Many bookkeepers, who had been working with MYOB, quickly started offering bookkeeping services in Xero, and there are many more who work exclusively in Xero.
These bookkeepers are usually part of the Xero Partner program, but there are some that just prefer using Xero because it’s cheaper and easier for their clients to use, which makes their job a lot easier.
Most bookkeepers are diversifying, not just in the services they offer (from only providing daily reconciliations services to providing BAS, payroll and credit management services) but also the programs they work with.
Many highly skilled bookkeepers not only work in MYOB and Xero, but some also work in larger enterprise reporting systems, such as Oracle and SAP.
Doing so enables, predominantly contract bookkeepers, to work with a range of different businesses and increase their income.
Even bookkeepers who don’t work with large enterprise reporting systems, but who do work with the major accounting programs Xero, MYOB and QuickBooks, are still able to increase their earning potential.
Learn the major accounting programs for one low price!
We are constantly updating our Special Offers page to include a variety of combination deals on our online training courses to provide established bookkeepers and would-be bookkeepers with the most training material for the lowest price.
In one of our current special offers, students who enrol in our MYOB AccountRight and Xero online courses will also receive QuickBooks Online and MYOB Essentials online courses FOR FREE.
We have a host of other specials on this page as well which will suit students looking to enrol in everything from accounting software training courses, to social media marketing and business start up courses.
As with all of our online training materials, students can learn at their own pace, in a way that suits their busy schedules with 12 month’s or lifetime course access options.
Remember, becoming proficient in a number of different software packages takes you a long way towards being able to offer diverse services to your clients. Then you only have to decide which services to offer — BAS, payroll, credit management — or perhaps all three and more? One you know what you can offer your clients, you’re well on your way to operating a successful bookkeeping business.
Learn from the professionals living and working in your industry
YOU HEAR A LOT about industry association-accredited training courses and internationally accredited training couses; which are typically training that’s delivered by an industry association at a prescribed time, in person, or delivered by a third party provider.
EzyLearn chose to be an Institute of Certified Bookkeepers (ICB)-accredited training provider for six years until this February, when we pivoted to focus on practitioner-created training courses instead.
“Real world” training courses
EzyLearn’s course content has always focussed on real world scenarios, whether that’s in our case studies or in the exercises students are asked to complete. That’s because we want our students to get a thorough grasp of the kind of work they’ll be expected to do during the course of their job.
That’s especially true for students of our MYOB, Xero and QuickBooks training courses, who either are, or will work, as bookkeepers for a number of different clients from different industries. So instead of including generalised case studies and exercises in our course work, we include ones that relate to specific types of businesses and transactions you’ll encounter working as a bookkeeper.
The same is true for our Excel training courses, where you can learn how to use Excel to estimate the return on investment (ROI) on a granny flat, among other real-world exercises.
The “practitioner-created” difference
We’re able to do this because our training courses are created by bookkeeping and accounting professionals, not by software companies.
Software companies and their developers do a great job at creating accounting software to manage a business’s accounting needs. But they don’t always know which different accounting scenarios will apply and when. Bookkeepers who understand Australian tax do, however.
EzyLearn doesn’t teach Australian tax law or procedures, but because our courses are developed by accounting practitioners, they’ll show you where different tax procedures apply.
Industry association courses
Membership with an industry association or associations can be a popular choice for some registered BAS agents and they often provide training to their members as part of their continuing professional development (CPD). This training usually takes the form of in-person seminars, which may discuss legislative changes or feature a product demonstration from a software company; and webinars that discuss similar.
For in-depth software training, most associations — the ICB, for example — refer students to an accredited third-party training organisation. This third-party accredited organisation will have chosen to become accredited with the ICB and pays an annual fee to them in order to have this accreditation and be able to share this fact on their website.
A lot software training organisations are partners with a provider, like Xero or MYOB, and the train students according to how MYOB or Xero recommend them to. There’s nothing wrong with this kind of training, particularly if you’re only in need of a quick refresh or a general software skills.
Software partners vs. bookkeeping practitioners
Most software partners are companies that understand software and cloud computing first, bookkeeping and accounting second. But training companies that offer courses developed by practitioners have set the new benchmark in software training.
EzyLearn has always offered practitioner-created training courses, and now we’re going to work with more practitioners to create more courses, and more content for existing courses.
Over the six years that EzyLearn was an ICB-accredited training organisation, we found that it wasn’t our industry association accreditation that brought students to our courses, it was the content, grounded in real-world scenarios, that did.
Practitioners create high watermark
Instead of learning how to create a pivot table in Excel, or other data sources you can use to create a pivot table, containing any old data and for any old reason, our practitioner create — and endorsed — Excel training courses give you a real-world example exercise to work from, so you understand when and why you will need to use a pivot table.
That’s important because Excel, as anyone who’s used it at an advanced level will know, is a complex maze of tables and graphs and formulas. So when it comes to Excel skills, you either use them or lose them. By grounding our Excel training content in real-world examples, it makes it just that much easier to hold on to what you’ve learnt until you do get to use them.
(If you do happen to lose them, students enrolled in our lifetime access courses can always go back and refresh their skills whenever they want.) By the way, we’ve written previously about the mighty Excel pivot table.
Continuing professional development courses
If you’re a bookkeeper or BAS agent used to working with one software — MYOB, say — you can update your skills with our Xero or QuickBooks training courses, which can be counted towards your continuing professional development (CPD) hours.
Learn Microsoft Excel from scratch or brush up your Excel skills, at your own pace, with our affordable Excel online training courses — where you get THE LOT (that’s 9 courses in total) for ONE LOW PRICE — everything included! Volume corporate discounts are available and our courses count towards CPD Points.
Creating and managing databases is included as part of our Advanced Microsoft Excel training courses — and you receive access to ALL OF OUR COURSES, including ALL SKILLS LEVELS for ONE LOW PRICE. You can even start your Excel journey with our FREE Beginners’ Excel Course Workbook. Read more about our beginners’, intermediate and advanced Excel training courses on our website, or enrol to start learning by 5pm tomorrow!
Lifelong learning is the concept that learning isn’t confined to an individual’s childhood, but can be pursued throughout their life, and often in non-traditional settings. With lifelong learning, the knowledge or skills a person acquires through social interactions and other everyday experiences (soft skills) are considered just as important as those learned in formal education settings.
This approach means that learning is no longer considered to take place at two, traditional stages of a person’s life — school and the workplace — but rather is ongoing throughout the individual’s life.
How lifelong learning was born
The concept of lifelong learning isn’t new. It’s been around since the 1970s, when it was referred to as “lifelong education” by the French politician Edgar Faure in his 197s book “Learning to Be”. Lifelong learning gained more recognition during the 1990s, particularly with the publication of the Delors Report by the Delors Commission in 1996.
The Delors Commission was an administration of the European Union led by Jacques Delors through the 1980s and again through the 1990s. The Delors Report proposed an integrated vision of education based on two key concepts:
- Learning throughout life
- The four pillars of learning
The Delors Report identified three characteristics of modern life that made lifelong learning necessary, in order for individuals to remain productive and actively engaged members of society throughout their lives. Those characteristics included technological, economic and social change.
Technology made lifelong learning vital
From the mid 1990s onward, rapid technological advancements have made lifelong learning especially critical for people in the workplace. Aside from the need to keep up-to-date with changes to software (desktop software shifting to the cloud) and the introduction of new technologies (smartphones and tablets), technology has also changed the way people work.
The majority of adolescents who start university today, will be studying for a degree in the profession that will not exist in twenty years time. But in twenty years, jobs will exist that did not today, just as social media and search engine optimisation did not exist twenty year ago. And this drives the need for people to engage in lifelong learning.
Technology has also fundamentally changed our economy. More people engage in freelance or contract work than they did twenty years ago, and that’s given rise to what’s now called the “gig economy” — people engaging in short term, piecemeal or temporary work as their primary means of income.
And that’s all coincided with some big changes to our society. Paid parental leave, for example, sees dads taking time off work to become the primary carer of their children, while a new crop of mums have chosen to start home-based businesses so they can work flexible hours while they care for their children.
In each instance of change, be it technological, social and economic — though technology is the driving force of all three — people have had to learn new skills for their workplace, either formerly or informally.
The four pillars of learning
The Delors Report, which brought the concept of lifelong learning to greater prominence in the 90s, identified the four pillars of learning, which make up a central component of lifelong learning. The four pillars of learning involve:
- Learning to know — the mastery of learning tools rather than the acquisition of knowledge
- Learning to do — acquisition of occupational skills for jobs today and those in the future
- Learning to live together — resolving conflict, discovering other people and culture, fostering community, economic resilience, social inclusion (soft skills)
- Learning to be — education that contributes to an individual’s complete development (to act with autonomy, use judgment and take personal responsibility.
Implementing lifelong learning
Since the 1990s and the release of the Delors Report, universities and other formal education institutions have implemented some elements of lifelong learning, particularly the “learning to know” and “learning to live together” pillars of learning. In high school, students will study society and culture as a component of their HSC. This is designed to equip them with the tools to develop values and attitudes that promote social literacy and cohesion.
Workplaces have also become responsible to promoting lifelong learning by requiring employees to carry out continuing professional development (CPD) — although this is sometimes an industry requirement, as in the financial services and real estate sectors, for example.
Bookkeepers and BAS agents are required to maintain a certain number of CPD points each year in order to keep their BAS registration. The Institute of Certified Bookkeepers (ICB) is just one of many Recognised Professional Associations and it lists accepted training courses, including Microsoft Excel and cloud-accounting software training which are all available as LIFETIME Courses with EzyLearn! I like to think that EzyLearn can go one better than Delor and offer students the option to get LIFETIME course access to Xero rather than LIFELONG paying for Xero Courses.
This November, Xero also launched it’s own lifelong learning platform, in conjunction with Swinburne University. The Xero lifelong learning platform is currently being piloted in Australia and New Zealand, with a full global rollout expected in 2018.
Xero lifelong learning
The Xero offering will be available for secondary and tertiary students, as well as businesses. It will provide students with access to a learning management system (LMS) that will deliver training in the form of business scenarios and simulations, in addition to grading and assessment tools.
Xero’s chief partner officer Anna Curzon said in a statement that technology has “reshaped the way people work” and created a need for lifelong learning so people can “stay relevant in the workforce”.
“Handling finances, both personal and business, is a necessity for everyone, from school age students to retirees,” she said.
“Xero lifelong learning platform allows students to grow their financial literacy to help prepare them for the real world.”
Curzon also said that the gig economy is driving demand for Xero’s services, which in itself is driving demand for a lifelong learning platform centered around financial literacy.
No pricing for Xero’s lifelong learning platform has been released, though it’s understood it will be included in the subscription price of the Xero software for businesses.
And the online training to help you get there
I WAS BROWSING THROUGH my contacts on LinkedIn and found an advertisement by a company that was looking to hire people.
They were in the AI (Artificial Intelligence) space and their headquarters were in Europe.
However, the ad looked like it could be for any company including trades, professional services etc.
Here’s what the ad contained:
Executive Assistant / Office Manager
The Executive Assistant / Office Manager will be primarily responsible for helping to keep everyone (and everything) working at peak performance. We’re a growing company, and there will be new and interesting challenges every day. Ideal candidates are curious and interested in learning more about what we do, and always interested in learning new skills and taking on new challenges.
- Manage all aspects of office administration
- Coordinate team schedules and events
- Manage executive schedules
- Handle payment of invoices and associated bookkeeping
- Order supplies and equipment
- Arrange travel
- Excellent verbal and written English communication skills
- Strong organizational and time management skills
- Ability to work with minimum supervision, prioritizing work as needed
- Strong knowledge of office applications, including Word, Powerpoint, and Excel
The training you need
Apart from the soft skills like good time management, communications, speaking and writing the software skills you can learn to apply for this job are:
Microsoft Office Applications:
Office Admin and Bookkeeping:
Organisational and Time Management:
My thoughts on this ad?
Why I’m sharing this ad is that I reckon it encapsulates “the perfect” administrative or executive assistant, or office manager. What I mean is that anybody possessing all the skills and capabilities listed above would be well qualified for almost any job in this area — for pretty much any type of company.
And they wouldn’t be limited to any particular industry either. Any intelligent person who is a quick learner would be able to pick up the nuances for various different industries and apply their skills as necessary.
Online courses to help you
The other positive thing about this ad is that it reinforces the fact that so many of our EzyLearn online training courses are geared towards people who want to do office administrative-type roles or office management positions. They are also perfect for people wanting to run their own business in any industry.
At EzyLearn we offer online training courses to help you up-skill and find employment. Choose from our range of cloud-based online accounting software courses, to business start up and management courses, to marketing and sales courses, or update and further your skills in a range of Microsoft Office programs (Excel, PowerPoint, Word) or social media and WordPress web design).
Save time, save money, get better skills, re-skill now
IN A PREVIOUS POST I wrote about how most staff and students overestimate their Excel Spreadsheet skills.
When it comes to Excel skills, a needs analysis can cost money and take a huge amount of time, when in reality, staff can simply do their own needs analysis when they do their courses.
A lot of EzyLearn’s students are re-skilling or up-skilling because they are sent from rehab and retraining companies. This may be because they’ve been injured at work and need to move to a different area of the workforce. In these situations, many aspects of the person’s needs have to be assessed to make sure they can work in an office, as opposed to out in the field where they use to work.
In this situation a needs analysis and learning plan are very important; however, when it comes to ensuring all your staff are simply up to speed at an advanced or intermediate level in Microsoft Excel can be much simpler.
Enrol into all Excel Training Courses with EzyLearn for the same price (but usually much less) than going to a physical training centre. You receive ALL skill levels and students can start at the level they “think” they are at and simply do the beginner levels if they realise they need it.
After we shifted to delivering online courses, we discovered that by bundling all our Excel courses together for one low price, companies could forgo spending many hours and many hundreds of dollars in conducting needs analysis for their staff, only to find that their employees’ skills weren’t quite at the level stated.
Give staff comprehensive training
We’ve bundled all of our Excel training courses into 9 half-day short courses — each taking 4 hours to complete — so that, regardless of a student’s skill level, they can access all of the course content from beginner right through to advanced.
Companies can let their staff do their own needs analysis, while giving them comprehensive Excel training at the same time.
Many students who enrol in our Excel training courses for the intermediate and advanced modules often report that they’ve learned lots of new skills by also taking the beginner modules, while beginners usually always continue training right through to the advanced stage.
The great bonus of giving intermediate Excel users access to beginners courses is that most of them go through these and find they have a much more rounded level of skills using Excel.
Excel has real-world case studies and scenarios
Our Excel training courses use real-world examples so students can apply their new skills to tasks and projects you mightn’t ordinarily consider using Excel for — working out how much money a property investor can borrow, for example.
Even if your staff only require rudimentary Excel skills, by providing them with comprehensive Excel training for a fraction of the cost of in-person beginner training, you’re creating a workforce of highly skilled employees for your business.
When you choose the lifelong learning approach for your staff, they’ll have access to all Excel courses for life so they can access them whenever they want or need them.
Lifetime Access lets students up-skill at their own pace
When you enrol your staff in our Excel training courses, choosing the Lifetime Access option means your employees can up-skill at their own pace. This is especially useful for employees who may only require rudimentary Excel skills in their current role, but who are later promoted or give more responsibility, requiring great Excel knowledge.
Rather than enrolling them again, your staff will still have access to all the Excel course content so they can go back and refresh their skills as they need to. And that’s all for just one low price!
I WENT THROUGH SEVERAL different spreadsheets (which are incorporated into our Microsoft Excel & Property Investment online training courses) when I had to calculate borrowing capacity and expected return for an investment property in Newcastle recently. Microsoft Excel is a great tool for managing your investment property portfolio finances and to help students understand financial literacy we recently created some new training content for our Advanced Microsoft Excel training courses, which covers common calculations that investors go through when they look at potential debt or equity investments in new startup businesses.
Determine the NPV of a project
Net present value (NPV) is a core component of investment budgeting. It’s a comprehensive way to to calculate whether a proposed project (such as a home renovation) will add value to the investment or not.
An NPV formula involves many financial concepts in the one formula:
- cash flows,
- the time value of money,
- the discount rate over the duration of the project, and so on.
Any NPV greater than $0 represents a value-added project, with $0 representing your break-even point. A negative dollar figure suggests the project won’t add value or deliver any return on investment. There are two ways to calculate NPV of an investment in Excel — by separating out the component cash flows and calculating each step individually, or by creating an NPV formula in Excel to do that for you. I can tell you from the Applied Finance degree I did with Kaplan that Excel makes it a LOT easier.
Determine the IRR of your investments
The Internal Rate of Return (IRR) is a metric used to measure the profitability of a potential investment. IRR is a discount rate that makes the net present value (NPV) of all cash flows from a particular project equal to zero. IRR calculations rely on the same formula components that NPV does. In general, the higher a project’s IRR, the more desirable it is to undertake. You can also use IRR to rank multiple prospective projects you may be considering for an investment property, assuming the costs are equal among each project. The one with the highest IRR would be considered the one that should be undertaken first. If this all sounds a little complicated you may never need to worry about it but rest assured the companies in your superannuation fund who work hard on making money every year will be using these regularly.
New Excel 2016 training course content for Lifelong learning
We’ve updated our Microsoft Excel course content to the latest version of Excel, but we also include all versions of Excel software in our training courses. When you enrol in Excel 2016, you’ll also get access to the content for Excel 2013, 2010, 2007 and even 2003 if you need it. Because we create our own course content, training workbooks, exercise files and videos, we can (and do) update them regularly. We’ve also just updated our Xero training courses to the latest version of the Xero software.
When you enrol for lifetime course access, you get free access to all of these versions forever. You’ll learn how to use Excel to manage your investment property finances in our latest Goal Seek, Data Consolidation and Solver advanced Microsoft Excel training courses. Visit our website for more information or to enrol.
I HAVE JUST BEEN THROUGH a gruuelling experience with our hosting company, technical people and course creators to make sure that EzyLearn continues to be the first choice for Bookkeeping and Marketing Courses.
Our servers are now twice as fast and have more storage so existing students should experience some nice and fast access speeds — unless you’re in an NBN area that drops out all the time (sorry Telstra, I love you BUT the access speed is no different from what it was over here in the NSW Lake Macquarie area!)
In case you weren’t aware, I was recently heavily involved in a renovation of an investment property in Newcastle (which I really enjoyed and has given us a whole lot of extra content from real world experiences with local tradies like electricians, plumbers, chippies, painters and more) but am now back on the tools (the internet and software tools, that is) and keen to continue improving every aspects of our courses for existing AND new students.
We’ve coming up to the crazy, silly season once again that is Christmas, and I thought I’d push our marketing up another notch to help those who want to learn more to improve their lives and businesses in 2018. I hope I’m not too early in thinking like this but it’s a great time to think about what’s important in life and go and get it.
New people, new experience and MORE new content
I’ve spoken with some fantastic people who’ve joined us in the accounting software space and they have some tremendous experience in the ERP (Enterprise resource planning) side of accounting — that is accounting software as used by mid size companies. From this, we’re going to share some great information, tips and experiences to help those businesses who either deal with larger companies as clients, or who are at the stage of ramping up their accounting as a mid size business.
We’ve also just gone through the upgrade of training materials for Microsoft Excel 2016 and Xero Courses, including the new Xero Cashflow Course, and I’ll share some of that information with you as it gets published on our LMS.
If you are an existing Xero Course student you can access this course for free as part of our EzyLearn Updates policy.
There’s much more news to come, but for now please take advantage of and share our current “LAST DASHer SALE!” with your friends. And do subscribe to receive our updates!
IN LARGER COMPANIES a Needs Analysis can be a powerful tool for delving into a problem and coming up with a solution.
However, when it comes to Microsoft Excel Training, asking students to complete a needs analysis can be a complete waste of time.
Why? Because most students overestimate their skills — not because they’re being dishonest, but because they will have come across many terms before and, because they can use certain jargon in conversation, they tend to think they know how to do the associated skill.
Sometimes a needs analysis is also irrelevant because many people are unaware of all the wonderful things Excel and other programs can do.
When we put our training courses online, we realised that instead of wasting time doing needs analyses — which aren’t accurate most of the time, anyway — we could bundle all of our courses together and cover every skill level, for one low price.
Typical Excel Intermediate Course Scenario
As a Microsoft Excel Intermediate Trainer, one of the most awkward moments I remember when doing face-to-face training was when I started going through one of the very first exercises with a new group of students, only to realise that 40% of the people in the room had no idea what I was talking about.
It’s worse in a face-to-face group training environment because everyone else in the group will now be disadvantaged. When we used to conduct these classroom style Excel classes, we would ask people to go through and supplement their lack of knowledge by reading the Excel Beginners workbooks.
Online Excel courses are even better — you can get everyone to start from scratch and they can all be on the same page.
Bundling all pf our Excel courses together means businesses can save many hours of needs analysis and hundreds of dollars, by enrolling staff in our Excel training courses.
Besides, most students report that, even though they might do our training courses for the intermediate or advanced modules, they learned lots of skills from the beginner courses, too.
Everyone Learns Something in an Excel Beginners Course
Basic / Beginners’ Excel courses take students through the different tasks that are possible with spreadsheets, introduce commonly used terms and set the foundation for more advanced features, covered in the intermediate and advanced courses.
If you’re subscribed to this blog, then you’ll know that EzyLearn use to operate physical training centres before we moved all of our content online in 2006. In those early days, we did a lot of needs analysis for the Commonwealth Rehabilitation Service (now called Disability Employment Services).
Through this organisation we received Workcover students, who needed to brush up on their Excel skills before returning to work, and who often they had to change careers from physical work to more office type jobs.
Many students enrol in our courses only requiring a beginners’ level of training but proceed to the advanced modules by choice. This is because our online courses are built in a logical progression from basic to more advanced, building constantly on the new skills taught. Students also find that the Excel course content helps them in their everyday tasks and work, no matter what their field.
Thinking of investing in property? “Wannabe property investors” will find our Excel courses very helpful because they contain exercises to help you:
- Maintain a household budget
- Determine how much you can borrow
- Potential returns from property investment
Do you need to up-skill and complete some short courses to earn CPD points? Check out our CPD Course programs.
Receive updated course content — for life!
ONE OF THE GREAT THINGS about Excel is that it has so many applications. It can be used to create financial budgets and forecasts, monitor stock levels in a retail shop, roster staff, and also determine how much money an investor can borrow to buy a property.
A lot of the time, however, people enrol in an Excel online training course or Xero online training course because they need to refresh a specific set of skills for their job, which means they don’t have the time to focus on other areas that don’t have an immediate relevance for their work.
Upskill at your own pace
With our Lifetime Access courses for Excel and Xero and many other online cloud accounting and business options, students can continue learning in their own way and at their own pace, either as part of continuing professional development or for their own personal interest — our course content includes real-world case studies, like building a granny flat, to give context to the functions of Excel.
Keep up-to-date across all software versions
The other benefit of our Lifetime Access for Excel online training courses and Xero online training courses is that it means you can quickly brush up on where functions have been moved to when new versions of Xero and Excel are released.
We update our course content every time a new version of software is released, and with Lifetime Access, you’ll be able to access all of this new content, along with previous versions of course — so you can keep learning on the most current versions of Excel and Xero.
Don’t miss out on our terrific Spring specials!
We are constantly refreshing the content of our online training courses so that you can benefit from all the new information that is always coming in about being in business, or running your own business as a bookkeeper or looking for bookkeeping work.
Our Xero online training courses include EVERYTHING for ONE LOW PRICE. Furthermore, if you select our Lifetime Membership option, you’ll have LIFETIME access to our ongoing course updates. All EzyLearn courses are accredited by the Institute of Certified Bookkeepers (ICB) and can be counted towards Continuing Professional Development (CPD) points. Find out more about our Xero online training courses.
How does Xero stack up in the cloud accounting game?
When Xero first entered the market, it was with a bang. You see, even though Xero and MYOB share many of the same features, Xero was cheaper and easier to use than MYOB, but perhaps even more so, it was also cloud-based. Being cloud-based meant you didn’t have to buy and install pricey software that would be out-of-date within 12 months. A huge advantage.
Since then, however, a number of cloud-based accounting applications have entered the market — QuickBooks Online (now distributed by their US-based parent company Intuit), Reckon One, Saasu, Zoho, and so on.
As business owners have more choice than ever before, it’s got a lot of people wondering about whether the two market leaders (Xero and MYOB) are really all they’re cracked up to be, Xero in particular.
Missing a dropdown menu
Even though Xero was hailed as a breath of fresh air when it first entered the market, it is still a little more complicated to use when compared with other cloud accounting apps, like QuickBooks and Reckon One. For instance, the purchase orders feature is still hidden behind bills, when it could easily be access via a dropdown menu. But it’s not a major quibble.
Xero’s contact profile misses a beat
Although Xero allows you to assign customer numbers for your suppliers or customers in the contact profile, it doesn’t have the functionality to record customer numbers assigned by supplier or customer.
If you’re trying to get in touch with Telstra, for example, with whom you’ll have been assigned a customer or account number, you’ll have to dig around for the paper bill to find that customer or account number.
It’s easy to file bills, though
This feature is available in QuickBooks, and it’s also available in MYOB, but as is often the case with MYOB, it requires more steps to do what you can in Xero in just a few clicks. Rather than keep paper bills on hand, Xero allows you to attach them to you transactions, so you never have to go hunting around for a bill again (very useful given the contact profile issue mentioned above).
In MYOB, you must upload your bills to your in-tray, and then link them to your transactions. This is annoying, because it requires you to leave the transaction window and open the in-tray one.
Remember that when you select a cloud accounting package for your business, do not choose solely based on price. Make a list of the needs of your business and the functions you’ll require, and then select the accounting package that suits your needs the most. Ask your bookkeeper and other business friends for their recommendations as well.
Announcement: Microsoft Excel 2016 Beginners’ to Advanced courses now available!