Tags » Microsoft Excel 2010

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

Microsoft Excel - Mac keyboard shortcut for absolute cell references

If you are using a PC or Windows based laptop, you can make an Excel cell reference absolute (or fixed) by pressing the F4 function key on the keyboard after the cell reference. 37 more words

Microsoft Excel

Microsoft Excel – excluding hidden rows in totals

If you use the AutoSum button in Excel, then figures in hidden cells are still used in the totals.

If, however, you first format the data as a table and then do a total within the table, the values in hidden cells are not included. 127 more words

Microsoft Excel

Microsoft Excel - sorting or Charting Week1, Week2 etc

Someone I was training had a spreadsheet with one column showing Week 1 onwards and another column showing sales figures for that week.

If you sort the information by another column and then sort by the week column again, you will not get the same order as when you started. 175 more words

Microsoft Excel