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

Creating running totals in Excel is straightforward, but you must be careful to use the correct method depending on how your data is structured.

Microsoft Excel’s mobile app lets you to take a picture of a table and paste the data directly into your spreadsheet. Here's how to use it.