excel+training - Pivot tables

Resolved · Low Priority · Version Standard

Fri 14 Dec 2007, 17:54 Delegate Scott said...

Scott has attended:
Excel Advanced course

Pivot tables

How do i build a pivot table?

Mon 17 Dec 2007, 11:10 Trainer Sandy said...

RE: Pivot tables

Hi Scott

It was great to meet you on Friday on my course. Hope you had a great weekend.

To create a Pivot table:

1. Click anywhere on your data on worksheet.
2. Select Data menu, Pivot Table and Pivot Chart Table Report
3. At Step 3 of the Wizard, click on Layout button to construct the layout of your Pivot table.
4. Click Finish to generate a new Pivot Table.

Hpe this helps
Sandy

Mon 17 Dec 2007, 20:39 Delegate Scott said...

RE: Pivot tables

Hi Sandy

Thanks for the reply.

It was good to meet you to. I enjoyed the course - trying to squeeze the time in to give it the time it deserved.

Regards

Scott

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Autonumber in Excel

To create an autonumber field, can use the Offset() function.

In cell A1, enter the number 1.
Then in cell A2, enter this formula:

=OFFSET(A2,-1,0)+1

Then copy the formula from cell A2, down as far as you need.

See also: Autonumber in Excel forum post.

View all Excel hints and tips