What is a PivotTable?
Get more out of Excel with this powerful feature.
Turn data into insights
One of Microsoft Excel’s most powerful features is the PivotTable, which lets you quickly take different views of the same set of data. Using PivotTables, you can answer a slew of questions without having to create complicated formulas and format their output.
Consider a table of data showing delivery drivers’ daily mileage:
You could figure out how many miles Susan drove, or which region had the most miles, by creating a series of formulas. But a PivotTable lets you answer both questions – and many others – with less work. Here’s how.