Microsoft and Excel are registered trademarks of the Microsoft Corporation in the United States and/or other countries.




Contents


Why Would I Want To Use a PivotTable?


Creating PivotTables


Report Filters


Refreshing the PivotTable When Opening a File


Viewing the Details


Formatting Values


Summarize Data By…


Creating Multiple PivotTables from Report Filters


Grouping Date Data


Overriding Labels


Finding the Top or Bottom Values


Previous Page Next Page Page 2 of 31