Microsoft Office Tutorials and References
In Depth Information
The best way to understand the concept of a pivot table is to see one. Start with Figure 18-1, which shows a por-
tion 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 consists of 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 opened at the bank. The table has the following columns:
• The date when the account was opened
• The day of the week the account was opened
• The opening amount
• The account type: CD, checking, savings, or IRA (Individual Retirement Account)