Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.

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.

You can sort data by dates in Microsoft Excel and Excel Online. Learn how to sort all the columns according to date column using this tutorial.

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.

If the Excel Date Filter is not grouping by month, enable grouping dates in the AutoFilter menu, set dates in the proper format, etc.

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

How to Randomize the Contents of a Column in Excel. Suppose you have an Excel spreadsheet with a single column A and 52 rows. The value in each row's cell represents a playing card, for example K ...

How to Make a Yes or No Column in Excel. You can use drop-down lists to create "Yes or No" boxes in Excel. Excel drop-down lists present the user with a list of finite choices that they can enter ...