Monthly Archives: August 2020

Microsoft Excel – including a date in a text string

There are occasions when you may want to include a date in a text string in Excel. The method shown here is slightly convoluted but it does work! If my original date is in cell A4 (I used the =TODAY() … Continue reading

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

Microsoft Excel – putting two or more charts on same sheet

To put two or more charts on to a single chart sheet: Click an empty cell, and press [F11] (or Fn + F11 depending on your laptop. Change the default chart name to Two Chart Sheet (or some other suitable … Continue reading

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

Microsoft Excel – using Sparklines

Sparklines are small charts of data placed within a single cell within a worksheet. There are three types of sparkline charts: Line – shows trends and changes in values over time Column – allows comparison in values Win/Loss – allows … Continue reading

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

Microsoft Outlook – using Quick Parts to add commonly repeated blocks of text

If you are replying to (or creating new) emails, you may have some standard text that you may want to include on a regular basis. For example, one that I often write is: “Thank you for your enquiry regarding Excel … Continue reading

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