Pivot Tables

Use an Excel dataset that includes fields such as Region, Product Category, Sales Amount, and Date.

Create a pivot table to summarize sales by region and product category.

Use calculated fields to compute total and average sales.

Group data by quarter or month to identify time-based trends.