Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition

Chapter 45 Using pivot tables and slicers to describe data

Questions answered in this chapter:

• What is a pivot table?

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

• What pivot table layouts are available in Excel 2019?

• Why is a pivot table called a pivot table?

• How can I easily change the format in a pivot table?

• How can I collapse and expand fields?

• How do I sort and filter pivot table fields?

• How do I summarize a pivot table by using a pivot chart?

• How do I use the Reports Filter section of the pivot table?

• How do pivot table slicers work?

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

• How do I apply conditional formatting to a pivot table?

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