Pivot Tables Assignment Example | Topics and Well Written Essays - 500 words

Pivot Tables - Assignment Example Excel also allows you to generate charts from the data in your pivot table which can be very handy in comparisons. Similarly, Pivot Tables are interactive means of summarizing the data, allowing you to add or delete fields in the contingent (summary) tables. This is especially useful when a sample has to be chosen from a specific characteristic of the population which endows various other characteristic as well that are irrelevant. Pivot Tables are also dynamic which can automatically recalculate the data based on addition or elimination of new fields. This feature is really helpful in saving time and effort of the data collector. Pivot tables are also easy to change if the data from original source is changed. As a result, these tables are really important when the changes in data are quick and frequent. These tables can help you to keep your records updated at all times and can be used when the original data keeps on changing. Multiple worksheets are really handy in grouping and summarizing data. A collection of two or more worksheets is called group worksheet. In order to group two or more work sheets, you need to first click the tab of first worksheet, then you press and hold shift key and click the tab of the other worksheet that you want to group.