In this chapter you will learn to:
✓ Create dynamic data lists with PivotTables.
✓ Edit PivotTables.
✓ Create PivotTables from external data.
An important consideration when you create your Microsoft Excel worksheets is 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 the point you’re trying to make.
One limitation of the standard Excel worksheet is ...