

This example is a good explanation of how. This example pivot table shows various categories of the state and county as a focal point, and then shows the population as well as the square miles of both land and water. I can be used to create reports and analysis within a large data set. Importance of a Pivot Table?Ī pivot table is very useful in excel, it allows an individual too easy and effectively create and organize a wide variety of data.


It allows use to specifically categorize small portions of data into separate units. A pivot table is somewhat like a report, however it gives you an interactive view of the data.
