Learn the criteria expression for finding blank cells using Excel's Advanced Filter feature.

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

You can filter data in Excel based on either certain parameters in columns or over the whole sheet, and you can later unfilter the sheet.