A Pivot Table is an interactive way to quickly summarize large amounts of data. You can use a Pivot Table to analyse numerical data in detail, and answer unanticipated questions about your data. Moving rows to columns or columns to rows ( or “pivoting”) to see different summaries of the source data.
HOW TO CREATE PIVOT TABLE IN EXCEL
1. Click any single cell inside the data set.
2. On the Insert tab, in the Tables group, click Pivot Table.
A new dialog box will appear
3. The default location for a pivot table is New worksheet
4. Select data for the pivot table.
5. Click Ok