What are Pivot Tables?
https://www.computersprofessor.com/2016/05/what-are-pivot-tables.html
The pivot tables are used for large
data bases to extract the information in excel spread sheet thus pivot table arranges
the data in a quick manner. The rows and columns of the data and also be
rotated as a summary depending upon a criteria to provide the data after
processing.
The pivot table command is available
in the data menu and also it shows pivot chart table. For this select the data
base and drag each item of the data to a required place so that pivot forms.
Use of pivot table:-
Pivot tables are
used to compare long list of figures, several facts with figures, sorting
totals and subtitling of data.