Pivot Chart in Excel
Pivot Table These are tables which summarize and allow you to count , sum , and average among other calculations according to the data you require.When you know how to do this it becomes even easier to crush data and create reports that your business needs. A Pivot Table is a table of grouped values that aggregates the individual items of a more extensive table within one or more discrete categories.This summary might include sum, averages or other statistics which the pivot table groups together using a chosen aggregation function applied to the grouped values. 1) What is a pivot table used for. Ans- A pivot table is an interactive way to quickly summarize large amounts of data. You can use a pivot table to analyze numerical data in detail and answer unanticipated questions about your data. A pivot table is especially designed for: querying large amounts of data in many user friendly ways. 2) What is pivot table and its advantages. Ans- Pivot table are worksheet tables t...