To make a pivot table in Excel, you first need to select the data that you want to include in the table. Once the data is selected, go to the Insert tab and click on the PivotTable button. This will open up a new worksheet where you will create the table.
To create the table, you first need to decide what you want to use as the row and column headings. These can be the actual column and row headings from the data sheet, or you can create new headings.
Next, you need to determine what you want to use as the values in the table. This can be the actual data, or you can use calculations. For example, you could use the total sales for each product category.
Once you have decided on the row and column headings and the values, you need to drag and drop the appropriate cells into the pivot table fields. The table will automatically update with the new data.
You can also filter the data in the pivot table to see only the data that you are interested in. To do this, click on the filter icon in the column heading. This will open up a menu where you can select the criteria that you want to use.