Tips & Tricks

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

Word defaults to adding a line of extra paragraph spacing automatically when you press return, however if you prefer to enter your own spacing by using the return key as you go along, you can reset the default spacing for all new documents...

Read more ...

After creating an engaging presentation in PowerPoint, you may wish to print handouts of your slides for your audience to take away. Did you know you can even print handouts with space for your audience to take notes while you present? Here is how it's done...

Read more ...

When you include pictures within your presentation slides, a quick way to add emphasis is to crop the picture to a shape...

Read more ...

When bullets and/or automatic numbering have been used within a document, sometimes you will find that an individual bullet or number looks different to the rest in the list - why is that? Here we solve this annoying little problem that can ordinarily be time consuming to fix...

Read more ...