define pivot table and why we use it in Microsoft excel?explain it briefly.
pivot table helps us to summarize the rows and column of data into spreadsheet to obtain a desired report. Pivot tables summarize data, they can be used to find unique values in a field.