The pivot table (of franz. more pivoter = turn), also turning table mentioned, is a special kind of table for the clear representation of complex volume of data. It serves for to the announcement, unification, evaluation and filtering of data from other tables.

Lines and columns in a pivot table can be turned and changed over and positioned at will, in order to make different representations and analysis opinions possible of the data. The original data are not changed.

Data sources for pivot tables can be lists and data bases from spread-sheet analyses, in addition, tables from external applications of data bases, e.g. within a Office package. In the usual Office packages an assistant (pivot table assistant or data pilot) helps with the production of pivot tables.

For the improvement of the overview with large data sets the possibility of the production of a pivot diagram exists with some Office packages.

Articles in category "Pivot table"

We found here 1 articles.

Related Websites

We found here 5 related websites.

• Introduction To Pivot Tables
  An very quick introduction to Pivot Tables in Excel97 and 2000.


• Microsoft Office Assistance: PivotTable reports 101
  To answer these and other questions, you can create a PivotTable


• Pivot Table Introduction
  Microsoft introduced Pivot Tables into Excel with version 5. ... Click a cell in the PivotTable, and on the Pivot Table toolbar choose the Pivot Table ...


• Pivot Table: Excel Pivot Table. Pivot Table Tutorials and Downloads
  Excel Pivot Tables With Free Pivot Table Tutorial.


• Pivot Tables Tutorial
  If you use a range of data as input to a pivot table -- and name that range " Database", ... Use the multiple consolidation range feature of pivot tables to ...