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. 93 more words

Microsoft Excel