Home » Formula

Tag: Formula

How to create basic calculations in Excel

Sharyn Baines

Being able to create basic calculations in Excel is fundamental to being able to use Excel well.

Writing Excel formulas is much the same as writing an equation. With just a little bit of instruction you will be creating basic calculations in no time! And of course, you will be able to confidently read other people’s calculations which is awesome when you want to work out what the calculation is actually doing. Continue Reading

Sharyn Baines

How to calculate GST at 15% using Excel formulas

Sharyn Baines

Post updated 18 October 2019 by Sharyn Baines

A common request I receive is to please explain how to calculate GST at 15% using Excel formulas.

You can find information on GST  (Goods and Services Tax) on the NZ Inland Revenue website. I’ve taken this a step further and put together a tutorial on how to put these calculations into Excel formulas.

Continue Reading

Excel – Using VLOOKUP to compare two lists

If you want to save yourself a huge amount of time when reconciling data, learn how to use VLOOKUP to compare two lists or columns of data.

Years ago the Training and Development manager of a large organisation invited me to spend some time in their Accounts department in order to observe how the Accounts team dealt with their day-to-day tasks. My job was to report on any process that could be improved using Microsoft® Excel. Continue Reading