In the daily work life, Excel Pivot table helps to Summarize the Large volume of data as per our requirement and makes our life easy.
Definition: A pivot table is a table of statistics that summarizes the data of a more extensive table (such as from a database, spreadsheet, or business intelligence program). This summary might include sums, averages, or other statistics, which the pivot table groups together in a meaningful way.
Here are 5 simple steps to create a Pivot Table with the Images:
- Select the Large volume of data for which you want the Pivot Table (Shortcut – CTRL+A)
2. Create Pivot with Shortcut –ALT+N+V– the destination you can choose either in the new Worksheet or in the same existing Worksheet. I am taking in the same sheet – place the cursor in the same sheet in the starting cell from where you want to see the table
3. Select all the parameters of Filters-Overall Filter,Rows-Data you want to see in rows, Columns-Data to get in columns, Values-which numbers to want to take.
4. If you want to see them in different layouts- go to- Design>report Layout, you can use all the tabs in the design main tab to customize your pivot summary.
START DOING and EXPLORE MORE!!