Home » Our Blog » 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

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

# Excel – Pasting, excluding hidden columns or rows

Copying a data range that contains hidden data can be challenging. You may have tried this and found that the hidden data travels with the copied range.

In this tutorial I show you how to copy and paste only the visible data – hidden cells are excluded.

# Excel – Why is my figure displayed as a date?

PROBLEM: when typing a figure into a cell in Excel the figure is displayed as a date?

SOLUTION: quickly change the format of the cell back to a format that displays numbers, not dates. Read more

# Excel – Fit your worksheet on 1 page when it prints

PROBLEM: wasting time mucking around with column widths and font sizes so that Excel worksheet data will print on one page.

SOLUTION: within seconds ensure Excel worksheets always fit to the width and height of a printed page.

# Word – 9 time-saving shortcuts for working in Tables

PROBLEM: wasting time creating tables. Especially when trying to create complex tables where columns don’t align and content needs to be reorganized.

SOLUTION: Save yourself HUGE amounts of time…learn the shortcuts! Read more

# Outlook – start Outlook in the Calendar view

PROBLEM: wasting time answering emails when you should be working on something else.

SOLUTION: have your Calendar displayed first when you open Outlook. That way you will start the day focusing on what needs to be achieved and won’t be tempted to waste time on emails. Read more

# Outlook – add voting buttons to a message

PROBLEM: wasting huge amounts of time collating masses of Yes/No, Accept/Reject type replies to a broadcast email.

SOLUTION: learn how to add voting buttons to a message and let Outlook do the counting for you.

PROBLEM: redundant email addresses popping up in your AutoComplete list causing you to have to scroll to find the correct address.