To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

Excel's GROUPBY function lets you group and aggregate data based on certain fields in your table of data. It also offers arguments that allow you to sort and filter your data, so you can tailor the ...

A. Microsoft Excel is best known for crunching numbers, but it’s also a powerful tool for organizing tasks. Checkboxes can ...

If you’d like to learn about XLOOKUP (), read How to use the newish XLOOKUP () dynamic array function in Excel. I’m using Microsoft 365 on a Windows 10 64-bit system.

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.

Excel's new Copilot function turns your prompts into formulas - how to try it It's so much easier to create, summarize, and analyze data now - no complex manual formulas required.

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.