Microsoft Office Tips, Tricks and Shortcuts


Never make the same mistake again!

October 11, 2017 Liz Todd

If you take the time to analyse the typing errors that you make, you’ll likely find that you make the same errors repeatedly. Wouldn’t it be great if your software could automatically correct your common errors for you?


Make stretchable WordArt in Word 2016 for Mac

May 11, 2016 Liz Todd

I had an interesting query about WordArt in Word 2016 for Mac. Having just upgraded to this version, the user found that the WordArt text in her old document could not be changed. This was solved by converting the document to the latest format. Then we found that the WordArt text wouldn't stretch horizontally as it did in the old version. What is required is to apply a text effect: Shape Format > Text Effect > Transform > Square.  


Reuse text and graphics in Word documents and Outlook messages

February 25, 2013 Liz Todd

Do you find yourself repeatedly typing the same paragraph or inserting the same picture/logo into documents? If so, the next time you enter the text or insert the picture, save it as an AutoText entry.

Calculate the number of working days between two dates

October 12, 2012 Liz Todd

Whether it is meeting monthly, quarterly or annual targets, organising rosters, or counting down until Christmas, it is often useful to know the number of working days between two dates. The good news that you don’t need to sit with a calendar and count each day! Instead, you can use the Excel function NETWORKDAYS. NETWORKDAYS calculates the number of days excluding weekend days between a start date and end date. As an option, you can exclude any holidays in the period. The example we use in this article excludes the New Zealand public holidays in the number of working days....


Five tips for effective print documents

October 01, 2012 Liz Todd

You create print documents for a reason: to convey a message to people who have an interest in the topic of your document. There are a few things that you can do to help readers get to the point of your document. Plan the placement of information Don’t leave it to chance! Divide the page into areas for the headline, the main body text and secondary information (contact details, customer testimonials, etc). Secondary information can be grouped at the right side or bottom of the main body text. Choose the right fonts Make sure that the fonts you choose reflect...