{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Lecture 23 - Excel 6 Filtering

Lecture 23 - Excel 6 Filtering - Computer Applications for...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
CS170 Computer Applications for Business Fall 2008 Instructor: Kristian Stout Lecture 23 Introduction to Spreadsheets Readings: Chapter 15
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Topics List: Spreadsheets Lecture 6 Finally: Data Filtering
Background image of page 2
Data Filtering Filtering is a quick and easy way to find and work with a subset of data in a range. A filtered range displays only the rows that meet the criteria you specify for a column. - (criteria: Conditions you specify to limit which records are included in the result set of a query or filter.)
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Data Filtering Unlike sorting, filtering does not rearrange a range. Filtering temporarily hides rows you do not want displayed. An example is extracting only the records from an address database where the Zip code is equal to 08901. Microsoft Excel provides two commands for filtering ranges: AutoFilter and Advanced Filter .
Background image of page 4
AutoFilter Excel includes an AutoFilter feature that makes finding groups of records conforming to criteria very easy. The group of records is then at your disposal for editing, copying, etc.
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}