Home » Our Blog » Excel Essential Skills » Formulas

Category: Formulas

How to create basic calculations in Excel

sharyn bainesBeing 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. Read more

How to calculate GST at 15% using Excel formulas

sharyn bainesI have been asked twice in one week to please explain how to calculate GST at 15% using Excel formulas.

You can find information on how to calculate 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.

 

Read more