Excel - Pivot Tables and easily

Although "PivotTable" sounds like a complex and advanced features of Excel, it is actually very simple but very useful tool. Pivot Tables are a great way, the sum of data into categories. For example, if you have thousands of records with employees from different departments within different locations, you can create a pivot table showing at a glance how many employees there are in every corner, in every department and each departmenteach site.

First, make sure that the list of data without blank rows or columns - Excel is looking at a blank row or column to indicate the end of the data. Position the cursor somewhere in the data list and click on the data in the menu bar, click PivotTable and PivotTable reports. The PivotTable and PivotChart Wizard - Step 1 of 3 appears. Click Finish. Clicking on the PivotTable Field List window and drag the field name of the category you want as a witness linefield row fields here. " Click and drag the field name of the category you want as column headings on the marked "Drop column fields here." Now click and drag the field name that is here to summarize the field labeled "Drop Data Items."

Take, for example, called a spreadsheet that lists employees to create (in a column called NAMES), where together with its position (in a column called) and division (in a section of column) of a PivotTablesummarizes the number of employees in various departments everywhere. After the cursor in the data and click on the menu bar, pivot tables and pivot tables, reports, PivotTable and Pivot Chart Wizard - Step 1 of 3 of the window - just click Finish. Click in the PivotTable Field List pane and drag on the path "Drop Column Fields Here" button and drag the Department for the area called "row headers Drop Here" and click and drag the name of the selected range"Drop data items here". The resulting pivot table shows how many employees in each department has, in every place and every department in every location. In addition, the PivotTable header LOCATION department and are dropdown lists that only select the department (s) or location (s) you want to display to activate. Now, how easy and how useful?