Microsoft Office Tutorials and References
In Depth Information
A Pivot Table Example
One minor drawback to using a pivot table is that unlike a formula-based summary report, a
pivot table does not update automatically when you change the source data. This does not pose
a serious problem, however, because a single click of the Refresh button forces a pivot table to
update itself with the latest data.
A Pivot Table Example
The best way to understand the concept of a pivot table is to see one. Start with Figure 18-1,
which shows a portion of the data used in creating the pivot table in this chapter.
Figure 18-1: This table is used to create a pivot table.
This table comprises a month’s worth of new account information for a three-branch bank. The
table contains 712 rows, and each row represents a new account. The table has the following
columns:
h The date when the account was opened
 
Search JabSto ::




Custom Search