Log In
Or create an account -> 
Imperial Library
  • Home
  • About
  • News
  • Upload
  • Forum
  • Help
  • Login/SignUp

Index
Chapter 1: Introduction Who is this Book Aimed For? Version Used Structure of the Book How to use this Book Chapter 2: Introduction to Pivot Tables What is a Pivot Table? Why use Pivot Tables? Pivot Table Layout Displaying the Pivot Table Fields Pane Structure of the Data Source Updating Pivot Tables Chapter 3: How to Create a Basic Pivot Table Specifying the Source Data Specifying the Location of the Pivot Table Adding Fields to the Pivot Table Reorganising the Pivot Table Refreshing the Pivot Table Changes to the Data Source Changing the Calculation in a Pivot Table Chapter 4: Customising the Pivot Table Changing Pivot Table Styles Create a New Pivot Table Style Pivot Table Style Options Applying Number Formatting Move Field Position in the Pivot Table Field Pane Change Pivot Table Headings Changing Report Layout Repeat Item Labels Displaying Grand Totals Displaying Subtotals Inserting Blank Rows in the Pivot Table Replace Blank Cells with Zeros in a Pivot Table Chapter 5: Sorting, Filtering and Grouping Sorting a Pivot Table Filtering a Pivot Table Advanced Filtering Clearing a Filter Grouping Pivot Table Items Chapter 6: Calculated Fields and Calculated Items What are Calculated Fields and Calculated Items? How to Create a Calculated Field How to Create a Calculated Item Chapter 7: Referencing Cells in a Pivot Table What is the GETPIVOTDATA Function? Turning off the GETPIVOTDATA Function Chapter 8: Using Slicers in Pivot Tables How to Insert Slicers How to Clear Slicers Chapter 9: Creating Pivot Charts How to Create a Pivot Chart Resizing the Pivot Chart Formatting the Pivot Chart Changing Chart Type Filtering Pivot Charts Changing the Structure of the Pivot Chart Additional Resources More Books by Excel Master Consultant
  • ← Prev
  • Back
  • Next →
  • ← Prev
  • Back
  • Next →

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

This is a mirror of the Tor onion service:
http://kx5thpx2olielkihfyo4jgjqfb7zx7wxr3sd4xzt26ochei4m6f7tayd.onion