O'Reilly logo

Excel 2013 All-in-One For Dummies by Greg Harvey

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

Chapter 2: Filtering and Querying a Data List

In This Chapter

arrow.png Understanding how to filter and query a data list

arrow.png Using AutoFilter to filter out unwanted data

arrow.png Filtering a list with custom criteria

arrow.png Filtering a list on font color, fill color, or cell icons

arrow.png Using Database functions to compute statistics from records that match your filter criteria

arrow.png 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 data list and load it with tons of data and quite another to get just the information that you need out of the list. How you go about extracting the data that’s important to you is the subject of this chapter. The procedure for specifying the data that you want displayed in an Excel data list is called filtering the data list or database. The procedure for extracting only the data that you want from the database ...

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