Excel Tip – Precedents and Dependents
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’ ce...
Word Tip – Picture Captions
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...
Word Tip – Auto Text
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 ...
PowerPoint Tip – Merge Shapes
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 t...
Excel Tip – Data Bars
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 Total...
Excel Tip – Table Slicers
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 t...
PowerPoint Tip – Saving as a Video
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 ...
Outlook Tip – Calendar Snapshots
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 a...
Excel Power Query vs Power BI (Part 1)
We often get asked about the difference between the above applications – the short answer is none or at least very little. The best way to explain it is to look at the history of the applications. ...
Excel Tip – Camera Tool
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...
Windows 10 Tip – Snipping Tool
The Windows Snipping tool lets you create quick screenshots of any data displayed on your screen. You can then save the snip, email it or simply paste it into any document. Follow this video to see ...
Word Tip – Researcher Tool
Have you ever had to create a Word document where you need to look up and reference information from the internet? The Researcher tool lets you do this without even leaving your Word document. It also...
