basic excel training - Pivot tables

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

Resolved · Low Priority · Version Standard

Pivot tables

Sharon has attended:
Excel Advanced course

by - delegate Sharon [1 post] (2007 Mar 9 Fri, 09:33) Reply

what are pivot tables used for?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Aug 29 Fri	Southwark	3	book now	£224	£235
2003	2008 Sep 3 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 5 Fri	Bayswater	4	book now	£195	£205
2002/XP	2008 Sep 10 Wed	Tooting	0	FULL
2003	2008 Sep 10 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 12 Fri	Southwark	7	book now	£203	£230
Full Schedule: See all 127 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: pivot tables

by - trainer Carlos gold contributer [394 posts] (2007 Mar 9 Fri, 16:18) Reply

Hi Sharon

A pivot table takes 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.

Carlos

· Excel Macros for the Non-Programmer
· Benefits of learning about Excel charts
· Fun Things I've Done With Excel
· A Beginners Guide To Formulas In Excel
· An Introduction to Microsoft Excel: Top Features for the Excel Novice