Pivot Table

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

Resolved · Low Priority · Version Standard

Pivot Table

Lars has attended:
Excel Advanced course

by - delegate Lars [1 post] (2008 Feb 8 Fri, 15:44) Reply

what are they?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 9 Fri	Bloomsbury	1	book now	£240	£245
2007	2009 Jan 14 Wed	Bloomsbury	5	book now	£235	£245
2002/XP	2009 Jan 14 Wed	Tooting	0	FULL
2003	2009 Jan 16 Fri	Southwark	0	FULL
2007	2009 Jan 21 Wed	Bloomsbury	3	book now	£240	£245
2003	2009 Jan 21 Wed	Southwark	2	book now	£235	£240
Full Schedule: See all 114 Excel Advanced course dates. Bookings currently available until 31st March 2010.

RE: Pivot Table

by - trainer Stephen gold contributer [394 posts] (2008 Feb 10 Sun, 11:40) Reply

Hi Lars

Thank you for your question

A pivot table is a powerful tool for analysing database style information in multiple dimensions.

First the data must be in the form of a list, with column headings and no row headings. It is then possible to use a pivot table to analyse relationships between the different data items

For example if you have a database with the following column headings

SalesPerson
Customer
Date
Sale Value
Customer Type

You could use a pivot table to show how much was sold by each sales person, to each customer on a monthly basis.

Hope this helps

Regards

Stephen

· Advanced level training: Microsoft Excel and the Web
· Microsoft Excel Training Courses or Consultants: Which Is Better For Your Company?
· How to Create Better Excel Spreadsheets: Part Four
· Microsoft Excel Training: Not Just for Newbies Anymore
· Microsoft Excel Training: Essential for Today's Employees

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

Excel tip:

Select only cell that contain text to lock format

For selecting cells that only contain Text in Excel

By selecting cells that only contain text, you can delete, fill or protect cells of this type.

Use short cut to Go to box (F5) or Edit, Go to
In the dialog box, click special button & select Constants and only check text or any other desired type.

Click OK.

And text cells will all be highlighted for you to apply format. Please note only works on one sheet at a time.

View all Excel hints and tips

Rate this page: