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 ...