pivot tables

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot tables

Pivot tables

resolvedResolved · Low Priority · Version 2003

Susan has attended:
Excel Intermediate course

Pivot tables

How best to get started

RE: Pivot tables

Thank you for your question.

My name is Greg and I have just joined Best Training.

1. Select the data you wish to use.

2. From the Menu Bar, go to the Data option, then PivotTable and PivotChart.

3. Go through the Wizard. When you get to step 3, choose the Layout button, then move the various "data" to the appropriate place by using the drag-and-drop technique.

I hope this answers your question. Please contact me if you have any other questions.

Thank you

Greg

RE: Pivot tables

Thank you for your question. My name is Greg and I have just joined Best.

To get started with Pivot Tables:

1. Select the data you which to use.

2. Go to the Menu Bar, select Data the PivotTable or PivotChart option.

3. Go through the Wizard which should have 3 steps. On third step, click on the Layout button, then drag-and-drop the fields on the right to the appropriate places.

I hope this helps. Please do not hesitate to contact me if there are any problems or further questions.

Greg


 

Excel tip:

Selecting your working range

In excel if you have an area you want to highlight, press Ctrl + * or Ctrl+Shift+8 (to get the *). This will select your working range.

View all Excel hints and tips


Server loaded in 0.08 secs.