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

application development excel - pivot table

Forum home » Delegate support and help forum » Microsoft Excel Training and help » application development excel - Pivot table

application development excel - Pivot table

ResolvedVersion Standard

Stephen has attended:
Excel Advanced course

Pivot table

how to make a pivot table

RE: pivot table

Hi Stephen

To create a Pivot Table, do the following:

1. Select the data that you want to use including the column headings.

2. Then click on DATA, then PIVOT TABLE from the menu bar

3. PIVOT TABLE Wizard starts, simply follow the steps.

4. Then drag the fields from the field list onto the pivot table.

Regarss

Richard

Excel tip:

Copying Formulae Quickly

There is a quicker way of copying a formula down a column.

Just point and double click on the black autofill handle in the right hand corner of a cell.

This will work providing you have some data in the column to the left of the column.

Sandy

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.1 secs.