Posted on

NoCert, saves money

Yes, its true get a NoCERT discount on MYOB, Xero, Microsoft Office (Word and Excel) Courses - EzyLearn

Business owners can now get a discount on our MYOB & Xero and Microsoft Office COMPLETE courses if they don’t need a Certificate of Completion.

I recently wrote about the value of Certificates and who really needs one and we’ve discovered that most business owners prefer to focus on getting the knowledge to use their software better AND saving money – that’s why we introduced NoCert discounts.

Continue reading NoCert, saves money
Posted on

MYOB Touting Business (Essentials) Pro and Lite through Westpac – 12 months for FREE

MYOB Business Essentials (Lite and Pro) Training Course & Bookkeeping Certificate - 12 months FREE software with Westpac - EzyLearn Bookkeeping Academy

It’s Christmas season once more and you can even get a great deal on your MYOB Business Lite or Pro accounting software if you have an eligible Westpace account.

There are some exceptions, however, and these exceptions show where all the accounting software vendors are making their money: Payroll, Inventory and deeper functionality through integrations.

This is not the first time MYOB have partnered with a major corporation to get its software promotions sold. The last one I wrote about was when Telstra was pimping it last year. This offer is different..

Continue reading MYOB Touting Business (Essentials) Pro and Lite through Westpac – 12 months for FREE
Posted on

6 Months Access to MYOB Business (Essentials) for Training Course Students

MYOB Training Course & Certificate - Accounting & Payroll Advanced Certificate Course - EzyLearn with MYOB Education Partner

One of the most common questions we get asked by students when they enrol into an online course relates to access to the software.

Years ago you could buy the MYOB AccountRight software from Officeworks for $10 and use it forever but online software like Xero, QuickBooks Online and MYOB Business Essentials are all subscription based and offer a 30 day free trial.

Although 30 days doesn’t seem like a long time if you are enrolled into a MYOB or Xero course that provides 12 months course access, there are ways you can still make VERY good use of these trial periods.

Continue reading 6 Months Access to MYOB Business (Essentials) for Training Course Students
Posted on

Cert IV in Bookkeeping Changed to FNS40222 – Study Through EzyLearn’s RTO Partnership

There are many ways to get started with a career in finance and bookkeeping.  For those looking for a nationally recognised qualification, something like a Cert IV is a great way to learn the skills you need to find work or continue in your studies.

The Certificate IV in Accounting and Bookkeeping is a national accreditation provided by registered training organisations (RTOs).  It can start you on your way to becoming a registered BAS agent, or prepare you for roles like payroll officer and bookkeeper.  But the qualification has recently been updated!

Here’s what you need to know about the changes:

Continue reading Cert IV in Bookkeeping Changed to FNS40222 – Study Through EzyLearn’s RTO Partnership
Posted on

NEW “Bookkeeping Basics” Training Course Covers Beginner Level Xero, MYOB & QuickBooks Online

bookkeeping-basics-training-course-for-Xero, MYOB and QuickBooks online cover-300x201 EzyLearn Bookkeeping Career Academy

Bookkeeping is an essential part of business, not just to keep track of financial activities for the business’ sake, but also to meet obligations from the ATO.  It’s nothing ground-breaking to highlight the importance of bookkeeping, but lots of businesses might start operating without considering the necessity of bookkeeping. 

If you’re a business owner who doesn’t have a background in accounting or bookkeeping, then you’ll want to learn at least the basics quickly – even if you intend to hire accounts staff, it’s great to understand the bookkeeping tasks that need to be completed.

EzyLearn has you covered with out new Bookkeeping Basics Training Course.  Let’s break down how you’ll learn the foundational aspects of bookkeeping with this course:

Continue reading NEW “Bookkeeping Basics” Training Course Covers Beginner Level Xero, MYOB & QuickBooks Online
Posted on

ALERT: MYOB Essentials Shock New Credit Card Requirement to Trial is Unexpected and Unwanted

Who doesn’t love a free trial?  The great thing about some of the popular accounting software like Xero, QuickBooks, and MYOB is that they provide 30-day free trials where you can use the software at no cost.

It’s great for businesses and contractors wanting to find the right accounting software for them, or for students looking to get experience as they study. 

MYOB didn’t used to require any credit card details when signing up for the trial subscription…but now they do.  Whilst Xero and QuickBooks continue to offer trials with no credit card required, MYOB has diverted from the pack to deliver this unexpected and unwanted change.

Continue reading ALERT: MYOB Essentials Shock New Credit Card Requirement to Trial is Unexpected and Unwanted
Posted on

This is Why Businesses Love Cloud Accounting and not MYOB AccountRight so much

Network setup for multiple users on your network using MYOB AccountRight Multi-user - MasterClass in MYOB AccountRightand MYOB Essentials - EzyLearn

If you have worked in an office you know how frustrating IT issues are. If you are now working from home you know how frustrating IT support issues are. If you have ever experienced an IT support issue installing software (like MYOB AccountRight) you know how frustrating IT issues are.

We stumbled upon the technical support help page for MYOB AccountRight and all remembered why we LOVE online accounting programs like Xero, QuickBooks Online and MYOB Essentials!

Attn: We’ve just BUNDLED all the MYOB AccountRight BEGINNERS Certificate Courses together for those students looking for junior accounts and general office support and admin jobs.

Continue reading This is Why Businesses Love Cloud Accounting and not MYOB AccountRight so much
Posted on 1 Comment

Is a Certified Advisor or Certified Consultant Better Than a BAS Agent?

Finding the best bookkeeper for your business

find a good bookkeeper xero myob quickbooks learn online training course videos
A bookkeeper who’s certified in a particular accounting software may not mean that much for your business. Better to have someone who is simply a good bookkeeper. Period.

IT’S NOT ALWAYS EASY to find a bookkeeper who suits your business’s needs. This can be further complicated by the fact that a lot of business owners don’t know too much about bookkeeping.

Now that virtual bookkeepers have become more common, lots of business owners have started selecting bookkeepers based on their affiliation with an accounting application. Such bookkeepers are often called a Certified Advisor (Xero), Pro Advisor (QuickBooks) or Certified Consultant (MYOB). But are they really the best bookkeeper for your business?

What are Certified Advisors, Consultants and Pro Advisors?

In a nutshell, a certified advisor, consultant or pro advisor is just an individual who has been endorsed by a software company because they’ve demonstrated a high level of knowledge and skill with a particular accounting product.

Hiring a bookkeeper who’s been endorsed by MYOB, say, means you shouldn’t have to worry about whether your bookkeeper has set up your accounting package correctly, or whether they’re using the correct codes. What it doesn’t guarantee, however, is that each consultant or advisor is a highly experienced BAS agent, as the certification relates to their software knowledge only.

Certified Advisors and Pro Advisors go through their certificate, which is often free, because it elevates their own profile. It can also demonstrate that they are committed to that software program more than others. The Xero Certification training (at the time of writing) has a strong focus on understanding how to use the Xero Agent portal to bring clients onto the platform – and not so much about learning bookkeeping or to become a BAS Agent.

If you don’t have an accountant or BAS Agent then you should make that your starting point as everyone needs someone who can perform tasks that relate to tax and GST who acts on your behalf. If you have that setup already you can hire someone who has good bookkeeping skills using MYOB or Xero but is cheaper because they are not registered or licensed. This junior bookkeeper can perform your office admin, accounts and even customer service while your Registered BAS Agent or Tax Accountant can sign off on your financial figures.

Find a highly qualified BAS or tax agent instead

Sure, a bookkeeper who’s experienced in your accounting package is important. It’ll help keep your bookkeeping bill down because they’re able to perform certain functions quickly, while your accountant shouldn’t need to fix any errors, either. But that’s only providing that they’re as knowledgeable in Australian tax as they are MYOB or Xero or QuickBooks.

Unfortunately, however, the two aren’t mutually exclusive. So instead of focussing on a bookkeeper’s software experience, it’s more beneficial to ensure they’re qualified BAS and tax agents, with either a Certificate IV in Bookkeeping or higher.

If you don’t get a bad reference from their current and former clients, then there’s a pretty good chance they’re proficient in the major accounting packages, and if they’re not, most bookkeepers will tell you upfront.

Get the accounting package that’s best for your business, not your bookkeeper

There are lots of reasons a bookkeeper would choose to become certified with a software company, the biggest being that they get their accounting software for free and receive a commission for each new client they sign up to use the accounting package they’ve been certified with.

However, when you hire an independent bookkeeper who’s well-versed in a few different accounting packages, you’re more likely to get better advice about which accounting package is best suited to you and your business’s needs, rather than the accounting package that will generate income for your bookkeeper.

***

Are you looking to brush up your skills in cloud-accounting packages like XERO, MYOB or Quickbooks? We provide a range of online training courses in all of these packages at ONE LOW COST for ALL SKILLS LEVELS. Find out more.


find a local bookkeeper

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


Posted on 2 Comments

Using Excel for Client Databases

Excel does great CRM

learn excel cheap online learning training course videos
Managing large amounts of client and business data is not only possible, but also something you can learn fast and with ease with the help of our comprehensive range of online Excel training courses – covering all skills levels.

MICROSOFT EXCEL IS THE most widely-used spreadsheet application in modern computing. It’s ubiquity means most people use Excel on a regular basis, despite never having had any formal training in its many, many, MANY functions.

While updating the content for our Excel training courses recently, we were reminded of just how powerful Excel remains, and in particular, how useful it is for small businesses.

With its 2013 release, Excel got a serious update, which made it the perfect application to create and manage client and customer databases. Although there are many CRMs available on a subscription that provide the same functions of a database created in Excel, just in a more visually appealing format, they often lack reporting and analysis functions, requiring you to export your data in a Excel sheet anyway.

Flat file databases

Excel’s original ‘flat file’ database still remains the easiest and most basic database to set up and manage, and depending on your business and how you’ll use your database, a flat file database may be all you’ll ever need. If set up correctly, a flat file database will allow you to easily import your customer data into Word, your accounting software, an email marketing service, and so forth.

Relational databases

A relational database is a database that’s structured to recognise relations among the information stored in them. Microsoft offers a relational database program, called Access, which is available with Microsoft Office Professional or higher, or can be purchased separately.

Alternatively, you can create your own relational database in Microsoft Excel, providing you have the 2013 version or newer. When Excel got its update in 2013, it became easier to link charts and cells and to perform searches — all essential features if you’re working with large amounts of business data.

Correct Excel set up is crucial

Once Excel has been set up, it’s as easy as it is powerful to use. Of course, the key is to set it up correctly, so you can avoid errors or having to re-enter large amounts of data to make the format suit another third party software application.

***

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!


learn to use excel online training course videos cheap best

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


 

Posted on

A Close-Up Look at a Listed Company and How it’s Performing

We show you what financial data really reveals

how to read financial reports
There’s more to profit and loss than meets the eye: Sometimes a company’s losses outweigh its revenue, but it doesn’t mean that company is in a bad position.

AS A BUSINESS OWNER you’ll need to run regular financial reports (never more so than at the end of financial year) to ensure your business is in good shape. Understanding what each element of a financial report means is critical to your business’s financial health.

You’ll learn to run and interpret financial reports in our Xero, MYOB and Quickbooks training courses, but we’re just going to look at a couple of areas of most importance.

Close up: BuyMyPlace’s financial results

BuyMyPlace is an ASX-listed service that allows property owners to sell their properties without a real estate agent. Because it’s a publicly-listed company, they have to make all of their financials public too.

As such, we got hold of their most recent financial results for the first half of financial year 16/17.

It’s not the most detailed financial report, probably because the company itself is still in its early stages — there’s actually a good argument against early stage ventures listing on the stock exchange, but that’s fodder for another post.

Revenue vs. losses for the period

The good news for BuyMyPlace is that its revenue increased 129 percent on the prior comparative period (PCP) to $1 million for H1 FY16/17, up from $133,518 in H1 FY15/16.

That’s an impressive leap in revenues in just 12 months, however, the BuyMyPlace financial results also reveal that the business made an even greater loss of $1.7 million, an increase of 1205 percent on the PCP.

A closer look at the report shows that, while the losses increased more than a thousand percent, it was due to an increased investment in marketing and advertising — principally on TV spots which totalled $517,723 compared with $98,578 the year prior.

This resulted in an 80 percent increase in the number of listings on the site (that is, the number of people using BuyMyPlace to sell their home), while order value increased 27 percent (people who were choosing more expensive packages).

BuyMyPlace is in good health

Although this business recorded losses that outweighed its revenue, BuyMyPlace is still in good financial health.

The report also shows that it has over $4 million in cash and cash equivalents, and only a little over $600,000 in liabilities. Although the liabilities have increased, it’s not due to taking on any additional debt — indeed, BuyMyPlace has paid down all of its loans — but was instead due to a 786 percent increase in staff salaries and, as a consequence, an increase in staff provisions and benefits — i.e., sick and annual leave.

Strategy for future growth

Not many homeowners actually want to sell their properties themselves — one estimate puts it at around 7 percent of the total number of homeowners. However, most people do want greater clarity around how the process works (including fees and commissions) — even if they still want assistance selling their homes.

Perhaps realising this, or perhaps in response to increased competition in the fixed-fee real estate services (see: Purplebricks, Settl, etc), BuyMyPlace also launched its own full service package, giving homeowners access to a real estate agent to sell their home for a fixed fee.

This will enable BuyMyPlace to capture a greater volume of homeowners, who are looking for a low cost alternative to sell their homes, but who don’t want to do it entirely themselves.

The other strategy for growth: increasing listing depth revenues.

At some point, BuyMyPlace will stop growing its market share. Or, in other words, the market of people looking for a low-cost option to sell their home will be tapped out.

But as a business, and as a publicly listed one, BuyMyPlace will need to keep growing its revenue, not merely keep it steady. It’ll need to do as other real estate services, such as REA Group and Domain have done, and increase listing revenue depths, by selling more expensive packages to customers.  

BuyMyPlace will need to find additional value it can sell to customers, without necessarily increasing its own expenses to do so — or putting up its prices, which a business can usually only do once it’s cornered about 65 percent of the market, and BuyMyPlace is a long way off that yet.

***

That’s a lesson for every business owner out there. And it’s something we cover in our online Business StartUp Course.

You’ll learn how to run and understand the financial reports for your business in our Xero and MYOB training courses. You can also learn about strategies for business growth in our Business StartUp Course. Or for more information, visit our website.


learn to use excel online training course videos cheap best

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


 

Posted on

EOFY: Remember to Deduct Your Prepaid Expenses

The Cut-Off for Claiming Deductions is Looming

reduce-your-taxable-income-with-expenses-Xero-and-MYOB
Dive deep into your claimable expenses and don’t forget all those smaller prepaid expenses like magazine subscriptions or domain name registrations – you can only claim all of these during the period in which they occurred.

WE’RE IN THE LAST QUARTER of the 2016/17 financial year, so now is the time to dive in deep and check you’ve included every single business expense — prepaid or otherwise — to ensure all your expenses are in order.

We’ve previously posted about writing off stock and inventory and the reports you’ll need to file your activity statements and tax returns: all of these you’ll learn how to run in our MYOB BAS Reporting and GST online training course or our Xero GST, Reporting and BAS training course.

Expenses reduce your taxable income

We all know this, but remember, they can only be claimed for the period in which they occurred. If you forget to claim a major business expense in the financial year that it occurred, you can’t make it up by claiming it the next year.

It’s really important you thoroughly check your credit cards and business accounts to make sure you’ve accounted for each expense. The final quarter of the financial year is also a good time to make any purchases for your business, because you can claim them straight away.  

Prepaid expenses are often forgotten

what are some claimable expensesMagazine or journal subscriptions, domain name registrations, business name registrations, car registrations, website fees, insurances — collectively they add up, but they’re also the easiest to forget.

These deductions are often prepaid and may not come up on your radar and may certainly not show up on your final quarter bank statements.

Make a list and check it twice

Over the next month or so, make a list of all of your expenses as you think of them. This makes it easy to spot them when you’re going through your bank and credit card statements and checking them against the expenses in your accounting software.

***

Learn how to run the reports you’ll need for EOFY with our MYOB BAS Reporting and GST online training course or our Xero GST, Reporting and BAS training course.


learn PowerPoint online training course

Want to make your business presentations and publications more eye catching? 

Gone are the days of excruciatingly dull PowerPoint slide presentations. Nowadays PowerPoint is the hidden gem used to generate animations, videos, movies, advertising and graphics. It’s a great ally to the marketer or social media person in your organisation.

This creative program can also be used to conjure up the most beautiful and modern pictorial slides to enhance any presentation or inductionFind out more about our 2016 version PowerPoint courses


 

Posted on 2 Comments

EOFY: Get Your Business Expenses In Order

bookkeepers fixed price quotes

We Show You 2 Steps You Can Take — Right Away!

WE’VE ENTERED QUARTER 4 for the 2016/17 financial year, so we’ve been writing about the things your business should be doing this quarter in preparation for the end of the financial year. In our last post we wrote about writing off stock and inventory. Now we’re looking at business expenses.

Our MYOB BAS Reporting and GST online training course or our Xero GST, Reporting and BAS training course will show take you through the necessary steps in your accounting software. 

Here’s what you can do now to make sure you’re prepared come tax time? Continue reading EOFY: Get Your Business Expenses In Order

Posted on 1 Comment

End of Financial Year: Writing Off Stock

We show you how to write off stock and inventory before the EOFY

how to write off stock before eofy in xero myob
Do you know how to make inventory adjustments? Our Xero and MYOB BAS and GST Reporting courses can show you how.

IT’S A GOOD TIME TO START  looking at any slow-moving or obsolete stock that your business (or your client’s business) may be holding, as we’ve reached the end of Quarter 3 and have now started Quarter 4 for the 2016/17 financial year — which means the end of the financial year is fast approaching.

Writing off stock in MYOB or Xero is known as making an inventory adjustment, and our MYOB BAS Reporting and GST or Xero GST, Reporting and BAS training courses take you through the steps to do this. But first, you need to identify which items aren’t selling. We’ve created this case study to help you understand how.

Understanding your inventory’s performance

Every business needs to understand how their inventory is performing, and how it impacts their business. If the business owner is too busy to stay on top of this, then they should employ a bookkeeper to help.

A good example of why understanding inventory is important to a business is to look at an air conditioning company. This business makes money two ways:

  1. Selling air conditioning units
  2. Installing / maintaining air conditioning units

The margin on the sale of an air conditioning unit is not much, a few percent on top of the wholesale price. Where the business makes its money is in the installation or maintenance of the units it sells.

The business purchases three dozen units, of varying brands, models, price points, etcetera. It now needs to know which units are most popular with customers and why; which units aren’t popular with customers and why; whether it’s profitable for the business to continue to stock the unpopular units; or, conversely, whether it’s profitable for the business to continue stocking the popular units.

Inventory reporting

The business’s bookkeeper regularly runs a number of reports in their accounting software, including profit and loss reports and stock-on-hand reports. These reports are used to identify which units sell quickly, as well as the units that take longer to sell, and the profit margins on each.

The units that sell quickly don’t require a technician to install them. Although they’re responsible for the majority of sales, they don’t generate more revenue for the business. The units that sell slowly, do generate more revenue as they require installation and maintenance, however too many units were ordered and they’ve now been discontinued by the manufacturer. Some units have hardly sold, and, although not discontinued, have been superseded by newer models.

Stock write offs and future orders

Because the bookkeeper regularly runs these reports, s/he has been able to export them into Excel for further analysis. By the end of Q3, the bookkeeper can make suggestions to the business owner about the future of the business.

In particular, the bookkeeper suggests that the units that have been superseded are marked down to clear as much stock as possible, and cease any new orders. Likewise, the discontinued models will be marked down.

Orders for the units that replaced the discontinued models will halve the order volume. Likewise, order volumes for the top selling units will reduced. The profit margin on these units is very low and they result in no additional revenue from installation or maintenance. The profit that would be earned on the additional units is negligible, however by reducing the unit volumes, the business improves its cash flow.

Act NOW for EOFY

If your business sells stock or a combination of stock and services, like the air conditioning business does above, start looking at your inventory now. Markdown any slow-moving stock at the end of Q3, to give your business time to move the remainder of it. If it doesn’t sell, write it off at EOFY.

***

Our MYOB and Xero training courses have recently been updated to include a workbook on how to write off inventory. Learn more about our MYOB BAS Reporting and GST or Xero GST, Reporting and BAS training courses at our website.


find a local bookkeeper

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


 

Posted on 1 Comment

Calculating PAYG Obligations Without a Payroll System

Third Quarter is Looming; Are You Up to Date with Payroll?

ad hoc payroll payments ExcelMost businesses using an accounting program like MYOB or Xero will use the included payroll package to manage their employees’ payroll. For businesses with only a few employees, however, the additional payroll function is an unnecessary expense.

In our recently updated Advanced Microsoft Excel training courses, we have included a micro course on ‘Ad Hoc Payroll’, featuring a detailed spreadsheet for calculating PAYG and superannuation obligations. In this instance, our micro course is a detailed spreadsheet based on a case study, so it’s relevant and applicable to real life.

PAYG and the businesses it applies to

Every Australian business with employees who are each paid more than the tax-free threshold has a legal obligation to withhold tax on their employees’ behalf. This is known as the PAYG System (or Pay As You Go), where amounts of tax are withheld from each employee’s wage payments.

Businesses that withhold up to $25,000 each year only need to make payments to the ATO each quarter; businesses withholding amounts greater than $25,001 may have to make payments to the ATO each month or as regularly as each week.

At the time of writing, the tax-free threshold is currently $18,200, which is equivalent to:

  • $350 a week
  • $700 a fortnight
  • $1,517 a month

Superannuation contributions

Again, any business that pays its employees more than $450 each month must also make regular superannuation contributions on their employees’ behalf. We’ve written in the past about the government’s clearing house called SuperStream, which allows you to easily make super contributions — for free.

But first, you need to work out how much super you need to contribute for your employees. The superannuation guarantee is currently 9.5 percent of your employees’ gross wages, which is payable on top of their wages — not deducted out of.

Using tax tables to calculate wages

Each year, the ATO produces a range of tax tables to help you work out how much to withhold from payments you make to your employees. In our Ad Hoc Payroll Micro Course, we’ve already added the most current tax tables to the accompanying payroll spreadsheet, as well as the superannuation guarantee tables.

***

We feature a number of real-life case studies, which we have turned into micro courses. You can use the Ad Hoc Payroll Micro Course to determine the rate of PAYG tax to withhold and the required super contribution amounts in Excel, rather than paying to access the payroll functions of MYOB or Xero. Our Intermediate Microsoft Excel training courses will also teach you how to create a payroll spreadsheet from scratch to suit your own business. Visit our website for more information on all of our Excel training courses.

***

online bookkeeping courses to earn cpd points

 

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

 

 

 

 

 

Posted on 2 Comments

The Wonders of Microsoft Excel’s 3D Formulas

Excel’s 3D Formulas Work Across Worksheets

Excel formulas online training courseWe’ve recently updated our Microsoft Excel Training Course content, because it remains one of the most indispensable tools for small businesses — and we’ve included a new exercise workbook which takes you through all the steps involved in developing a financial forecast for an investment.

We used a granny flat project as the case study in our financial forecasting workbook, but the beauty of Excel is that, once you get the formulas right, they can be replicated for any kind of investment, not just one for building a granny flat.

The wonderful 3D formula

3D formulas are one of the other many wonders of Excel. A 3D formula is basically a reference to the same cell or a range of cells within multiple Excel sheets. They’re a convenient way to reference several worksheets that follow the same pattern, with cells that contain the same type of data.

All functions work with 3D formulas

3D formulas can be used with all Excel functions — SUM, AVERAGE, PRODUCT, etc — which means that, using a 3D formula, you can easily create a financial forecasting sheet for any stage of an investment, and easily reference that data in another financial forecasting sheet. This is invaluable because there are very few projects or investments that can be contained in just one Excel worksheet.

A project like the granny flat case study in our online Excel Training Course, contains many moving parts — there’s the initial construction, then there’s the ongoing maintenance, and the rental income to manage. It would be impractical to keep all of this information contained within the one Excel worksheet.

3D formulas can be modified with time

The best part about using 3D formulas is that you only need to specify the start and end sheets (which for ease-of-use, you could just label ‘start’ and ‘end’) and the formula will reference all the worksheets between the start and end sheets, including those two sheets.

This means that, as your investment or project grows, once you’ve got the 3D formulas set up correctly, you can just add and subtract worksheets as necessary, and the calculations will update automatically.

***

Once you understand how to create and work with 3D formulas, you can use them for any project or investment that you create a financial forecast for — be it for a granny flat project, business investment or anything else that requires you to make a financial decision.

Visit our website for more information on our Microsoft Excel Training Course, which covers 3D formulas.

***

online bookkeeping courses to earn cpd points

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