Chapter 43. Using PivotTables and Slicers to Describe Data

Questions answered in this chapter:

  • What is a PivotTable?

  • How can I use a PivotTable to summarize grocery sales at several grocery stores?

  • What PivotTable layouts are available in Excel 2010?

  • Why is a PivotTable called a PivotTable?

  • How can I easily change the format in a PivotTable?

  • How can I collapse and expand fields?

  • How do I sort and filter PivotTable fields?

  • How do I summarize a PivotTable by using a PivotChart?

  • How do I use the Report Filter section of the PivotTable?

  • How do Excel 2010 slicers work?

  • How do I add blank rows or hide subtotals in a PivotTable?

  • How do I apply conditional formatting to a PivotTable?

  • How can I update my calculations when I add new data?

  • I work for a small travel agency ...

Get Microsoft® Excel® 2010: Data Analysis and Business Modeling now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.