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?

http://www.datapigtechnologies.com/f...es/pivot1.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"GinaS." wrote in message ...
|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?

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
--
Brevity is the soul of wit.


"GinaS." wrote:

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?

You can create forms with pivot tables in Access 2000.

Dave F wrote:
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


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

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/
--
HTH...

Jim Thomlinson


"GinaS." wrote:

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?