18. Pivot Tables

  1. John Walkenbach

Published Online: 1 NOV 2011

DOI: 10.1002/9781118257630.ch18

Excel® 2010 Formulas

Excel® 2010 Formulas

How to Cite

Walkenbach, J. (2010) Pivot Tables, in Excel® 2010 Formulas, Wiley Publishing, Inc., Hoboken, NJ, USA. doi: 10.1002/9781118257630.ch18

Publication History

  1. Published Online: 1 NOV 2011
  2. Published Print: 10 MAY 2010

ISBN Information

Print ISBN: 9780470475362

Online ISBN: 9781118257630

SEARCH

Keywords:

  • pivot tables;
  • Excel;
  • worksheet;
  • database;
  • table

Summary

This Chapter contains sections titled:

  • About Pivot Tables

  • A Pivot Table Example

  • Data Appropriate for a Pivot Table

  • Creating a Pivot Table

  • More Pivot Table Examples

  • Grouping Pivot Table Items

  • Creating a Frequency Distribution

  • Creating a Calculated Field or Calculated Item

  • Filtering Pivot Tables with Slicers

  • Referencing Cells within a Pivot Table

  • Another Pivot Table Example

  • Producing a Report with a Pivot Table