I have been asked twice in one week how to write Excel formulas to calculate GST at the rate of 15%.
You can find information on how to calculate GST 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.
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.
I’ll always remember asking one of the team (a “just-out-of-school” new recruit) what he was working on after I’d observed him sitting with a red biro and a ruler, diligently drawing red lines on 2 separate sheets of paper. It turned out he was trying to reconcile a customer’s account. Read more
PROBLEM: Wasting time removing unwanted spaces in Excel data.
SOLUTION: Get to know the Trim function and save yourself time (and headaches).