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.
- Excel Graphics and Charts Dress your Excel data up by adding graphics and charts. Uncover the tools, tips, and guidance you need in this handy volume.
- Timesheet Templates Ready-to-use templates allow you to start tracking employee time today. Available in a number of time-saving formats.
- ExcelTips Premium Twice the tips every week, great graphics, plus huge discounts on ExcelTips archives and e-books. Step up to a Premium subscription!
- More e-books>>
Shipping Info
If you order a product that requires shipping, please note that all Tips.Net shipping is done via US Mail. Shipments will be sent either First Class or Media Mail, as appropriate.
We try very hard to ship orders by the next business day after receipt. Most of the time we are successful, but not always.
Our goal is to keep shipping and handling costs as low as possible. The cost will vary, depending on the number of shippable items you order. For example, if you order a single CD item, the cost will be approximately $4.34. Each additional CD item in the same order will add approximately $0.65 to the shipping and handling costs. Thus, two CD items would be $4.99, three would be $5.64, etc.
If you have any questions about shipping or handling charges, please feel free to contact us at 801-607-2035 prior to placing your order.
ExcelTips: Filters and Filtering
ExcelTips: Filters and Filtering
includes 55 information-packed pages that will help you learn exactly how to work with files and filters in Excel.
The following is the Table of Contents:
Introduction
- Need More Tips?
- A Special Note of Thanks
- Sharing this E-Book
General Filtering Information
- Limits to Filtering
- Recalculating when Filtering
- Sorting or Filtering by Conditional Format Results
AutoFiltering
- Using AutoFiltering
- Turning Off AutoFiltering
- Toggling AutoFilter
- Setting Up Custom AutoFiltering
- More Than Two Conditions for Custom AutoFiltering
- Quickly Identifying Applied AutoFilters
- Changing AutoFilter Drop-Down Arrow Colors
- AutoFilter Drop-Down List Font Sizes
- Increasing the AutoFilter Drop-Down Limit
- Macro Fails after AutoFilter
Advanced Filtering
- Understanding and Using Advanced Filtering
- Performing Calculations While Filtering
- Filtering Columns for Unique Values
- Copying the Results of Filtering
Using Filters with Real-World Data
- Extracting Targeted Records from a List
- Counting Displayed Cells
- Getting a Count of Unique Names
- Counting Records Matching Multiple Criteria
- Looking Up Names when Key Values are Identical
- Comparing Lists for Duplicates
- Finding Differences Between Lists
- Hiding Rows Based on Two Values
- Deleting Every X Rows
- Conditionally Deleting Rows
- Deleting Old Data from a Worksheet
- Segregating Numbers According To Their Sign
- Calculating Averages by Date
- Filtering to a Date Range in the Past
- Copying Comments when Filtering
- Excluding Zero Values from a PivotTable
- Putting Addresses on State-Specific Worksheets
- Automatically Creating Charts for Individual Rows in a Data Table
- Showing Filter Criteria on a Printout
| Description | CD | Download | |||
|---|---|---|---|---|---|
| ExcelTips: Filters and Filtering | $29.99 |  |
$24.99 |  |
(1.0 MB) |
You can also order ExcelTips: Filters and Filtering by calling our order line: 801-607-2035.