Home > Sample chapters

Creating Dynamic Lists by Using PivotTables in Microsoft Office Excel 2007

Key Points

  • A PivotTable is a versatile tool you can use to rearrange your data dynamically, enabling you to emphasize different aspects of your data without creating new worksheets.

  • PivotTable data must be formatted as a list. Using a data table as the PivotTable data source enables you to streamline the creation process by referring to the table name instead of being required to select the entire range that contains the data you want to summarize.

  • Excel 2007 comes with many attractive styles for PivotTables; you’ll probably find one you like.

  • The PivotTable Field List task pane enables you to create your PivotTable by using a straightforward, compact tool.

  • Just as you can limit the data shown in a static worksheet, you can use filters to limit the data shown in a PivotTable.

  • If you have data in a compatible format, such as a text file, you can import that data into Excel 2007 and create a PivotTable from it.