Tips & Tricks

You may know about the wrap text tool in Excel that allows you to arrange text in a cell over several lines, but did you know that you can achieve the same result using a keyboard combination as you type the headings?... 

Read more ...

There is a brilliant view found in Word and PowerPoint that helps you when brainstorming or planning a long document or presentation, it is called Outline View.  When using this view, you type up the key headings for your document and then you can easily demote, promote and move headings around.  When you have paragraphs that belong with the heading, this view enables you to move the heading and this also moves the associated text at the same time, keeping headings with the correct paragraphs…

Read more ...

You can use the Categorize feature in Outlook to create your own customized To Do list, that can be sorted and repeated through into your appointments in your Calendar or your Tasks.  Firstly, we need to set up and define the categories we will be using…

Read more ...

When inserting a picture or photograph into a Word document, it can sometimes be frustrating when trying to move and align the picture in the best way.   

Read more ...

If you have a great video you would like to play during your presentation but only require part of it to be shown, PowerPoint has a great feature to trim the video down..

Read more ...

You can use Conditional Formatting to make data stand out in your Excel spreadsheets. Find out how cells can be formatted to change the text style, add a border or even fill the cell with colour...

Read more ...

To ensure that your presentations in PowerPoint look stylish, professional and stay interesting for your audience you can now convert your standard bullet point lists to amazing SmartArt graphics with a couple of clicks of a mouse button...

Read more ...

How often do you forget to attach a file to an email or don’t add a recipient name that you meant to in a message?  Rather than sending the message and/or attachment in a new message, you can use the Resend feature.  This option retains the original recipient’s names, the subject and the message content but allows you to add more recipients, attach files or add to the message body...

Read more ...

Speed up your formulae creation and add the calculation symbols (= / * + – ) to your Quick Access Toolbar. This will act as a memory aid if you only create formulae infrequently, as the symbols are always on display...

Read more ...

Have you ever wanted to monitor the rise and falls of your data graphically, but don’t want to include a full graph on your worksheet? In Excel 2010, 2013 & 2016 you can create tiny charts in cells using the Sparklines feature...

Read more ...