advanced excel seminar training

advanced excel seminar training - Pivot tables

Resolved · Low Priority · Version Standard

Pivot tables

Dominique has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Dominique [3 posts] (2007 Sep 20 Thu, 09:56) Reply

How do I amend pivot tables without having to create the pivot table again from step 1?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 3 Wed	Bloomsbury	0	FULL
2003	2008 Dec 5 Fri	Bayswater	1	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
2007	2008 Dec 10 Wed	Bloomsbury	2	book now	£240	£245
2003	2008 Dec 12 Fri	Southwark	6	book now	£214	£230
Full Schedule: See all 96 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Pivot tables

by - trainer Richard platinum contributer [818 posts] (2007 Oct 2 Tue, 11:13) Reply

You can either right click on the PivotTable and choose PIvotTable WIZARD. This will take you back into the steps of the wizard.

Alternatively you can drag the firlds OFF the PivotTable and then recreate the layout.

RE: Pivot tables

by - trainer Amanda diamond contributer [1240 posts] (2007 Oct 2 Tue, 11:55) Reply

Hi Dominique

Thank you for your question.

Once the pivot table has been created, you can change what is displayed in the table by dragging a field into or out of the table.

To update the data items field, click the Refresh button (!) on the Pivot Table toolbar.

I hope this helps.
Amanda

· Do You Really Need Excel VBA Training?
· Benefits of learning about Excel charts
· Microsoft Excel Training - Discover A Hidden Power At Your Fingertips
· Customized Financial Excel Courses in London
· Creating Charts with Excel

Excel tip:

Hide data in Excel Worksheets

Let's say you have some data in cell 'C5' you would like to hide from the casual viewer.

Click cell 'C5' to select it.

Click the 'Format' menu, select 'Cells'. When the 'Format Cells' dialogue box opens, click the 'Numbers' tab (if necessary), then select 'Custom' from the 'Category' list.

Double-click the 'Type' entry box and type three semi-colons: ";;;"

Click 'OK' to close the dialogue box and accept the new formatting.

The data in cell 'C5' disappears. It's still there and will work in calculations, but it isn't visible.

If you need to check the data, just click the blank cell and the contents appear in the 'Formula bar'.

View all Excel hints and tips

Rate this page: