A pivot table is a tool for quickly summarising vast amounts of data. It sorts, counts, totals, or averages the data in the spreadsheet automatically and presents the results in another spreadsheet. It helps you save a lot of time. Allows us to connect other data sources to our Excel spreadsheet.