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

training courses in excel - pivot table excel

Forum home » Delegate support and help forum » Microsoft Excel Training and help » training courses in excel - Pivot table Excel 2007

training courses in excel - Pivot table Excel 2007

ResolvedVersion Standard

Pivot table Excel 2007

Hi

How do I create a pivot table in Excel 2007?

thanks

RE: Pivot table Excel 2007

Hi

Thank you for your question.

To create a pivot table in Excel 2007:

1. Select a cell in the data range you wish to create the pivot table from.
2. Go to the Insert tab, and on the left hand side of the Insert ribbon you will see a PivotTable button.
3. Choose to create your PivotTable based on a table or range
4. Choose where you want your PivotTable located (existing worksheet or new worksheet).

The PivotTable area and field list should now be displayed ready for you to create your PivotTable.

Amanda

Excel tip:

The Easiest Way to See a Sum or Average in Excel 2010

Did you know the quickest and most simple way of working out the average or sum of a set of numbers?

Highlight numbers in cells or type some numbers in cells and then look at the status bar at the bottom of the window. Here you will see a display of the average of the numbers, as well as a count of the cells and the sum of these cells.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.