Monthly Archives: November 2017

Microsoft Excel – using series from more than one worksheet in a chart

Sometimes you may create a chart in Excel and then want to add data from another worksheet. To add in extra data, on the Chart Tools Design tab, in the Data group, click Select Data. At the left under Legend … Continue reading

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

Microsoft Excel – date format of Monday 1 Jan 2018

I was asked whether I could create a date format of Monday 1 Jan 2018 and copy it down to Tuesday 2 Jan 2018 etc. This requires a custom format. However, I also found it required me changing my computer … Continue reading

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

Microsoft Excel – quick entry of last day of every month

To enter the last day of every month into a column in a worksheet, first enter the last date of the first month to be included, say 31/01/2017. Drag down to fill in as many as required. Go to the … Continue reading

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

Microsoft Excel – adding an “X” or equivalent text in several cells in a column

I was asked recently how one could add X to every number in a cell – this would be for a product code, a part number etc. This is a matter of formatting the data. Select the cells you want … Continue reading

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

Microsoft Project – changing text size on Gantt Chart

If you have text on top of Gantt bars, it can sometimes take up a lot of space and make each row quite deep. To change the text size on the Gantt chart, on the Gantt Chart Tools Format tab, … Continue reading

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

Microsoft Excel – handling a mix of calendar days and business days

Someone I was training recently had been given a spreadsheet with dates from the beginning of the month – some as calendar dates – ending is st, nd, rd, th and some with no suffix which were business days from … Continue reading

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