define pivot table and why we use it in Microsoft excel?explain it briefly.
Pivot Table is a tool that summarise rows and column data in table format. it quickly do calculations (like average sum count avg percentage) to make reports in very less time.. it is especially used in case of large amount of data where normal sum average formula takes longer time for calculation