Tips & Tricks

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

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