Pivot table

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

Resolved · Low Priority · Version 2003

1 post

ReplyThu 4 Feb 2010, 16:20Delegate Charlene said...

Charlene has attended:
Excel Advanced course

Pivot table

run through creating 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	Mon 22 + Tue 23 Mar 2010	Bloomsbury	0	FULL
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	7		£445	£450
2007	Wed 28 + Thu 29 Apr 2010	Bloomsbury	6		£445	£450
Full Schedule: See all 35 Excel VBA Intro Intermediate course dates. Bookings currently available until 22nd December 2010.

648 posts

ReplyTue 9 Feb 2010, 16:10Trainer Simon said...

RE: pivot table

Hi Charlene,

Thank you for your question and sorry for the delay in responding.

Open the spreadsheet and select any cell under the main headings. Go to Data and then the Pivot Tables option.

The wizard will then appear. Select excel database as the source and the Pivot Table option.

Then select the data source which must include all the headings and data source.

Finally tell excel where you want to place the pivot table. Then click Layout and choose which fields you want as Page, Row, Column and data.

Click OK and then Finish.

I hope this helps.

Regards

Simon

Tue 16 Feb 2010: Automatically marked as resolved.

· Organisation At Your Fingertips - Take Control Of Your Life With Excel
· Formulas In Excel: The Very Basics
· Do You Really Need Excel VBA Training?
· How to start using Excel 2007 Functions
· So Can You Really Sort On Colours In Excel 2007?

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

Excel tip:

Editing Formulas in Excel Cells

Although people like to edit a formula in the Formula bar, you can also edit a formula in the cell.

To do this select the cell and press "F2". This puts Excel into Edit mode, and you can move around in the cell and make any necessary changes.

Double-clicking the cell also puts Excel in Edit mode.

View all Excel hints and tips