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.




MicrosoftR Office ExcelR 2007 Step by Step
MicrosoftВ® Office ExcelВ® 2007 Step by Step (Step By Step (Microsoft))
ISBN: 073562304X
EAN: 2147483647
Year: 2004
Pages: 143
Authors: Curtis Frye

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net