How to create an Excel pivot table?
This tutorial explains how to create an Excel pivot table step by step.
The main steps are to prepare your table.
Select the entire table with the data to be analyszed.
Then go to the Insert tab and click on Pivot Table.
Select the existing worksheet to insert the pivot table.
The pivot tble is available, simply select amongst these fields:
Salesperson
Country
Year
SalesAmount
And that's it, now you can play with moving the fields to change the point of view and the aggregation of data.
Full text article with screenshots is available here:
https://expert-only.com/en/excel-tips...