I really do not like the way when you create a Pivot Table and add multiple fields to the Row or Column Label areas, subtotals are shown at the the top for outer fields.  This just does not sit well...

This tip is one my most favorite time savers when using Pivot Tables- the ability to create many reports with just a few mouse clicks. The scenario for this example is the national sales manager...

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

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