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
Tags » Microsoft Excel 2010
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
I was demonstrating using the fill handle to create lists of weekdays recently when one of my trainees asked whether we could instead produce a calendar with weekends greyed out. 232 more words
If I have a date in which an order has to be sent and I know the number of working days that it takes me to process the order, I may want to find out when I need to start processing it. 157 more words
If you don’t want to click on the tabs at the bottom of each worksheet to move from one to another, the keyboard shortcuts are: 43 more words
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