advanced excel course - Pivot tables

Resolved · Low Priority · Version Standard

Pivot tables

Claire has attended:
Excel Intermediate course

by - delegate Claire [1 post] (2007 Oct 16 Tue, 16:52) Reply

How do you set up a pivot table?

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

RE: Pivot tables

by - trainer Rajeev gold contributer [462 posts] (2007 Oct 18 Thu, 10:36) Reply

Dear Claire:

To create Pivot tables you have to ensure that you have selected any cell within the table!!

- From the Menu bar select Data > Pivot Tables and Pivot charts Report
- Click Finish if you want to keep the default settings
- Once you have a new sheet simply drag and drop the relevant fields from the Pivot table Field List box in to teh blue bordered area.

For hands on experience of this you might want to Book for Excel Advanced course which will cover this and many more topics that you will require to carry out your day to day activities!!

Please copy and paste the following following link and see when is our next Advanced course is scheduled:

http://www.microsofttraining.net/order/pricing_availability.php