Tips.Net

Powerful Excel e-Books

Tips.Net provides a variety of ExcelTips e-books. Solve a pesky problem, learn a new skill, or enhance your existing knowledge. Tips.Net e-books provide something for everyone!

  • ExcelTips: Filters and Filtering Start working with large amounts of data, and you'll find filters invaluable to your work. Here's how to use both types of filters provided by Excel.
  • PivotTables for the Faint of Heart Get the scoop on how PivotTables analyze huge amounts of data. Serious info for serious Excel users!
  • ExcelTips Archives Full Excel information at your fingertips! The ExcelTips Archives provide all you need to become an Excel expert. Available on CD-ROMs or convenient downloads.
  • ExcelTips: The Macros The best of ExcelTips, with a macro focus. Learn the basics of macro programming and get a great macro "cookbook."
  • More e-books>>
ExcelTips: Filters and Filtering

ExcelTips: Filters and Filtering

You already know that you can use Excel for much more than simple numbers—you can use it to collect and keep track of all sorts of information. In fact, it is possible to collect so much information in your worksheets that it is difficult to manage. Wouldn't it be great if you could manage your data in smaller, easier-to-get-your-head-around chunks? This is where filtering comes into play.

Filtering your data means displaying only a part of it. You provide the criteria that Excel should use to determine what gets displayed, and Excel helpfully displays just that data. Filtering is especially useful if you have a large data list and you want to work with only a subset of the records in that list.

ExcelTips: Filters and Filtering provides all the details necessary to let you manage your large sets of data with confidence and ease. In these information-packed pages you'll discover how to use the two types of filters provided by Excel: AutoFilters and advanced filters. You are introduced to the necessary topics in bite-sized chunks, pulled from past issues of ExcelTips. You can learn at your own pace, exactly the way you want.

Your copy of ExcelTips: Filters and Filtering comes in two formats—Microsoft Word and Adobe Acrobat—and you automatically get them both. Including both formats allows you to easily use the information in whatever format you desire. Both formats allow you to enjoy the following features:

  • The ability to view, search, and print the book.
  • Screen shots that illustrate what you see in Excel as you follow the step-by-step instructions.
  • The ability to select and copy sections of text, such as macro code.
  • Hyperlinks to internal content (in the book itself) and referenced resources on the Web.

Get Adobe Acrobat Reader To use the Microsoft Word version of the e-book, you just need one of the common versions of Word (97 through 2007). If you want to use the Adobe Acrobat (PDF) version, you need to either have Acrobat or the free Adobe Acrobat Reader. Many computer systems already have the reader installed. If you do not, you can get it free, directly from Adobe.

To get an idea of the value packed into ExcelTips: Filters and Filtering, take a look at the complete table of contents. ExcelTips: Filters and Filtering provides a valuable resource for focused information that can't be matched by any other single source or computer book.

How much does this valuable resource cost you? You can download your own copy of this valuable information for the low price of only $24.99. Place your order today!

Description CD Download
ExcelTips: Filters and Filtering $29.99 Buy on CD $24.99 Buy via download (1.0 MB)

You can also order ExcelTips: Filters and Filtering by calling our order line: 801-303-7350.