Chapter 38
Using PivotTables and slicers to describe data
Questions answered in this chapter:
How can I use a PivotTable to summarize grocery sales at several grocery stores?
What PivotTable layouts are available in Office 365?
Why is a PivotTable called a PivotTable?
How can I easily change the design of a PivotTable?
How can I easily change the format of a field in a PivotTable?
How can I collapse and expand fields?
How do I sort PivotTable fields?
How do I filter PivotTable fields?
How do I use a PivotChart to summarize a PivotTable?
How do I use the Reports Filter section of the PivotTable?
How do PivotTable slicers work?
How do I add blank rows, hide subtotals, or modify empty cells in a PivotTable?
How do I apply conditional formatting ...
Get Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
