define pivot table and why we use it in Microsoft excel?explain it briefly.
A pivot table is a table of statistics that summarize the data of a more extensive table such as from a database, spreadsheet, or business intelligence program. This summary might include sums, averages, or other statistics, which the pivot table groups together in a meaningful way.