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 DocumentRight 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 DocumentRight 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. The records are still part of the original database, it's just that
Background image of page 5

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

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

This note was uploaded on 02/07/2011 for the course COMP 178 taught by Professor Stout during the Fall '08 term at Rutgers.

Page1 / 25

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

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online