Excel pivot tables, first introduced in the market by Microsoft Excel 5 it is the perfect tool for all those who have trouble calculating, when you have a limited amount of data then calculators can do the job but when you have thousands of data to sum up then Excel pivot tables can be of great help to you. Pivot tables summarizes data in data visualization programs like spreadsheet, it can not only summarize but analyze, total and store the data in tables and can be used to build charts. Pivot tables are not exclusive to Microsoft a similar function called Data Pilot is found in OpenOffice.org software as well as Google Documents allows users to create basic pivot tables but nothing can be compared to Microsoft Excel pivot table.
First of all, type the data and click somewhere inside the data. Now go to the insert tag and click the pivot table button, excel will select all the data and asks you where to put the new pivot table. You can select it according to your choice then excel creates a place holder box where you have to tell excel to analyze the data for creating a pivot table. Then go to the pivot table field list which lists all the columns in the original data and drag any of them into any four regions underneath. Now excel would need to know the piece of information you want to summarize usually its numeric piece of information thus a simple pivot table is created. For more details you can subgroup the information by dragging any data from the field list to the row label. It is very simple to edit each piece of information. You can get more detailed summary by using more than one column. For grouping your data and using column label u can subdivide the columns and rows. When you split more than one piece of information into the row or column label excel gives you nifty boxes you can collapse some of these boxes to concentrate on the others.
If you have any further doubts about pivot tables you can use the help option in excel.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.