excel 14
An Excel Pivot Table Allows you to extract the relevant from the large data set dragging fields, filtering and sorting he data, and changing summary calculations. Pivot tables can:
- Group items
- Create Multi-Level Pivot Tables
- Create a Frequency Distribution
- Create a Pivot Chart
- Refresh a Pivot Table (Pivot Tables are not automatically updated)
- Calculate an item in a Pivot Table
- Insert a calculated item in a Pivot Table.
the steps and instructions in the attachment below.(plaese read it)