Tips & Tricks

The Fill Handle tool provides you with a quick way to enter a series of data into cells, such as months of the year and days of the week. But, did you know that you can create your own custom lists to use with the Fill Handle?

Read more ...

Have you created or received a meeting invite with no details about the meeting agenda or what will be discussed at the meeting?  This can lead to being under prepared and a chance of losing valuable agenda time with key people.

Read more to find out how to add additional information to a meeting invite (this will also work for adding more information to appointment invites). 

Read more ...

Have you wondered how to remove or change the separator line above a Footnote?  You may have existing lines or other formats within the document footer that clutter the end of the page area, so by removing the Footnote separator line will make it look less busy.  You can remove the Footnote separator line or change the line type and the colour.

Read more ...

Have you ever clicked SEND on an email and instantly regretted it? Well worry no more, as it might be possible for you to recall your message back, as long as the recipient(s) who are using Outlook have not read the message or moved it out of their Inbox. Here's what to do...

Read more ...

Have you ever faced that situation where you just can’t seem to get your formatting to match? Would it help to be able to reset all of your formatting to the default so that you can get the whole section or document looking the same? Here is a fantastic shortcut that quickly resets the formatting for you...

Read more ...

Do you find yourself frustrated by having to repeatedly click between two or more sheets in the same workbook?  Would you like to be able to view them all at the same time without copying and pasting into a new spreadsheet? Well here’s how you can do that quickly and easily…

Read more ...

Outlook is a fairly ‘user-friendly’ piece of software in that most tasks are pretty quick and automated.  However, a nice new feature that was introduced in Outlook 2010 allows us to apply multiple actions at the same time with our email messages making it even more effective.  It’s called Quick Steps.  Let’s take a look…

Read more ...

Have you ever wondered why when typing in a number into an Excel cell it sometimes displays the number as a date? Well usually this is because a date format has been applied to the cell(s) at some point previously. Here's how to quickly fix the problem...

Read more ...

You will know how frustrating it is when you realise that you have typed text in the incorrect case in your Word document (lowercase, uppercase etc) Here's a great tip to automatically change case instead of having to delete and retype the text...

Read more ...

When printing a spreadsheet, Excel will not by default print the gridlines that you see on the Excel screen. Rather than having to apply numerous borders to the sheet, try this much simpler way of viewing and printing gridlines...

Read more ...