It is really easy to move a whole Excel data table to a new location on the same worksheet or even a new location on a different worksheet in the same workbook or an entirely different workbook.  I...

Ever need to find out which value in your data set occurs most frequently? Yes I have as well more often than I thought I wold when I learned this Excel tip.  Well here is a really easy way to do...

This is a small tip but a good one......Yes I called them dancing ants in the title of this tip but I am actually talking about the marquee that is around copied cells.  If you want to quickly get...

I bet you have closed the odd Excel workbook or two without saving the changes when really should have.  I know I have!.  Not so much of a worry with Excel 2010 onwards though as your workbook will...

To use a Pivot Table we usually need transactional data or a flat data table containing rows and columns of data, that is not summarised already.  In my example below, the data already looks...