Tags » Microsoft Excel 2010

Microsoft Excel – finding a week number

Although it is easy enough to work out the month or year of an Excel date, using the MONTH and YEAR functions, it is not as obvious to work out what week of the year a date falls in. 135 more words

Microsoft Excel

Microsoft Excel – getting Monday and Wednesday dates into a workbook

I was training the other day and demonstrating sequences with dates, working days etc. Someone asked me whether they could quickly put all Monday and Wednesday dates into a worksheet as these were the days maintenance staff were on site. 58 more words

Microsoft Excel

Microsoft Excel – rounding to the nearest 50p

If you want to round monetary figures to the nearest 50p or the nearest 25p you can use the MROUND function which takes a number and rounds it to the desired multiple. 49 more words

Microsoft Excel

Microsoft Excel – comparing two columns using conditional formatting

Due to data entry issues, a client had instances where she had the same information for some records in both the Address2 and the Town… 152 more words

Microsoft Excel

Microsoft Excel – VLOOKUP with prices and Exchange rates

If you have a spreadsheet of items in different currencies and are doing a VLOOKUP to find the prices, you may want to return the items in £ rather than in the mixture of currencies. 113 more words

Microsoft Excel

Microsoft Excel – showing column letters in a row of a worksheet

I was asked on a training course recently whether they could show column letters in a row in their Excel spreadsheet. There is probably more than one way to do this, but I did it with a combination of three functions, ADDRESS, LEN and LEFT. 210 more words

Microsoft Excel

Microsoft Excel – sorting within a pie chart

I was asked by a client whether she could sort her pie chart so the largest number was at the top. You cannot really do this within the pie chart itself but you can do it by sorting within the Excel spreadsheet first. 46 more words

Microsoft Excel