Home > Sample chapters > Microsoft Office > Excel

Creating Dynamic Worksheets by Using PivotTables in Microsoft Excel 2010

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. By using a data table as the PivotTable data source, you can 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 comes with many attractive styles for PivotTables; you’ll probably find one you like.

  • With the PivotTable Field List task pane, you can 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.

  • Excel 2010 includes two new types of filters, search filters and Slicers, that you can use to limit the data in your PivotTables.

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