Page 160 - Ms Excel Note and Workbook

MICROSOFT EXCEL NOTE AND WORKBOOK

4. A blank PivotTable and Field List will appear on a new worksheet.

5. Once you create a PivotTable, you'll need to decide which fields to add. Each field is
simply a column header from the source data. In the PivotTable Field List, check the box
for each field you want to add. In our example, we want to know the total amount sold
by each salesperson, so we'll check the Salesperson and Order Amount fields.

TIP
Once you create a
PivotTable, you'll need to
decide which fields to add.

151 | P a g e