A Pivot Table is a powerful tool in Excel used to summarize, analyze, explore, and present data. It allows you to extract meaningful insights from large datasets by organizing data in a tabular format.

Key Features of Pivot Tables

1. Summarizing Data: Aggregates data using functions like sum, average, count, etc.
2. Dynamic Reports: Adjusts automatically when the source data is updated.
3. Sorting and Filtering: Allows sorting and filtering for easy data analysis.
4. Grouping: Groups data based on categories or custom ranges.
5. Calculated Fields: Enables custom calculations on fields within the Pivot Table.

Example

Procedure to create Pivot Table from above data:

• Select your dataset.
• Go to the Insert tab → Click on PivotTable.
• Choose whether to place the Pivot Table in a new or existing worksheet.
• Drag fields to the Rows, Columns, Values, and Filters areas in the Pivot Table Field List.

Configuration of Pivot Table:

• Rows: Department
• Columns: Month
• Values: Sum of Sales Amount

Final Output:

Practice Question:

Create a Pivot Table to find out:

1. Total Revenue by Region.
2. Units Sold by Category.