In this Microsoft Excel tutorial video you will learn a most powerful function in Excel which Called Pivot Table. Let’s learn what is the Pivot Table. A pivot table is a data summarization tool that is used in the context of data processing. Pivot tables are used to summarize, reorganize, group, count, sort, total or average data stored in a database. It allows its users to transform columns into rows and rows into columns. It allows grouping by any data field. Pivot tables are the perfect solution when you need to summarize and analyze large amounts of data. In just a few clicks, you have access to a whole new set of information. With Pivot Table you can make a dynamic MIS Reports also. Pivot Table function is the most powerful tool of Microsoft Excel. Pivot Table is available in ms excel 2007, excel 2010, excel 2013, excel 2016, excel 2019 version.