Page 162 - Ms Excel Note and Workbook

MICROSOFT EXCEL NOTE AND WORKBOOK

Just like with normal spreadsheets, you can sort the data in a PivotTable using the Sort &
Filter command on the Home tab. You can also apply any type of number formatting you want. For
example, you may want to change the number format to Currency. However, be aware that some
types of formatting may disappear when you modify the PivotTable.

TIP
If you change any of the
data in your source
worksheet, the PivotTable
will not update
automatically

Pivoting Data

One of the best things about PivotTables is that they can quickly pivot—or reorganize—your data,

allowing you to examine your worksheet in several ways. Pivoting data can help you
answer different questions and even experiment with your data to discover new trends and patterns.

To add columns:

So far, our PivotTable has only shown one column of data at a time. In order to show multiple

columns, you'll need to add a field to the Columns area.

1. Drag a field from the Field List into the Columns area. In our example, we'll use
the Month field.

TIP
Pivoting data can help you
answer different questions
and even experiment with
your data to discover new
trends and patterns..

153 | P a g e