|
|
 |
|
|
|
Microsoft® Office XP Step by Step
|
|
|
Author
|
|
Perspection, Inc., Online Training Solutions, Inc., Curtis Frye, Kri..
|
|
|
Pages
|
784
|
|
Disk
|
1 Companion CD(s)
|
|
Level
|
Beg/Int
|
|
Published
|
07/11/2001
|
|
ISBN
|
9780735612945
|
|
Price
|
$44.99
To see this book's discounted price, select a reseller below.
|
|
|
|
|
|
|
|
|
Chapter 8: Focusing on Specific Data Using Filters
Chapter 8 Focusing on Specific Data Using Filters
After completing this chapter, you will be able to:
- Limit the data that appears on the screen.
- Perform calculations on filtered data.
- Define 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 ten days of sales in a month or slow-selling product lines that you may need to reevaluate. In Excel, you have a number of powerful, flexible tools with which you can limit the data displayed in your worksheet. Once your worksheet displays the subset of your data that you need to make a decision, you can perform calculations on that data. You can discover what percentage of monthly sales were made up by the ten best days in the month, find your total sales for particular days of the week, or locate the slowest business day of the month.
Just as you can limit the data displayed by your worksheets, you can limit the data entered into them as well. Setting rules for data entered into cells lets you catch many of the most common data entry errors, such as entering values that are too small or too large, or attempting to enter a word in a cell that requires a number.
In this chapter, you’ll learn how to limit the data that appears in your worksheets, perform calculations on the remaining data, and limit the data that can be entered into specific cells.
This chapter uses the practice files Filter, Calculations, and Validate that you installed from this book’s CD-ROM. For details about installing the practice files, see "Using the Book’s CD-ROM" at the beginning of this book.
Next
Last Updated: Saturday, July 7, 2001 |
