PivotTables are interactive information display that allows users to analyze the groups and large amounts of data in a concise, tabular form for easy reporting and analysis.One of the advantages of the specified function in Excel is that it allows you to edit, hide and show different categories in a single file to provide an alternative view of the data.In this article, you can read the instructions about how to "Eksele" make a table.
Step 1 of 3: Setting up from scratch
Start Microsoft Excel.
Click on the menu "Data", then select the summary table (note: in Excel versions 2007/2010, perform "Paste» & gt; a summary table).
Specify find data that you intend to compile.If the information in the list of Excel, which is now open, the software automatically chooses the range of cells.Click "Next".
Make sure that the option "New list" is selected after clicking on "Next" in the previous step.Once you've done that, click "Finish".
Step 2 of 3: How to create a table in the "Eksele»
If necessary, adjust the range in the text field.These attributes are located under the menu item "Select the table."If the source of information for the table is external, created in a separate program (for example, Access), click the "Use external data sources."Then find the menu item "Select Connection" and then click the dialog box titled "Existing Connections".
Make a choice place to create a PivotTable.Excel default mode as it creates new leaf to be added to the book.Talking about how to "Eksele" make the table so that it appeared on a given sheet, you need to press select "Existing Worksheet", and then specify the location of the first cell in the text field "Location".
Click "OK".Then, add a new mesh net for a PivotTable, and then need to display the task pane "PivotTable Field List".This panel is divided into two parts.
Open menu "Choose fields to add to the report" and fill in all the field names in the source data.
Filling
Like "Eksele" make a table?Continuing to follow the instructions you need to get on-screen field, divided into four work areas, which should indicate the filter tag columns, rows, and values.
Assign tasks in the field "PivotTable Field List" in its various parts.Drag the field name from the menu item "Choose fields to add to the report" in each of four zones.
Make adjustments as necessary until there is your ideal results.
Step 3 of 3: Understanding the source terms, or how to make a table in the "Eksele" easier
First of all try to understand key definitions.There are several terms that may, at first glance, seem obscure.
What is a filter?This area contains fields that allow you to search the information specified in the summary table by filtering them on any grounds.They serve as markers for the report.For example, if you set the "Year" as a filter, you can display the summary data in the table for certain periods of time or for all the years.
Signatures columns - this area has fields that define the location of the data in the columns of the summary table.
Signatures row - said region includes fields that define the location of the data included in the line.
fields contain values that determine what data are shown in the cells of the pivot table.In other words, it is the information that is summarized in the last column (compiled by default).
field from the source data that you assign to a page (or filter) is displayed in the PivotTable report.
understanding of the above values, as well as some other settings allow you to better understand how "Eksele" make a table.Keep in mind that different versions of the program, some menu items may differ.
