Placing spreadsheet data into a table quickly formats it and makes it easy to work with and analyze. Here’s how to use this basic yet powerful Excel tool.

Using the basic Excel filter function formula Before we explain how to use the Excel filter function with multiple criteria, it’s important to understand how the Excel filter function formula works.

When you work with spreadsheet data in a standard table or pivot table, you may want to view only particular data. You can use Excel’s built-in filter feature; however, the options can be limiting as ...

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

To fix an Excel spreadsheet not filtering correctly, ungroup its sheets, apply the filter to its entire spreadsheet column, and unmerge cells.

How to Make a Regression Table in Excel. Microsoft Excel 2010 comes with an expansion pack called the Analysis ToolPak that includes a number of analylitical tools, like the ability to create a ...