Pivot table samples/tutorial

[Jan Il]

Hi all Excel 2003 - Windows XP Pro SP2

I am in need of some samples or a tutorial on how to create a Pivot table. I
have worked with many areas of Excel, but, I have never had call to create a
Pivot table, and the Help files are not exactly totally clear.

I am trying to prepare some reference materials for a presentation I will be
giving on the various Office programs, and would like to be able to include
some good material for the Pivot table for Excel as well.

I would truly appreciate any suggestions or references that might be
available for download or linked to.

Jan
MS MVP - IE/OE
Smiles are meant to be shared,
that's why they're so contagious.

 

[Mike Middleton]

Jan -

When I go to www.microsoft.com and enter "excel pivot table tutorial" in the
Search box, the first result is

How to use PivotTables, Excel's data tool du jour

- Mike
www.mikemiddleton.com

 

[Dave Peterson]

Some more links:

Debra Dalgleish's pictures at Jon Peltier's site:
http://peltiertech.com/Excel/Pivots/pivottables.htm
And Debra's own site:
http://www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
http://j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
http://www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
http://office.microsoft.com/assistance/2002/articles/xlconPT101.aspx

 

[Jan Il]

Hi Mike

Jan -

When I go to www.microsoft.com and enter "excel pivot table tutorial" in
the Search box, the first result is

How to use PivotTables, Excel's data tool du jour

Thank you very much for your time and help. I really appreciate it>

Jan

 

[Jan Il]

Hi Dave

Some more links:

Debra Dalgleish's pictures at Jon Peltier's site:
http://peltiertech.com/Excel/Pivots/pivottables.htm
And Debra's own site:
http://www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
http://j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
http://www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
http://office.microsoft.com/assistance/2002/articles/xlconPT101.aspx

Great resources. Thank you very much, I really appreciate you time and
help.

Jan

 

[Ed Ferrero]

Hi Jan,

And there's another one here
http://edferrero.m6.net/Pivot200301.shtml

Ed Ferrero

 

[Jan Il]

Hi Ed

Hi Jan,

And there's another one here
http://edferrero.m6.net/Pivot200301.shtml

Thank you! This will also be very helpful.

Jan