Home » Our Blog » Excel Essential Skills

Category: Excel Essential Skills

The Excel Essential Skills category groups together posts that cover the essential skills needed to confidently create Excel worksheets that are both professional in look and design.

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

Excel – 5 Paste tips that will save you HEAPS of time

sharyn bainesEver wondered what the most used command is in Excel?

I have. In fact a few years back I searched for the answer on Google.  I had thought that the answer would surely be ‘Undo’, especially when I think about how often I use the fabulous Ctrl + Z key combination. Amazingly I found a page (which sadly I’m unable to find now) that claimed that Undo wasn’t the most used…it was Paste, Ctrl + V. Read more