Excel 2013 Pivot Tables by Poleg, Maayan -- Read -- Imperial Library of Trantor

Index

What is a Pivot Table? Basic Concepts Conditions to Create a Pivot Table Necessary conditions Desirable conditions Limitations of a pivot table Creating a Pivot Table Creating the table Source of Data Data Location Structure of the pivot table Filter Changing the data source Refreshing the pivot table Exercises Performing Calculations Changing Calculations Data display options Data Grouping Multivalued Report Calculated Field Calculated Item Exercises Changing The Report Structure Switching columns and rows Adding columns or rows Adding a page break between items Exercises Formatting Pivot Tables Structure Format The Timeline Exercises Design Tab Layout category Pivot table style options Quick design styles of pivot table Exercises Charts Adding a chart to an existing pivot table Simultaneously creating a pivot table and a chart Exercises Tips and Tricks Using Recommended PivotTables Quickly creating a pivot table Obtaining the data source Creating Tabs from Filters Filter Locations GetPivotData Sorting the field list Repeating the item labels Advanced Uses of Pivot Tables Finding unique records and duplicate records Human Resources Planning Cash Flow Profit and Loss

Chief Librarian: Las Zenow <zenow@riseup.net>
Fork the source code from gitlab.