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
Tags » Microsoft Excel 2010
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
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
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
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
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