Tips & Tricks

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

Perhaps you have a PowerPoint presentation that you need to share with a non-PowerPoint user… or maybe you’d like to upload a presentation to YouTube, social media or a website? After a few small tweaks you can save your PowerPoint Slideshow in .mp4 format…

Read more ...

We have all been there; someone asks you to mail them a list of your availability and you’re in a rush. Well, Calendar Snapshots does it for you; just choose the level of detail and the date range and Outlook does the rest…

Read more ...

Over the years, the Excel ‘Camera’ tool has gradually disappeared from the visible navigation, yet it is an incredibly useful tool enabling you to create dynamic screenshots of your worksheet data.  Watch this video to learn how to access and use it…

Read more ...