Microsoft Office Tutorials and References
In Depth Information
Analyzing Data Using a PivotTable
Click OK to the alert.
See Also
See “ Working Online with SharePoint and SkyDrive ” on page 486 for
information on working with a SharePoint Services site from Excel.
Analyzing Data Using a PivotTable
When you want to summarize information in a lengthy list using complex criteria, use the
PivotTable to simplify your task. Without the PivotTable, you would have to manually
count or create a formula to calculate which records met certain criteria, and then create
a table to display that information. You can use the PivotTable layout to determine what
fields and criteria you want to use to summarize the data and how you want the resulting
table to look. You can create a PivotTable in a snap with the Quick Analysis tool ( New ! ) or
use the PivotTable button to have a little more control over the results. With this control,
you can add multiple tables—either imported from a relational database from an extern-
al source or individually—in a PivotTable using the Excel Data Model ( New ! ). A Data
Model is a collection of tables and their relationship between the data. If you’re not sure
which type of PivotTable to select, you can choose a recommended chart ( New ! ) based on
the data.
Search JabSto ::

Custom Search