ExcelTips: Filters and Filtering (Table of Contents)

ExcelTips: Filters and Filtering includes 126 information-packed pages that will help you learn exactly how to work with filters in Excel. The following is the Table of Contents:

Introduction

• What the Heck is AutoFiltering?
• Something for the Newest Versions of Excel
• A Word about Versions
• Need More Tips?
• A Special Note of Thanks
• Sharing this E-Book

Simple Filtering

• Using Filtering
• Toggling Filtering
• Setting Up Custom Filtering
• More Than Two Conditions for Custom Filtering
• Clearing Only Filtering Settings
• Quickly Identifying Applied Filters
• Changing the AutoFilter Drop-Down Arrows
• Filter Drop-Down List Font Sizes
• Dealing with Text Length Limits and AutoFilter Drop-Down Lists
• Separating Cells Based on Text Color
• Sorting or Filtering by Conditional Format Results
• Removing Filters and Unhiding Rows and Columns on Multiple Worksheets
• Not All Rows are Filtered
• Macro Fails after Filter

Tables and Filtering

• Understanding Tables
• Differences between Tables and Named Ranges
• Is It Worth Converting Data to a Table?
• Filtering Table Information
• Entering a Date in a Filter
• Copying Filtered Information from a Table
• Non-PivotTable Slicers and Timelines

Advanced Filtering

• Understanding and Using Advanced Filtering
• Performing Calculations while Filtering
• Filtering Columns
• Filtering Columns for Unique Values
• Copying the Results of Filtering
• Hiding Graphics when Filtering
• Images Pile Up when Filtering

Applying the FILTER Function

• Filtering Based on Comparing Two Cells
• Deriving a List of Albums by a Music Artist
• Averaging Based on Multiple Criteria
• Deleting All Rows Except for the End of Month
• Values Beginning with a Specific Letter or Digit

Using Filters with Real-World Data

• Recalculating when Filtering
• Extracting Targeted Records from a List
• Numbering Filtered Rows
• Counting Filtered Rows
• Counting Displayed Cells
• Getting a Count of Unique Names
• Counting Names Based on Two Criteria
• Counting Occurrences of Words
• Finding Boolean Values
• Counting Records Matching Multiple Criteria
• Using a Filtered Value in a Formula
• Looking Up Names when Key Values are Identical
• Filtering for Purchases within a Given Month
• Summing Filled Cells
• Summing Cells Using a Particular Background Color
• Filter and Use SUBTOTAL
• Revamp Your Data
• Use a Macro
• Comparing Lists for Duplicates
• Checking for Duplicate Rows Based on a Range of Columns
• Extracting Numbers within a Range
• Finding Rows with Values in Two Columns
• Hiding Rows Based on Two Values
• Deleting Every X Rows
• Conditionally Deleting Rows
• Deleting Old Data from a Worksheet
• Deleting Rows before a Cutoff Date
• Column Formatting Based on a Filter
• Printing Rows Conditionally
• Segregating Numbers According to Their Sign
• Calculating Averages by Date
• Averaging Values for a Given Month and Year
• Filtering to a Standard Deviation
• Filtering to a Date Range in the Past
• Filtering for Comments (Notes)
• 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
• Getting Rid of Fixed Objects
• Enabling Filters by Default
• Clearing Only Filtering Settings
• Removing Filters and Unhiding Rows and Columns on Multiple Worksheets
• Showing Filter Criteria on a Printout

Description	Download	CD
ExcelTips: Filters and Filtering (for Excel 2007, 2010, 2013, 2016, 2019, 2021, and Microsoft 365 users)	ISBN 978-1-61359-524-4 (1.8 MB) $29.99	ISBN 978-1-61359-525-1 (126 pages) $39.99

You can also order ExcelTips: Filters and Filtering by calling our order line: 307-200-0450.