Posted on 2 Comments

The Wonders of Microsoft Excel’s 3D Formulas

Breaking News & Updates

Xero’s financial report reveals BIG loss but share price pop. - eepurl.com/isNmKQ

About 11 months ago from Steve Slisar's Twitter via Mailchimp



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.

-- Did you like what you read? Want to receive these posts via email when they are published? Subscribe below.

Subscribe

* indicates required

2 thoughts on “The Wonders of Microsoft Excel’s 3D Formulas

  1. […] you’ve set up your financial forecasting file in Excel using the correct formulas that will update as the investment progresses, you’ll be able to track all of the future costs, income and depreciation in that […]

  2. […] 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. […]

Comments are closed.