microsoft office training excess - pivottable

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

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

microsoft office training excess - PivotTable

resolvedResolved · Low Priority · Version Standard

Rob has attended:
Excel Advanced course

PivotTable

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

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.


 

Excel tip:

Find cells that match a format

In Excel you may wish to find cells that contain a specific formatting such s colour.

Select Edit > Find, click on Options and then Format...choose the formatting that you want found and click on OK

Choose one of the Find buttons to find.

View all Excel hints and tips


Server loaded in 0.2 secs.