Microsoft Excel 2019 Step by Step, First Edition

10 Use PivotTables and PivotCharts

In this chapter

• Analyze data dynamically by using PivotTables

• Filter, show, and hide PivotTable data

• Edit PivotTables

• Format PivotTables

• Create PivotTables from external data

• Create dynamic charts by using PivotCharts

Practice files

For this chapter, use the practice files from the Excel2019SBS\Ch10 folder. For practice file download instructions, see the introduction.

When you create Excel 2019 worksheets, you must consider how you want the data to appear when you show it to your colleagues. You can change the formatting of your data to emphasize the contents of specific cells, sort and filter your worksheets based on the contents of specific columns, or hide rows containing data that isn’t relevant to ...