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.

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.

How to Automatically Sort a List Alphabetically in Microsoft Excel. When you are organizing data for your company in a spreadsheet using Microsoft Excel, you do not have to manually edit the ...

The Sort Excel function is a powerful tool for organizing and arranging your data in a meaningful order. Whether you need to sort numbers, text, or dates, this function has you covered.