Tips & Tricks

This is a real time saver if you are using someone else's spreadsheet and you want to see the formula behind the cell content.  Instead of clicking into each cell and viewing the formula in the formula bar, you can use a shortcut key or menu command to show and hide formulas on the worksheet.

Read more ...

Have you ever sent an email and realised too late that you had made some spelling mistakes? Maybe you usually run the spelling checker but on that occasion you just forgot to click the button? Well, to avoid future embarrassing mistakes, why not set up Outlook to automatically check your emails for spelling errors before sending them...

Read more ...

When inserting additional columns in a Microsoft Word Table, you may find on occasions the end column disappears off the page. Here's a great tip for quickly resizing the table to fit all columns on the page...

Read more ...

So, you want to create a row or column of sequential dates, but you don’t want to include weekends.  Do you painstakingly go through the long list deleting the Saturday and Sunday dates?  No, let AutoFill do it for you…

Read more ...

When printing data in Excel, by default it aligns the data from the top left hand corner of the page.  If you would like to print your data in the centre of the page, here's how to set it up:

Read more ...

To add impact to your document lists, you may wish to create a custom bullet to display in your company colours, or use a different symbol or use a picture.

Read more ...

When you are presenting information on a slide, you may wish to highlight an area of importance or draw everyone’s attention to data on the slide.  This can be achieved by zooming into a specific area of the slide using PowerPoint Presenter View.

Read more ...

You have copied text to the clipboard which you need to email to a colleague. Instead of creating a new email in Outlook, and then copying and pasting the text in, try this shortcut......

Read more ...

You have hundreds if not thousands of data entries in an Excel spreadsheet column, but how can you create a separate list showing only the unique entries and not all the duplicates?

Read more ...

When you select a word, group of words or a paragraph in Word it highlights horizontally across the page. However, you may wish to select and edit text in a vertical list, here’s how to do it……

Read more ...