a pivot table is a summary of a larger set of data. Its packaged in a chart & filtered, which makes it easier to pinpoint the data that’s relevant to what you are looking for.Pivot tables are used to summarize, sort, reorganize, group, count, total or average data stored in a database. Which is very helpful in a lot of jobs where you have to deal with large sets of data.The biggest setback with pivot tables is that they are difficult to make although newer versions of Excel make it pretty easy, by recommending that which pivot tables would fit into your needs.
