define pivot table and why we use it in Microsoft excel?explain it briefly.
Pivot Tables are one of the most powerful and useful tools in Excel. They will save you a lot of time by allowing you to quickly summarize large amounts of data into a meaningful report.