What is Pivot Table Many Excel users are not familiar with, or are intimidated by Pivot Tables, one of the most powerful features in Excel. This presentation describes Pivot Tables and Few Features of Pivot Table.
Creating Pivot Table A pivot table is a great reporting tool that sorts and sums independent of the original data layout in the spreadsheet. If you never used one, this below example will most interesting for you. First, set up / create some data, in a specific range in Excel, like below slide,
Selecting Data Range for Pivot Table As given in example I have created data of 3 Workers x,y,z and their,weekly payments in Various Segments. Selected a Range of (A1:D50)
Creating Pivot Table
Now choose any cell in this table and choose Pivot Table wizard in the Data menu. Excel asks for the data source and suggests this table. Click OK.
Pivot Table Range Here We need to understand the data range. Excel suggests the table as shown in above Slide . If you expect to add data in the future, set the data range to include as many rows as you think you will ever need. Rather than A1:D50, you may want to specify $A$1:$D$500. One more suggestion is , as shown in Graphic you can define the Destination of Pivot Table as New Sheet or Existing Sheet
Pivot Layout Wizard
Now comes the layout wizard, show below.
Pivot Table Field List Report Filter Column Labels Row Labels ∑ Values
Pivot Table Filed List Definitions Report Filter : Use a report filter to conveniently display a subset of data in a PivotTable report or Pivot Chart Report. A report filter helps to manage the display of large amounts of data, and to focus on a subset of data in the report, such as a product line, a time span, a Geographic region Column Labels : A field that is assigned a column orientation in a PivotTable report. Row Labels : A field that is assigned a row orientation in a Pivot Table report.
Menu Descriptions of e e m ab l a N tT o Piv
d iel F ve e i t Ac Nam
ld Fie ings tt e S
d iel F ve e i t Ac Nam
Menu Descriptions an d c u e Yo ulat z., i lc Ca lds v ce Fie rian etc va ysis al an
More to come