Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Tables
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Pivot Tables
Resolved · Low Priority · Version 2003
Reply Tue 16 Dec 2008, 17:00Delegate Teresa said...
Teresa has attended:
Excel Intermediate course
Excel Advanced course
Pivot Tables
How do I create a basic pivot table
For upcoming training course dates see: Pricing & availability
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
|