Category Archives: Uncategorized

Microsoft Excel – using conditional formatting to highlight upcoming renewal dates

A client has employees who have to renew various work certificates every 3 years. If you have a lot of employees it would help to see when renewal dates were approaching. This can be done by using Conditional Formatting in conjunction … Continue reading

Posted in Excel 365, Microsoft Excel, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016, Uncategorized | Tagged , | Leave a comment

Microsoft Teams – Microsoft Office dialog boxes not showing when sharing screen

I was training Microsoft Excel remotely recently using Microsoft Teams. On opening the Insert Function dialog box, I was told it couldn’t be viewed by my audience. What was I doing wrong? I should have chosen to share Desktop which lets you … Continue reading

Posted in Microsoft Teams, Office 365, Uncategorized | Tagged , | Leave a comment

Microsoft Word – adding line between text in a table

A client recently contacted me with their meeting minutes template. When they write up their minutes after the meeting, they have to make sure that actions are separated into a separate box. This means that if any amendments are made, … Continue reading

Posted in Microsoft Word, Microsoft Word 2010, Microsoft Word 2013, Microsoft Word 2016, Uncategorized | Tagged , , | Leave a comment

Microsoft Excel – Calculating the difference between times

If you are collecting data in terms of dates and hours and minutes, you may well want to find a time difference between two columns, e.g. time needed to service calls, time taken for order to be dispatched, etc. First … Continue reading

Posted in Excel 365, Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016, Uncategorized | Tagged , | Leave a comment

Microsoft Word – Order of Styles in Style Gallery

If you are using styles in Microsoft Word, you may just want to see the styles you want to use and you may wish to delete some of the styles you can see. Deleting styles from the Gallery is easy … Continue reading

Posted in Microsoft Word, Microsoft Word 2007, Microsoft Word 2010, Microsoft Word 2013, Microsoft Word 2016, Uncategorized | Tagged , | Leave a comment

Microsoft Excel – The UNIQUE function

If you are an Excel 365 user, you will have the UNIQUE function, which looks at a range of cells and produces a list of unique values. This may, be useful, for example, if you wanted to create a Data … Continue reading

Posted in Uncategorized | 2 Comments

Microsoft Excel – TEXTJOIN function

When storing names in Excel, it is usual to create three separate fields – Title, FirstName and Surname. Sometimes we want to join the words together, for example, for sending out an invoice. Joining two or more words together into … Continue reading

Posted in Uncategorized | Leave a comment

Microsoft Outlook – Classic Ribbon vs Simplified Ribbon

From Office 2007 onwards, there has been a ribbon structure at the top of the opened package with various tabs showing various commands. On opening Microsoft Outlook on a computer belonging to a client recently, the ribbon showed some icons … Continue reading

Posted in Microsoft Outlook 2016, Outlook 365, Uncategorized | Tagged , | Leave a comment

Microsoft PowerPoint – how can I stop my hyperlink changing colour when it is clicked

Not everyone is using PowerPoint for presentations; some use it to produce notices or reports. If you are creating something to put on a wall, you don’t want some hyperlinks to be differently coloured to others. The reason this happens … Continue reading

Posted in Microsoft PowerPoint, Microsoft PowerPoint 2013, Microsoft PowerPoint 2016, Uncategorized | Tagged , , | Leave a comment

Microsoft Outlook – printing contact list with notes

A client wanted to be able to print off contact details with Notes from Microsoft Outlook. This is easy enough for one contact – open up the contact details, then click File – Print. The contact details will be printed, together … Continue reading

Posted in Uncategorized | Leave a comment