Pivot tables

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

Resolved · Low Priority · Version 2003

Pivot tables

Karen has attended:
Excel Introduction course

by - delegate Karen [1 post] (2008 May 12 Mon, 16:31) Reply

What is a pivot table and how do i create it?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Sep 4 Thu	Bayswater	4	book now	£195	£205
2007	2008 Sep 4 Thu	Bloomsbury	0	FULL
2003	2008 Sep 9 Tue	Bloomsbury	4	book now	£207	£215
2002/XP	2008 Sep 9 Tue	Tooting	0	FULL
2003	2008 Sep 11 Thu	Southwark	4	book now	£207	£215
Full Schedule: See all 137 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Pivot tables

by - trainer Amanda platinum contributer [947 posts] (2008 May 15 Thu, 14:13) Reply

Hi Karen

Thank you for your question.

A pivot table is a tool that can be used to manipulate data in various ways.

The Microsoft web site has quite a good tutorial on this which you will find here:
http://office.microsoft.com/en-us/excel/HA010346321033.aspx

Pivot Tables are covered as part of our Excel Advanced course.

Kind regards
Amanda

· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· How to Create Better Excel Spreadsheets: Part Four
· Microsoft Excel Training - Numerical excellence for all
· Compare Different MS Excel Training Methods

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

Excel tip:

COUNT function vs COUNTA function

The COUNTA function works in the same way as the COUNT function, except that it will count cells that contain text (labels) and also cells that contain numbers (values). The COUNT function will only count cells that contain numbers. Blank cells are not counted by either the COUNT or the COUNTA function.

View all Excel hints and tips