Microsoft® Office System Step by Step -- 2003 Edition

Chapter 8. Focusing on Specific Data Using Filters

Chapter 8 at a Glance

In this chapter you will learn to:
✓	Limiting the Data That Appears on the Screen.
✓	Performing Calculations on Filtered Data.
✓	Defining a Valid Set of Values for a Range of Cells.

An important aspect of working with large amounts of data is the ability to zero in on the most important data in a worksheet, whether that data represents the best 10 days of sales in a month or slow-selling product lines that you might need to reevaluate. In Microsoft Office Excel 2003, you have a number of powerful, flexible tools with which you can limit the data displayed in your worksheet. Once your ...