Tag: Tutorial

How to calculate GST at 15% using Excel formulas

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 the rate 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

PowerPoint – add additional text, formatting and your logo to audience handouts

Audience hand-outs can easily be printed directly from PowerPoint simply by navigating to the File tab and then to Print. From the Settings options you can change from printing “Full Page Slides” to Handouts. From the Handouts gallery you can choose the layout required.

To add the date, page numbering and additional text click the Edit Header & Footer link at the very bottom of the ‘Print Settings’ panel. This option is great if you want to include small bits of text on all hand-out pages and don’t need to include a cover page, additional paragraphs of info or even your company logo. Read more