O'Reilly logo

Picture Yourself Learning Microsoft® Excel® 2010 by Laurie Ulrich Fuller, Deidre Hayes, Jeffery A. Riley

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Exploring Special Filters

YOU’VE LEARNED HOW TO PERFORM a simple filter on your data, but Excel provides even more ways to filter your data. Use the AutoFilter feature to find missing data in your worksheet, to display a list of the 10 best sales districts, and even to see which invoices are due to be paid next month.

Searching for Blank Cells

Suppose you are the school administrator in this example and you are responsible for accurately maintaining this database of grades. The three teachers submitted their data to you on Friday, but some of the data was missing. You decide to enter the data you have and leave blanks where the data was missing and plan to fill in the missing data on Monday.

You can scroll through the database searching for ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required