Tips & Tricks

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 ...

If you have a Table in Word that spans more than one page, you can automatically repeat the column headings on the second and subsequent pages without the need to copy and paste them...

Read more ...

On occasions you may wish to reuse PowerPoint slides from an existing presentation. Using the 'reuse slides' feature allows you to copy multiple slides and control whether to use the source slide formatting or the formatting in the current presentation...

Read more ...

When importing or copying data into an Excel spreadsheet, you may find on occasions that the text is displayed in the wrong case i.e. UPPERCASE.

Within Word, it is quite straight forward to change the case automatically (with the word highlighted press Shift + F3) however, in Excel there is a little more to it.

Here’s how you can write a formula to automatically change the case rather than painstakingly retyping all the data manually…

Read more ...

Quick Parts allows you to save and reuse text that you may repeatedly use in emails. You can store a standard email or even pictures, tables etc.

Read more ...

If you find yourself using the same symbol within Word regularly, instead of having to insert the symbol each time via the Symbols dialog box, try this time saving tip of assigning a shortcut key...

Read more ...

You may already be aware of the Autofill function where you can hover your mouse over the bottom right corner of a cell (your mouse changes to a thin black cross + ) and click and drag to copy data or formulas into the cells below.

Read more ...