Excel 2007: PivotTables and PivotCharts

PivotTables are powerful! PivotTables allow users to combine, compare and summarize thousands of rows of data into just a few rows. What’s more, pivot tables are interactive. Rows and columns are easily rotated, allowing users to analyze your data from different perspectives. Users can then drill down into specific data points for areas of interest. After this course students will be able to: build and manipulate a basic PivotTable, filter and group PivotTable data, format a PivotTable, change and create summary calculations and create a PivotChart from a PivotTable. This class is appropriate for the experienced Excel user. Previous experience with PivotTables is not necessary.

Excel_2007_PivotTables.pdf

  Related Posts