Pivot Table
This blog is intended to provide you the knowledge about most important and widely used feature known as Pivot Table which is a table of statistics that summarizes the data of a more extensive table. This summary might include sums, averages, or other statistics, which the Pivot Table groups together in a meaningful way that can be used for analysis and presentation. To access PivotTable, following steps are available: Go to Insert ribbon and Choose Pivot Table option. Press keyboard shortcut key Alt + N + V. Arguments for creating PivotTable Choose the data that you want to analyze: It indicates to select the source data table/range which is considered to create the Pivot Table. Choose where you want the PivotTable report to be placed: It indicates to select the cell location where the PivotTable is pasted. ...