Microsoft Office Tutorials and References
In Depth Information
PivotTables help you answer questions about your
data. PivotTables are based on lists. Lists are made
up of rows and columns. You can use a worksheet
list or you can connect to a list from another data
source, such as Access. For more information on
lists, see Chapter 4.
The row and column labels of a PivotTable usually
have discrete information, meaning the values fall
into categories. For example, gender is a discrete
variable because all values are either male or female.
Quarter is another discrete variable because all
values fall into one of four quarters — Quarter 1,
Quarter 2, Quarter 3, or Quarter 4. Salary and
weight are not discrete but continuous because
a wide range of values is possible for each.
The body of a PivotTable — the data area — usually
has continuous data to show how the data are
distributed across rows and columns. For example,
you could show how the number of units sold is
distributed among sales regions in different quarters.
Click and drag to select the data
you want to include in your
Note: Make sure to include the
row and column headings.
Click the Insert tab.