Microsoft® Excel® 2010: Step by Step

Chapter 5. Focusing on Specific Data by Using Filters

Chapter at a Glance

In this chapter, you will learn how to
✓	Limiting Data That Appears on Your Screen.
✓	Manipulating Worksheet Data.
✓	Defining Valid Sets of Values for Ranges of Cells.

With Microsoft Excel 2010, you can manage huge data collections, but storing more than 1 million rows of data doesn’t help you make business decisions unless you have the ability to focus on the most important data in a worksheet. Focusing on the most relevant data in a worksheet facilitates decision making, whether that data represents the 10 busiest days in a month or revenue streams that you might need to reevaluate. ...