Excel PivotTables are a great way to summarize, analyze, explore, and present your data. PivotTables let you easily view data from different angles. You can have Excel recommend a PivotTable, or you can create one manually.

Two-dimensional Pivot Table. If you drag a field to the Rows area and Columns area, you can create a two-dimensional pivot table. First, insert a pivot table. Next, to get the total amount exported to each country, of each product, drag the following fiel

A Pivot Table is a summary of a large dataset that usually includes the total figures, average, minimum, maximum, etc. let's say you have a sales data for different regions, with a pivot table, you can summarize the data by region and find the average