How would you like to MASTER graphic design by next week?
Click here to find out how
Featured Photoshop templates - professional ready to use designs for your next project
View all templates
Excel Filter Tutorials
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.
Basic Data List Filtering
This technique covers how to use AutoFilter to do basic and custom filtering of the data list.
Display AutoFilter Criteria
Use a custom function to display the criteria used for any column in a table with an AutoFilter applied.
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.
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.
Filter numbers, texts and dates in Excel
Learn how to use filter in Microsoft Excel, to extract specific data out of big tables.
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.
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.
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.