Excel’s PivotTable feature ... dynamic table. By mastering the art of creating PivotTables from multiple data sources, you can unlock valuable insights and make data-driven decisions with ...

Again, you don’t have to take this step but it’s recommended if you want to add more rows of data later and make it easier to update your pivot table.

To build the demonstration PivotTable using the data set in Figure A, do the following: Click anywhere inside the data set and then click the Insert tab. In the Tables group, click PivotTable.