Teresa has attended:
Excel Intermediate course
Excel Advanced course
Pivot Tables
How do I create a basic pivot table
RE: Pivot Tables
Hi Teresa,
Thank you for your question;
In reply: A pivot table is a summarisation of a larger database/list which can be viewed from different perspectives. To create a Pivot table you should use the Pivot Table wizard, as this allows you to correctly position your fields.
From your main table of information: Click in the database, go to the menu command Data>Pivot Table and Pivot Chart Report and follow the steps to create the frame for your Pivot table, drag your fields to the correct positions and your Pivot table is created for you. Formatting and subsequent rotation is undertaken by opening the Pivot Table toolbar and also by dragging and dropping fields to new locations. I hope that helps... Pete
