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.
Let’s take a deeper look on how pivot tables functions in Excel
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.
New features in The Excel 2010 Pivot Table
- Multithreading has speeded up data retrieval and filtering in Pivot Tables making it faster.
- A new feature called Show Values is there .You have to right click the Pivot table and choose Show Values As. You will see many new options for different calculations and six new calculations that has been added to Excel 2010 Pivot Table
- You can combine items from different hierarchies using Named sets tools. While work with the same set of items excel 2010 can easily create and reuse logical grouping as a single object.
- You can modify values; recalculate new values even publish the modified data to the online analytical processing so that you can share it with other users. It includes a visual total by which the totals can be shown when one or more members are filtered.
If you have any further doubts about pivot tables you can use the help option in excel.