Home » Our Blog » Popular

Category: Popular

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 – Using VLOOKUP to compare two lists

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

Excel – How do I merge cells within a range that is formatted as a Table?

PROBLEM: when I use “Format as Table” to format a range the “Merge and Center” button becomes inactive and I can no longer merge cells.  Why?
SOLUTION: the Table format will stop the merging of cells.  However there is a work-around.

The Format as Table command can be used to quickly apply a professional format to a selected range.  However, in applying the format you are also applying the functionality that Tables offer.  As a result you will no longer be able to merge cells. Read more