There are lots of ways to return the top or bottom n records from a data set in Microsoft Excel, but the new dynamic array functions make doing so easier than ever.

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

If you want to print an Excel spreadsheet but don't want to include rows that have a cell value of zero, you must filter the spreadsheet. Filtered rows will be skipped when you print your document.

You can convert daily data to weekly data in Excel by creating a pivot table, and grouping the rows in the pivot table in groups of seven days, or one week.