Microsoft Excel Step by Step (Office 2021 and Microsoft 365)

10. Create PivotTables and PivotCharts

In this chapter

• Analyze data dynamically in PivotTables

• Filter, show, and hide PivotTable data

• Edit PivotTables

• Format PivotTables

• Create dynamic PivotCharts

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

A limitation of the standard Excel worksheet is that you can’t easily change how the data is organized on the page. Fortunately, there is an Excel tool with which you can easily display, sort, filter, ...