Tags » Microsoft Excel 2010

Microsoft Excel - third working day of every month

Someone asked me recently whether they could produce a series in Excel to find out the third working day of every month. To be honest, it may be as easy to do this manually as you still need to input the Bank Holiday dates into Excel to do the calculation but here goes! 226 more words

Microsoft Excel

Microsoft Excel - width of columns in charts

I was working with a client the other day creating column charts of data where the horizontal axis was made up of dates. We wanted to make the columns wider, but trying to format the data series to change the width was not possible. 84 more words

Microsoft Excel

Microsoft Excel – totalling or averaging a column containing an error value

If one of your cells in Excel has an error value then using the Autosum button to total or average the numbers in the cells will also result in an error. 190 more words

Microsoft Excel

Microsoft Excel - inputting mobile numbers in a specific format

I was recently asked how to get mobile numbers in the format XXXX XXX XXX in an Excel worksheet. The answer is leave the column in which the mobile numbers are to be input formatted as… 48 more words

Microsoft Excel

Microsoft Excel – changing time from 1400 to 14:00

Sometimes we are given a column of times in a worksheet but they don’t look formatted as we went them to be, e.g. 1400 instead of 14:00. 164 more words

Microsoft Excel