Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

advanced excel seminar training - pivot tables

Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel seminar training - Pivot tables

advanced excel seminar training - Pivot tables

ResolvedVersion Standard

Dominique has attended:
Excel Intermediate course
Excel Advanced course

Pivot tables

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

RE: Pivot tables

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

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.