Category Archives: Microsoft Office 365

Problems with Outlook contacts showing wrong names

I was at a client site yesterday and although contact names and email addresses looked right in the Contacts list, on trying to send an email some of them were getting mixed up e.g. John Smith was showing as Jane … Continue reading

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

Microsoft Excel – the IFS function

Are you using Office 365? If so, instead of a nested IF, you can use the new IFS function. Consider the example below: We would generally use a nested IF to work out the exam score, the formula being: =IF(B2>80,”A”,IF(B2>70,”B”,IF(B2>60,”C”,”FAIL”))) … Continue reading

Posted in Excel 365, Microsoft Excel, Microsoft Office 365 | Tagged , , | Leave a comment

Outlook Online (OWA) – setting email signature

If you want to set up an email signature in Outlook Online, click the Settings button – the one that looks like a cog, then scroll right down to the bottom and click Mail. A list of options will appear … Continue reading

Posted in Microsoft Office 365, Outlook 365 | Tagged , , , | Leave a comment

KeyTips in Microsoft Office 2010, 2013, 2016

If you are an excellent typist you may prefer to use the keyboard rather than keep stopping to use the mouse to select a ribbon button If you press the Alt key from any ribbon, KeyTips appear. Press the relevant … Continue reading

Posted in Microsoft Office 2007 and 2010, Microsoft Office 2013, Microsoft Office 2016, Microsoft Office 365, Microsoft Ofiice 2016 | Tagged , , , , , | Leave a comment