Populating a dropdown with a dynamic list is easy thanks to Microsoft Excel’s UNIQUE() dynamic array function.

An curved arrow pointing right. {} These brackets mean something magical is happening inside your Excel formula. An "Array" function allows you to perform mathematical operations on many cells ...

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

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.

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

Microsoft is opening up Excel to developers with a new JavaScript API. It will let developers use custom data types like images, cards, and arrays.