RSS

Pivot Table

26 Feb

PivotTables are an interactive table that allow the user to group and summarize large amounts of data in a concise, tabular format for easier reporting and analysis. They can sort, count, and total the data, and are available in a variety of spreadsheet programs. One advantage of this feature in Excel is that it allows you to rearrange, hide, and display different category fields within the PivotTable to provide alternate views of the data. Read on to find out how to create your own pivot table in Excel.

Pivot Table

Brush up on key terms. There are several terms which may seem unclear upon cursory glance of the Excel pivot tables. Report filter. This area contains the fields that enable you to page through the data summaries shown in the pivot table by filtering out sets of data. They act as the filters for the report. For example, if you designate the Year field from a table as a Report Filter, you can display data summaries in the pivot table for individual years or for all years represented in the table.

Pivot table

  • Column labels. This area contains the fields that determine the arrangement of data shown in the columns of the pivot table.
  •  Row labels. This area contains the fields that determine the arrangement of data shown in the rows of the pivot table.
  •  Values. This area contains the fields that determine which data are presented in the cells of the pivot table — they are the values that are summarized in its last column (totaled by default).
  •  Page field. A field from the source data that you assign to a page (or filter) orientation in a PivotTable report.

Pivot Table

  •  Data field. A field from the source data that contains values to be summarized. For example, Sum of Sales is a data field.
  •  Column field. A field from the source data that you assign to a column orientation in a PivotTable report. For example, Type is a column field.
  •  Item. A subcategory of a row, column, or page field.
  •  Row field. A field from the source data that you assign to a row orientation in a PivotTable report. For example, Region and Salesperson are row fields.
  •  Data area. The cells in a PivotTable report that contain summarized data.

Hope it helped you. Plesae feel free to coment or drop mail on thinkandbegin@gmail.com

Advertisements
 
Leave a comment

Posted by on February 26, 2012 in MS Excel, My Home

 

Tags: ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: