advanced excel ms training - Pivot Table

Hi Terry

Thanks for your question and I hope you enjoyed your course today.

A pivot table can be created from information that is stored in a list, i.e. a series of columns with a heading above each column.

Click anywhere in the list, then go to Data - PivotTable and Pivot Chart report. Follow through the three steps in the Pivot Table wizard (they are quite straightforward).

Then you end up with pivot table fields that you can drag and drop into the pivot table area. The only real 'rule' is that a field containing numbers should go into the data field area.

I hope this helps.
Amanda