Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft office training excess - PivotTable

microsoft office training excess - PivotTable

ResolvedVersion Standard

Wed 10 Jan 2007, 17:13 Delegate Rob said...

Rob has attended:
Excel Advanced course

PivotTable

How can I create a pivot table from a range of data?

Thu 11 Jan 2007, 09:55 Trainer Richard said...

RE: PivotTable

1. Select the range of data that you want to use in the PivotTable, including the column headings.

2. From the Menu bar select DATA, then PIVOT TABLE

3. Follow the steps in the PIVOT TABLE Wizard the create the structure

4. Drag the fields to the relevant areas on the pivot table to analyse the information.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Reset Excel toolbars to default settings

If you find any of your toolbars in Excel have changed (i.e. they are missing or have extra buttons) then you can reset them to their defaults.

1. Go to Tools - Customise.
2. Select the Toolbars tab.
3. Select (highlight) the name of the toolbar you wish to reset, then click the Reset button on the right.
4. Close the dialogue box.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

microsoft office training excess - PivotTable

PivotTable

RE: PivotTable

Excel articles

Excel tip:

Reset Excel toolbars to default settings