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.

Learn how to filter data using wild cards and other complex criteria using Advanced Filter in Excel.

Create a to-do list in Excel First, you need to insert relevant details in your Excel sheet.