Excel spreadsheets can grow unwieldy as they get larger and larger in size. If your company is working with a large list in an Excel spreadsheet, take advantage of the program's built-in filter ...

Are you wondering how to use the Excel FILOTER function with multiple criteria? We have detailed guide on how to easily use the Filter function in Excel using the AND and OR operators.

You can't use a SUM() function to sum a filtered list, unless you intend to evaluate hidden and unhidden values. Here's how to sum only the values that meet your filter's criteria.

The FILTER function in Excel can be used with many other functions to perform advanced calculations and analysis on specific sets of data in a large table. A common way to use FILTER with other ...

Finding the data you need can be difficult on large spreadsheets. In Excel, you can use filters to locate that data quickly.

Pivot tables generate great reports in Microsoft Excel, but adding a filter or two can make them even more flexible. Here's how.

Excel tables have many benefits that regular spreadsheets lack. The biggest is the option to use data from multiple tables to create queries and reports.

We show you how to use drop down lists in Excel - creating, applying, updating and extending them.

How to Automatically Sort a List Alphabetically in Microsoft Excel. When you are organizing data for your company in a spreadsheet using Microsoft Excel, you do not have to manually edit the ...