One typical application for Excel is to find information in a list of data. The simplest way to do this is filtering the data so that Excel does the work of finding the pertinent information for you ...

People use the multipurpose Microsoft Excel for everything from logging scientific spreadsheets rife with calculations and charts, to tracking quarterly sales of widgets, to cataloging the books in ...

An Excel 2007 spreadsheet may contain very large quantities of data. Individual sections may be unimportant. For example, a sheet that lists your company's sales figures may include last year's ...

Filters are used to create subsets of data in a Microsoft Excel worksheet. The "AutoFilter" or "Sort and Filter" function in Excel allows you to create views of data matching your specified criteria.

When you’re working on a large worksheet it’s easy to lose track of where important details are. As soon as the worksheet grows beyond screen size, valuable information can disappear out of view.