An Advance excel pivot table is a statistics as well as a reporting tool that summarizes, analyzes, and reorganizes the data in a spreadsheet or database table to obtain a desired and meaningful report. The tool does not change the spreadsheet or database itself, it simply “pivots” or turns the data to view it from different perspectives.
Tips & Tricks of Pivot Table
Table of Contents :
How to create a Pivot Table
No blank row and column in the data source.
Preserve Cell Formatting & disable auto-width in Pivot Table
Hide/Unhide subtotals and grand totals
Turn off/on (field list/ buttons/ field headers)
Insert slicer and Timeline
one slicer for all pivot table
creating many pivot table using the filter pane option
Add Different values of the same field
show values as Aggregation
# How To Create Pivot Table
1.Click on the insert tab.
2.Select pivot table option.
3.Select option table or range.
4.If we create a pivot table on a new worksheet then select the new worksheet option otherwise select the existing worksheet and give the location of data.
5.Press ok to create a pivot table.For complete knowledge about Pivot Table visit here:
https://www.cetpainfotech.com/blogs/tips-and-tricks-of-advanced-excel-pivot-table/
