@Emilio
Regarding use of pivot table
Suppose you have your data stored in the form of excel table. Then by inserting pivot table, you can analyse it or create some summary by using table's headers as columns or rows etc in pivot table as per your choice. Further, you can add slicers and use filters to see the pivot table responding to your choices. You can also add a pivot chart based on this.