Pivot Table
Excel Pivot tables provide a quick way to categorize and present information in a logical way.
Say you have a large set of data covering different kinds of information.
This is typically called multivariate data.
In this table for example, we have sales data for different products, sold by various salesmen, across different regions.
We also have other data such as profit and loss, and all this data is spread across many months and years.
Let's say we want to know how many product units each salesmen sold across the various regions.
THEN, we need a Pivot Table.
Step 1. Click Insert, if it is not already selected.
Step 2. Click Pivot Table.
In the popup ensure that "New WorkSheet" is selected.
Step 3. Click Ok.
In the Pivot Table Field List:
Step 4. Select Region, because we want a region wise break up.
Step 5. Select Number of Units, because that's the data we actually want to see And also, ...
