Tips & Tricks

When you are out of the office, it is easy to forget to turn on your Outlook Automatic Replies so that everyone knows you will not be able to reply immediately.  But in addition to switching this feature on, did you know that you can also set up a rule to send a copy of any incoming messages to a colleague whilst you are away...

Read more ...

You may often need to calculate future dates in Excel based on dates that you already have.  For example, you may need to know what an invoice due date will be in 30 days but not including weekends.  Find out how, by using the WORKDAY.INTL function...

Read more ...

When you are creating a flow diagram or an organisational chart in PowerPoint you might use Copy & Paste to create multiple shapes of the same size, but you could use a PowerPoint feature called Duplicate.  Duplicate will not only copy the shape size and format, but it also copies the alignment and spacing between the first and second shape that you draw.  This feature will give you consistent shapes that are spaced regularly quickly and easily…

Read more ...

These days we all receive so many emails every day it can be difficult to sort out the ones that you need to action from the ones that are just for your information!  Try Conditional Formatting to make certain emails stand out in your Inbox.  You could see the messages from your Manager or important contacts instantly, because they appear in a different colour or font...

Read more ...

ONE simple way to start managing work-related stress TODAY

 Work-related stress affects 1 in 66 workers in Great Britain and in 2015/16 accounted for 45% of all working days lost due to ill health – how are you managing it in your workplace?

Read more ...

Do you know how to start a search for content in Outlook using the keyboard method?  This is a quick keyboard method to access the Search box...

Read more ...

When working with large documents in Word, use a navigation tool that will help jump through your contents... 

Read more ...

The words “health and wellbeing” are batted around more and more frequently today but what does it really mean and how do we attain a higher sense of ‘wellbeing’? ‘Wellbeing’ is defined as the positive state of being comfortable, healthy and/or happy which can relate to an individual or a group’s condition.

Read more ...

Did you know that instead of using the Insert Chart ribbon, there are two keyboard shortcuts for fast chart creation?  You can use F11 to create a full page sized chart or ALT F1 to create a chart within your worksheet...

Read more ...

Did you know that there is a quick keyboard method to enter hyperlinks into any of the Microsoft Office programs, such as Outlook, Word, Excel or PowerPoint?  For this example, we will use Microsoft Word but this method works in any of the Office applications...

Read more ...