HOW TO

What is a PivotTable?

Get more out of Excel with this powerful feature.

Microsoft Excel

Turn data into insights

VIEW

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.

    Microsoft Excel

    Turn data into insights

    VIEW