Tip: change your data set to a table before you insert a pivot table.
On the Analyze tab, in the Data group, click Change Data Source.
Insert a Pivot Table | Drag fields | Sort | Filter | Change Summary Calculation | Two-dimensional Pivot Table Pivot tables are one of Excel's most powerful features. On the Insert tab, in the Tables group, click Pivot Table.
A pivot table allows you to extract the significance from a large, detailed data set. Order ID, Product, Category, Amount, Date and Country.
It’s ideal for calculating and summarizing information that you can use to break down large tables into just the right amount of information you need.