Microsoft Office Tips, Tricks and Shortcuts
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?
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.
February 25, 2013 • Liz Todd
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....
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...