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
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.
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
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.
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
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
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.
SOLUTION: Remove the unwanted email addresses from your Outlook AutoComplete list.
PROBLEM: wasting time trying to cover up graphics that are pulled through from the Design template and displayed on individual slides.
SOLUTION: learn how to hide background graphics in PowerPoint.