What is a PivotTable?

A PivotTable summarizes a selection of data to make it more meaningful. To get started, download the Make your first PivotTable template and follow the tutorial.

1. On the File tab, select New and search for pivottable in the template field.

   

2. Select Make your first PivotTable and choose Create.

For more info, see Overview of PivotTables and PivotCharts.

A PivotTable summarizes a selection of data to make it more meaningful. To get started, download the Make your first PivotTable template and follow the tutorial.

1. On the File tab, select   New and search for pivottable in the upper right search box.

   

2. Select Make your first PivotTable and choose Create.

For more info, see Overview of PivotTables and PivotCharts.

A PivotTable summarizes a selection of data to make it more meaningful. To get started, download the Make your first PivotTable template in the Excel Desktop app and follow the tutorial.

• To open the desktop app, at the top of the ribbon, select Editing > Open in Desktop App.

  

Don't have the Excel desktop app? Try or buy Microsoft 365.

1. In Excel desktop, on the File tab, select New and search for pivottable in the template field.

2. Select Make your first PivotTable, choose Create, and follow steps.