Subscribe
Tutorial search

Excel Filter Tutorials


Sort by:
Pivot Tables in Excel
Pivot Tables in Excel
Pivot tables are one of the most versatile and powerful tools available in Excel. They allow you to display data in a table format with multiple filters, and the ability to easily add or remove rows and columns.
Difficulty:
Basic Data List Filtering
Basic Data List Filtering
This technique covers how to use AutoFilter to do basic and custom filtering of the data list.
Difficulty:
Display AutoFilter Criteria
Display AutoFilter Criteria
Use a custom function to display the criteria used for any column in a table with an AutoFilter applied.
Difficulty:
Manipulate Data with the Advanced Filter
Manipulate Data with the Advanced Filter
If you are familiar with Excel's AutoFilter tool, you also are familiar with its limitations. If you require extensive data manipulation, using Excel's Advanced Filter tool is the way to go.
Difficulty:
Sort And Filter A Mailing List
Sort And Filter A Mailing List
The List Wizard can help you create, sort, and analyze a mailing list. To learn how, recreate the Adventure Works mailing list used in this project or follow the process using a list of your own.
Difficulty:
Filter numbers, texts and dates in Excel
Filter numbers, texts and dates in Excel
Learn how to use filter in Microsoft Excel, to extract specific data out of big tables.
Difficulty:
Data AutoFilter in Excel
Data AutoFilter in Excel
The Data Autofilter allows you to investigate large quantities of information and filter out unnecessary rows. Extremely useful if you work with large quantities of data.
Difficulty:
Cleaning up data using the Data Autofilter
Cleaning up data using the Data Autofilter
Excel is often used as a means of cleaning up data and producing reports. Often the most time consuming aspect is the data cleanup. Using the Data AutoFilter it is possible to achieve more in less time.
Difficulty:
How to use Filter and Advanced Autofilter in Excel
How to use Filter and Advanced Autofilter in Excel
How to Easily use the Autofilter and Advanced Filter Functions in Excel in order to automate repetitive tasks.
Difficulty:
Search Term(s) (1): filter