Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

training courses in excel - Pivot table Excel 2007

Resolved · Low Priority · Version Standard

Reply Wed 31 Oct 2007, 09:42Trainer Amanda said...

Pivot table Excel 2007

Hi

How do I create a pivot table in Excel 2007?

thanks

For upcoming training course dates see: Pricing & availability

Reply Wed 31 Oct 2007, 09:46Trainer Amanda said...

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 articles

· Microsoft Excel Training Advanced Courses - Making Data Validation Work For You
· Fun Things I've Done With Excel
· Create An Improvised Bar Chart In Excel
· Creating Tables Automatically In Excel 2010
· How To Identify The Most Critical Data In A Large Excel Spreadsheet

Excel tip:

Sorting List Subtotals

If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

View all Excel hints and tips