Excel Filters and Filtering
Summary: Excel provides two ways to filter your data so that only what you want to see is displayed. Discover how filtering works and how you can apply it to your needs.
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.
Our Excel Filters and Filtering e-books provide all the details necessary to let you manage your large sets of data with confidence and ease. In these information-packed pages you 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.
There are four versions of Excel Filters and Filtering available. You can choose the version that is right for you, based on the version of Excel you are using. (You can click one of the titles to see a complete table of contents for that version.)
- Excel 2016 Filters and Filtering
- Excel 2013 Filters and Filtering, second edition
- Excel 2010 Filters and Filtering, fourth edition
- Excel 2007 Filters and Filtering, fourth edition
Can't decide which version to get? Perhaps you use multiple versions of Excel or you are responsible for users who have different versions. If this describes you, then you really could benefit by having the Excel Filters and Filtering Ribbon Pack. It includes all four versions of the e-books, for users of Excel 2007, 2010, 2013, and 2016. This special provides four versions of the e-book for the price of two versions. (See additional information below, in the ordering area.)
Regardless of which version of Excel Filters and Filtering you choose, you get the e-book 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.
To use the Microsoft Word version of the e-book, you just need one of the common versions of Word. 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.
Each of our Excel Filters and Filtering e-books provides a valuable resource for focused information that can't be matched by any other single source or computer book. And our Ribbon Pack provides the absolute best breadth of information that you can find.
How much does this valuable resource cost you? You can download your own copy of Excel Filters and Filtering, in the version that is right for you, for the low price of only $19.99. (That's 25% less than the previous edition!) Place your order today!
You can also order any of the Excel Filters and Filtering titles by calling our order line: 307-200-0450.