Can you also give some tips and uses of the pivot tables with which you start your post ?
That would be most helpful.
Thank you
Emilio
@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.
10 Excel basic formulas and functions to supercharge your reporting skills.
in Excel Fundamentals & help forums
Posted
@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.