Microsoft Office Tutorials and References
In Depth Information
9 Creating Dynamic
Worksheets by Using
In this chapter, you will learn how to
✔ Analyze data dynamically by using PivotTables.
✔ Filter, show, and hide PivotTable data.
✔ Edit PivotTables.
✔ Format PivotTables.
✔ Create PivotTables from external data.
When you create Microsoft Excel 2010 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 the
point you’re trying to make.
One limitation of the standard Excel worksheet is that you can’t easily change how
the data is organized on the page. For example, in a worksheet in which each column
represents an hour in the day, each row represents a day in a month, and the body of
the worksheet contains the total sales for every hourly period of the month, you can’t
change the worksheet quickly so that it displays only sales on Tuesdays during the
There is an Excel tool with which you can create worksheets that can be sorted, filtered,
and rearranged dynamically to emphasize different aspects of your data. That tool is the