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

Using range names in Excel allows you to quickly navigate to areas of your worksheet and makes formulas much easier to create.

Using range names in Excel Using range names in Excel allows you to quickly navigate to areas of your worksheet and makes formulas much easier to create.

Excel's spill range is a product of using dynamic array functions. Learn how the spill range fulfills these functions.

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

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