Excel All-in-One For Dummies

Chapter 2

Filtering and Querying a Table

IN THIS CHAPTER

Understanding how to filter and query a table

Using AutoFilter to show only the data you want to see

Filtering a table with custom criteria

Filtering a table on font color, fill color, or cell icons

Using database functions to compute statistics from records that match your filter criteria

Performing external data queries with text files, web pages, and data files kept in other database sources

It’s one thing to set up a table and load it with tons of data and quite another to get just the information that you need out of that table. How you go about extracting the data that’s important to you is the subject of this chapter. The process for specifying the subset of the data that you want displayed in an Excel table is called filtering the table. The process for extracting only the data that you want from the table is called ...