Category Archives: Uncategorized

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

Searching File Contents Using File Explorer

I was at client site recently and was told that File Explorer wasn’t searching within files but only file names. I checked on my laptop and didn’t have the same problem. It turned out that their Search options were configured … Continue reading

Posted in Uncategorized | Leave a comment

OCD – intrusive thoughts

This is not something I would generally write about in this blog but “If Only I’d Known That” I may have saved my son from some very troubled teenage years. When people think about OCD, they think about people who … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

Microsoft Excel – Don’t want to see Page Breaks?

I always thought it was good to see the Page Break dotted lines in an Excel worksheet – they are shown if you have gone to File – Print or to Page Layout view or Page Break Preview. However, one … Continue reading

Posted in Uncategorized | Leave a comment

Microsoft Excel – pictures not moving with sorted or filtered data

Some organisations have pictures of products in their workbooks. A client I visited this week was complaining that sorting and filtering data did not move their pictures with the data. To overcome this, select the first picture, then click Ctrl … Continue reading

Posted in Uncategorized | Leave a comment

Microsoft Excel – number of weeks between dates

You may want to know how many weeks it is between two dates. In the example below, I want to know how many weeks it is since I invoiced them. I can combine the Weeknum function and the Today function … Continue reading

Posted in Uncategorized | Leave a comment