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. Returning the top or bottom n ...

When I learned how to use tables in Microsoft Excel, it totally transformed how I work with data. Even if you think you already know everything there is to know about Excel tables, hopefully, you'll ...

Much of the data that you use Excel to analyze comes in a list form. You might need to sort the data, filter it, sum it, and perhaps even chart it. Excel tables provide superior tools for working with ...

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. Filtering is a huge part of many Microsoft Excel sheets, and ...