Learn how to add a highlight to expose groups in your Microsoft Excel data using a helper column and Excel’s conditional formatting feature.

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

Some benefits to using GROUPBY over a PivotTable are that it is formula-based, it updates dynamically, and it is easy to use in reports (it does not require setup). In cell G1, enter the GROUPBY ...

Slicers provide an intuitive, user-friendly interface for filtering data in a spreadsheet. Here’s how to create slicers, format them, and use them to filter data in Excel.