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

Figure E Quickly applying a few formats to the subtotals and grand total in Excel helps them stand out a bit from the data by moving them to a column of their own.

Need to know your organization's YOY results? Susan Harkins will show you how to make a PivotChart in Microsoft Excel.

This column shows how to use the Data Table option in Excel’s What-If Analysis tool.

Specifically, you can use Power Query to import a single dataset like an Excel workbook, a table from a website, or a database. Alternatively, you can import multiple datasets from worksheets in an ...