Using the Hyperlink Function in Excel

Hyperlinks can be used to link to other sheets, webpages or other files such as PDF’s from your Excel spreadsheet. If you are creating hyperlinks for many records though this will take a long time to set them up.

Excel provides a HYPERLINK function for creating hyperlinks in our spreadsheets. The real power behind this function is that it can be used to create dynamic hyperlinks.

We can create conditional hyperlinks by nesting them within an IF function, or create hyperlinks that can find the address to link to themselves by embedding Lookup or Text functions within them. This helps us to create automated and error resistant spreadsheets.

Continue reading

Using Change Highlighting in Project 2010

When a change is made to a tasks schedule in Microsoft Project 2010, such as to it’s duration or start date, all the cells in the table that are affected by that change are highlighted with a blue background.

This highlighting of the changed cells brings your attention to what task dates and durations were affected by that scheduling change.

This is a really useful tool, but what if it’s not working? Or maybe you would prefer a different colour to the standard pale blue background?

Continue reading

Insert a Non-Breaking space into a Word Document

When entering text into a document, MS Word wraps your text onto different lines for you. This is expected and very useful but can cause problems when you do not want a word to be broken over different lines in a document.

Examples of this may be when entering text such as 20 kg, or a customer reference code like AD TYH 3506.

To prevent a word from being broken across different lines you need to insert a non-breaking space instead of a traditional space.

Continue reading

Using the Custom Dictionary in Word

When you spell check your Word documents, there are bound to be some words that you have used which Word incorrectly identifies as a spelling mistake.

Instead of just telling Word to ignore these words, you can go one step further and add them to your custom dictionary.

The custom dictionary is a built in dictionary for you to store words that you use often, and are being incorrectly identified as spelling mistakes. Common examples include the names of people, companies and locations.

Continue reading

Learning Excel – 5 Awesome Date Functions in Excel

Do you want to advance your skills by learning Excel? Performing date calculations can sometimes be troublesome. Trying to calculate the number of working days between two dates, or automatically finding the date in two months’ time is not as straight forward as formulas with general numbering can be.

Fortunately Excel has a full repertoire of fantastic date functions. Here are five of the best.

Continue reading

Top 5 Essential Microsoft Powerpoint Tips and Tricks

Microsoft PowerPoint has revolutionized the delivery of presentations so much so, that it even has its own epidemic – ‘death by PowerPoint’.  This is not so much a result of using it to support presentation but relates to how people use it.  There can be no argument that if used correctly, PowerPoint can turn the most amateur of presentations into ones that are sleek, modern, and digitally useful.

Although PowerPoint training is recommended, here are some essential tips and tricks for anyone using PowerPoint 2010.

Continue reading

Basic Excel – 7 Buttons You Must Add to your Quick Access Toolbar

In the latest version of Excel it has become your responsibility (if you choose to) to create your own toolbar, and in our basic Excel series we show you how.

The Quick Access Toolbar at the top of your screen begins with just the Save, Undo and Redo buttons. If you require fast access to any other Excel commands you are able to add them yourself. You can add almost any functionality to the toolbar including those not found on the Ribbon.

As part of our basic Excel series, this post explores 7 incredible additions to the toolbar that are sure to improve the way you work.

Continue reading

Insert a Picture into a Comment

Excel was created for the use of calculating and analysing huge amounts of data. Because of this it has never been great for storing large amounts of text or pictures. Inserting images into a cell would make the spreadsheet even larger and more awkward in its daily use.

Comments are fantastic for leaving notes for other users, but they can also be used to store pictures. These pictures can then be made visible when required rather than permanently displayed on screen within a cell.

Continue reading