When working with different data sets, it is often necessary to combine information into one table for further processing or analysis. Even one sheet can contain disordered data. For example, a table with sales quantities for various products, from which you want to display the total quantity for each individual product. To solve such problems, the developers of the Microsoft Excel suite have provided a very convenient built-in tool - pivot tables.
Instructions
Step 1
Open an Excel document with the data you want to make a PivotTable from. Click the mouse on one of the table cells, a prerequisite is that some value was written in this cell. The most convenient thing is to give the column an appropriate name, for example, “title”, “quantity”, etc.
Step 2
In the menu bar at the top of the window, find the Data button (for Excel 2000, XP, 2003) or the Insert tab (for Excel 2007) and click it. A list will open in which activate the "Pivot Table" button. The "PivotTable Wizard" will open, it will help you configure all the necessary parameters.
Step 3
Select the data source for the pivot table and the document type. The wizard window is divided into two parts. In the top half, indicate where you want to get the information from, for example, from an Excel file or a separate database. At the bottom, the "PivotTable" item is checked by default, so you don't have to change anything. Click the Next button and proceed to the second stage of the wizard.
Step 4
Select the data range for processing with the mouse. By default, the entire table from the original Excel sheet is selected, on the screen you will see this as a flashing dotted frame. If necessary, you can select only part of the data. Click the "Next" button when you complete the selection of information.
Step 5
Click the "Finish" button on the last screen of the table setup. You can choose where your pivot table will be located. The default is New Sheet and is the best option. You can also select the item "Existing sheet", but in this case there may be difficulties with circular links and displaying.
Step 6
Customize your pivot table. After clicking Finish, you will see the table layout and control fields. Each of them is signed to make it easier to arrange the data and customize the final output of information.
Step 7
Select the required data source in the window on the left and drag it to a suitable place on the layout. The table will immediately be populated with values from the specified columns or rows. It all depends on the purpose of creating a pivot table - it is a very flexible tool. To get this or that report, you need to select the information of interest from the list in the field of the final table, uncheck unnecessary data sources and mark the necessary ones.
