excel consultant - Pivot

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

Resolved · Low Priority · Version Standard

Pivot

Stuart has attended:
Excel Advanced course

by - delegate Stuart [4 posts] (2007 Mar 7 Wed, 09:50) Reply

What is a pivot table?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Pivot

by - trainer Tracy platinum contributer [586 posts] (2007 Mar 7 Wed, 16:59) Reply

Hi Stuart

Thanks for your question.

The idea behind a pivot table is to take information that is stored in a series of columns in Excel (a list) and turn it into a summarised table format.

The pivot table allows you to collate/summarise individual values that are stored in a column, by for example, summing them, averaging them, displaying percentages of totals and so on.

The major advantages of a pivot table are that you can rearrange the items you put into the table quickly and easily by dragging and dropping; and you can create a chart from it by clicking a button.

Tracy