Excel has announced a new array-based function called SORT, which can be used to sort data in one or more columns without involving a manual sort process or a complicated macro process.

Other array-based functions include SORTBY and RANDARRAY. The SORTBY function works like the SORT function, except it sorts data according to data contained in another array. For example, you might ...

Learn how to use MINVERSE and MMULT functions in Excel. MINIVERSE returns the matrix inverse of an array,. MMULT function returns matrix product of two arrays.

If you see You can't change part of an array error while trying to use the Sort, Delete, Edit, or some other feature in Microsoft Excel, see this post.

If you regularly work with data sets in Excel, you know how important it is to be able to quickly find the information you ...

Excel doesn't have a built-in AVERAGEIF() function, but you can still average values, conditionally.

Use the RANDARRAY() dynamic array function to return random names or other text in Microsoft Excel.

After my recent post on using Office Scripts and cube functions to generate Excel reports from Power BI data, Meagan Longoria asked me this question on Twitter: To which I can only reply: guilty as ...