A. Microsoft Excel is best known for crunching numbers, but it’s also a powerful tool for organizing tasks. Checkboxes can ...

As an enhancement to Excel’s calculation engine, the Dynamic Arrays functionality enables a single formula to produce results that expand into other cells, as demonstrated in the SORT example below.

Microsoft is making some improvements to how formulas work in Excel, with a new feature called Dynamic Arrays that allows formulas to output values to more than one cell at a time.

Microsoft Excel's new dynamic array functions make complex calculations easier than ever before.

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

Example: I have a 5 x 5 array of data with names of animals in it. I have another cell with "monkey" written in it. Is there a way I can write a formula to test whether or not "monkey" exists in ...

How to Run an Event in MS Excel If a Cell Is Selected. Microsoft Excel runs events using Visual Basic for Applications, or VBA, a programming language for writing macros. Events often run in ...

Microsoft Excel’s Name box is a powerful tool for its size. Use it to move around, create range names and even enter functions.