It is a powerful feature to group your data in Excel. It is a specific set of rows and columns in a spreadsheet. You can have multiple tables on the spreadsheet. Pivot Table allows grouping by any column and using advanced calculations on them. In the Pivot table, you can rotate the data in the table to view it from a different perspective.