Pivot Tables

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

Resolved · Low Priority · Version 2003

Pivot Tables

Helen has attended:
Powerpoint Advanced course
Excel Intermediate course

by - delegate Helen [1 post] (2008 May 15 Thu, 16:20) Reply

How do you get multiple pivot tables on one sheet

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Pivot Tables

by - trainer Rich platinum contributer [744 posts] (2008 May 15 Thu, 20:18) Reply

Once you have created the first pivot table, click in a cell away from the existing table and simply add the new table in the same way.

· Tap the Power of Recorded Macros with MS Excel Courses
· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· Microsoft Excel Training: Essential for Today's Employees
· Do You Really Need Excel VBA Training?
· Improve Performance Of Your Excel Macros

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

Excel tip:

Closing Multiple Open Worksheets At Once

When multiple Excel worksheets are opening, rather than performing a File > Close menu option multiple times, hold down the the SHIFT key and select the File > Close All menu option.

Close All menu option is only displayed when Shift key is down

View all Excel hints and tips