Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot table
|
|
|
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 table
Resolved · Low Priority · Version 2003
Reply Fri 14 Nov 2008, 16:32Delegate Shirley said...
Shirley has attended:
Excel Advanced course
Excel Intermediate course
Pivot table
How do you st up a pivot table
For upcoming training course dates see: Pricing & availability
RE: pivot table
Hi Shirley,
Thank you for your question.
Open the file you want to use for your pivot table and go to Data, Pivot Table...
The next step is to select Pivot Table and Excel list. Then select all the cells as the range of cells you want to analyse.
Save the Pivot Table on a new worksheet and then click Layout. In the Layout screen, you choose the row and column headings you want and where the two intersect you choose a data field.
Then click Ok and finish.
I hope this answers your question.
Regards
Simon
|