A PivotTable in Excel is a table that summarizes and analyzes data. You can use a PivotTable to answer questions about your data, such as by grouping, filtering, and sorting.