Pivot

Hi John, thanks for your query.

Put simply a Pivot table is a summarising and analytical tool, affording structural flexibility in the construction of bespoke tables from a source of data. There are two key things to remember about pivot tables: 1) the pivot table functionality in Excel is a creative tool; it's easy to create a new table using it, but what you do with it after that is entirely up to you, and 2) the pivot table created is not dynamically connected back to your source data, so you must remember to refresh when you change your source data. We create and manipulate pivot tables on our Advanced Excel course, but here is a brief walkthrough of basic functionality:

http://peltiertech.com/Excel/Pivots/pivotstart.htm

Hope this helps,

Anthony