Chapter 6. Focusing on Specific Data Using Filters

Chapter at a Glance

Focusing on Specific Data Using Filters

In this chapter, you will learn to:

Limit the data that appears on your screen.

Manipulate list data.

Define a valid set of values for a range of cells.

Microsoft® Office Excel® 2007 enables you to manage huge data collections, but storing more than 1,000,000 rows of data doesn’t help you make business decisions unless you have the ability to zero in on the most important data in a worksheet (whether that data represents the 10 busiest days in a month or low revenue that you might need to reevaluate). Office Excel 2007 offers a number of powerful and flexible tools with which ...

Get Microsoft® Office Excel® 2007 Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.