Pivot tables

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

Resolved · Low Priority · Version 2003

Pivot tables

Fatma has attended:
Excel Intermediate course

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

How do you delete a pivot table?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	1	book now	£495	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	3	book now	£475	£495
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	4	book now	£475	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	3	book now	£475	£495
2003	2008 Oct 23 Thu + 24 Fri	Southwark	4	book now	£475	£485
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Pivot tables

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

Highlight the pivot table including at least one cell all around the pivot table, right click and select delete. You can then move cells left or up

regards

· Prepare for your MOS Certification with MS Excel Courses
· How to Create Better Excel Spreadsheets: Part One
· Take the Anxiety out of Domestic Finances with Microsoft Excel
· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· How to Create Better Excel Spreadsheets: Part Two

Please browse our web site to find out more about
excel course tate modern and other Microsoft training courses.

Excel tip:

Adjusting the Elevation and Rotation in a 3-D Chart

For any 3-D chart you create, you can adjust the chart’s elevation and rotation to make it more visually appealing. To do this, click the chart and select 3-D View from the Chart menu. The 3-D View dialog box will appear.

The elevation is the height you view the chart from. Click the arrows to the left of the preview picture or enter a value (something between 90 and –90) in the Elevation field to adjust the elevation.

Rotation is the rotation of the plot area around the z-axis. Click the arrows below the preview picture or enter a value (something between 0 and 360) in the Rotation field to adjust the rotation

View all Excel hints and tips