This tip is really useful for Excel dashboards or anywhere that space is of a premium on a worksheet or, where your data set is just too large to comfortably display. Let's look at using a scroll...

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...

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...

Before I found out about this little tip, the multiple stacked report filters in my Pivot Tables REALLY annoyed me. So, here is how to avoid all of those stacked up messy filters. Yuk. I have used...