Investigating Comments in MS Word
On my courses, I teach how to create and use comments in a Word document. I also use them in many of the documents that land on my desk. Creating a...
Scheduling sending a message in Outlook
How often do you find yourself wanting to send an email but you’re not in the same time zone as the recipient and you know that it’s the wrong time for...
Hiding and Unhiding in Excel
There is feature in Excel that is very much overlooked by many. It is the humble hide and unhide feature. This can be easy to apply and then very useful to...
Duplication in PowerPoint
How many times do you create a pretty box or object in PowerPoint and need to have exactly the same again and again and again. Possibly in different sizes or angles...
Changing Numbered paragraphs in Word to letters or bullets
People number their paragraphs in a document for various reasons. In previous tips I explored numbering paragraphs, continuous numbering and starting from 1 again. Do read those in conjunction with this...
Setting what number, the paragraph numbering should start in Word
In my previous tip, I showed you how to set the numbering for paragraphs. In this tip I am going to explore how to set the numbering to either start from...
Using Numbering in Word
This topic may sound so simple but unfortunately Microsoft Word is becoming more and more automated and things “just happen” and we don’t know why. I had a class not so...
Need to change the data in a cell from lots of characters to just...
My students come to me with all sorts of questions. One that seems to come up every so often is how to easily change the length of a piece of data...
How to change case in Excel
You may well know that in Word you can change the case of your text very easily. What was originally all in lower case you can change to All upper or...
Calculating number of workdays between two dates where weekends are not Saturday and Sunday
A recent tip of mine showed how to calculate the number of working days there are between two dates. Also where there are bank holidays involved. Today I shall investigate the...