Use pivot tables in Excel for stronger data analysis. This Excel pivot table tutorial also helps you summarize data.
One of the best things about a PivotTable is that it lets you pivot the data in order to look at it in a different way. This allows you to answer multiple questions and even experiment with the data to learn new things about it.
In our example, we used the PivotTable to answer the question What is the total amount sold by each salesperson? Now we'd like to answer a new question, What is the total amount sold in each month? We can do this by changing the row labels.
So far, our PivotTable has only shown one column of data at a time. To show multiple columns, we'll need to add column labels.