Recommondation for training sites for Pivot Tables in Excel 2000?

[Guest]

I am starting a job where I will be using Pivot Tables extensively through
Excel and Access through Office 2000. The employer offers minimal background
and training, but I would like to be able to see it in a different framework.
Any thoughts or suggestions for training sites I can cruise online?

 

[Niek Otten]

http://www.datapigtechnologies.com/flashfiles/pivot1.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am starting a job where I will be using Pivot Tables extensively through
| Excel and Access through Office 2000. The employer offers minimal background
| and training, but I would like to be able to see it in a different framework.
| Any thoughts or suggestions for training sites I can cruise online?

 

[Guest]

Access 2000 doesn't have pivot table capability (though Access 2003 does).
Access' crosstab query function approximates a pivot table, though it is much
less robust and capable than a true pivot table.

As for training for pivot tables, I'm not really sure that's necessary.
Once you've created a pivot table you pretty much understand how to create
them in the future. This site gives some good information about pivot
tables: http://www.cpearson.com/excel/pivots.htm

As with anything else in Excel the best way to learn is to read an
introduction, find yourself some data, and start to manipulate.

Dave

 

[Guest]

Debra Dalgleish is a true authority on pivot tables. Check out this link.
Lots of stuff on the site and the book is a worthwhile read...

http://www.contextures.com/

 

[Debra Dalgleish]

You can create forms with pivot tables in Access 2000.