Tips & Tricks

Using the Windows ‘Clipboard Task Pane’, you can copy up to 24 items from all your standard Office applications and then paste them in any sequence you wish into any of those applications…

Read more ...

PowerPoint provides options to save either entire slides or individual objects within a slide as separate ‘graphic’ files. Once saved from PowerPoint these can then be re-used in other applications…

Read more ...

When applying ‘small caps’ to text, your lower-case letters appear as small capitals. This format is ideal for signage and emphasis, when normal capitals would appear jarring…

Read more ...

Electronic business cards are similar to paper business cards. In Outlook you can create ‘vCards’ from your Contacts and then send them as an email attachment to others. A simple and convenient way of sharing information…

Read more ...

When working in complex Excel workbooks you often have to trace formulas in order to understand or even correct the data. Follow this video to learn how to trace ‘precedent’ and ‘dependent’ cells using some useful shortcut keys and the auditing tools…

Read more ...

It’s surprisingly simple to use the Word captioning tool in order to add number and caption graphic objects in your documents. You can then generate an automatic ‘Table of Figures’ (similar to a ‘Table of Contents’) which will hyperlink to each object…

Read more ...

AutoText is one of Microsoft Word’s many ‘Quick Parts’ features. By using AutoText you can store your own text and graphics against shortcuts and then quickly or even automatically, insert them into your documents...

Read more ...

When working with shapes in PowerPoint there may be occasions when you just can’t find the shape you need. If this is the case; you can merge shapes to create ‘custom’ shapes. You can even use the same technique to fill text with pictures…

Read more ...

Excel’s ‘Data Bars’ are probably the most simple yet effective form of conditional formatting. In this video, we explore some of the hidden settings and create different examples such as a Totalizer…

Read more ...

Slicers are visible buttons that you can use to filter data in Tables. They can be printed and formatted and indicate the current filtering state of your data, which has a large advantage over using the filter tool next to the column heading…

Read more ...