Pivot table

The UK's most regular instructor-led training courses.
Training information: excel computer training · Excel training course · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

1 post

ReplyWed 24 Jun 2009, 14:07Delegate Jennifer said...

Jennifer has attended:
Excel Intermediate course

Pivot table

How can I create a pivot table?

Version	Date	Location	Places available	Book	Next place rate (£)
Excel VBA Intro Intermediate 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Thu 18 + Fri 19 Mar 2010	Southwark	0	FULL
2003	Mon 22 + Tue 23 Mar 2010	Bloomsbury	2		£495	£495
2007	Tue 6 + Wed 7 Apr 2010	Bloomsbury	4		£470	£475
2003	Wed 7 + Thu 8 Apr 2010	Southwark	7		£445	£450
2007	Thu 15 + Fri 16 Apr 2010	Bloomsbury	0	FULL
2003	Wed 21 + Thu 22 Apr 2010	Bloomsbury	8		£445	£450
Full Schedule: See all 36 Excel VBA Intro Intermediate course dates. Bookings currently available until 22nd December 2010.

648 posts

ReplyWed 24 Jun 2009, 15:06Trainer Simon said...

RE: pivot table

Hi Jennifer,

Thank you for your question and welcome to the forum.

Open the spreadsheet and click in any one of the cells of data(any cell underneath the main headings). The spreadsheet must have the data arranged in columns.

Then go to Data and PivotTable and PivotChart Report. Follow the steps of the wizard specifying the type of report, the range of cells your Pivot table will be based on and which sheet you want to place the pivot table on.

Then go to Layout and specify your Row, Column, and Data fields.

I hope this answers your question.

Regards

Simon

Wed 1 Jul 2009: Automatically marked as resolved.

· Customize Your Gridlines And Borders In Excel 2007
· Tracking In Excel 2003
· Say It With Ribbon
· Microsoft Excel Training Advanced Courses - Making Data Validation Work For You
· Microsoft Excel provides the building blocks of shared information

Please browse our web site to find out more about
excel computer training and other Microsoft training courses.