Pivot Tables in Microsoft® Excel® 2010
Pivot Table is the user created summary table of your original spreadsheet in Microsoft Excel 2010. It is able to allow the user to group and summarize large amounts of data in a brief, tabular format that can be used for easier reporting and analysis. You can drag and drop fields to rotate a summary field and create cross tabs, thereby this table is called Pivot Table. In order to provide alternate views of the data it allows you to rearrange, hide, and display different category fields within the Pivot Table. To create Pivot Table, you need to start the Microsoft Excel 2010 and open the workbook, where you want to create the Pivot Table. You need to format your data as straight lists of values. Then point the data you want in the Pivot Table. After selecting the data, you need to select the 'Data' menu and select 'Pivot Table' and 'Pivot Chart Report'. You need to select the radio button which labeled as 'Microsoft Excel list'. Then you need to verify that the range of cells you selected is listed in the Range field. Then click 'Finish' button to form the Pivot Table. After creating the Pivot Table, you can drag and drop the label values according to your requirements to get the data you need.
- New Entry point
- New Calculations
- Visual totals for Pivot Table and Sets
New Entry point
A new entry point for easy access has been added to the Show As menu in Microsoft Excel 2010. When you right click on Pivot Table' field, you may find a ‘Show Values As’ context menu with all the calculations. This would help you to easily find out different calculations until you get exactly what you were looking for. So you can add same value fields to the Pivot Table multiple times.
Microsoft Excel 2010 add new calculations named 'Percentage of Parent Row Total' or 'Percentage of Parent Column Total', 'Percentage of Parent Total', 'Percentage Running Total in', 'Rank Smallest to Largest' or 'Rank Largest to Smallest'. This would provide easier calculations for complex data. These six calculations can be seen under the ‘Show As’ menu.
Microsoft Excel 2010 offers some visual total settings in Pivot Table options. Visual Totals implies that when one or more members are filtered what totals should be showing. If the Visual Totals is 'ON' then all totals would reflect the aggregation of only the members present and visible in the Pivot Table at that time. If it is 'OFF' all filtered items would count towards the aggregation of totals.
iYogi is the fastest growing online and remote tech support provider in the direct-to-consumers and small businesses sector. Our highly skilled and experienced tech experts available, 24x7x365 will provide the best issue resolution and customer satisfaction.
- Comprehensive support for Pivot Table in Microsoft Excel 2010
- Diagnosis & repair for your technologies
- Troubleshoot software errors
- Update drivers and security to protect against online threats
- Connect to Internet, devices, and peripherals
- Optimize your computer’s speed and performance.