Excel's VLOOKUP function searches cell arrays for data that you provide. The function often takes cell references as input, letting you easily apply the function to each cell in a range ...

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

F3 – Paste Defined Names If you're not using named ranges in your Excel spreadsheets, you're missing out on something useful. Named ranges make formulas far more readable and manageable.

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.

Cells in Excel are referred to using relative or absolute references. A formula with relative references changes when the cell's position does.

Working with ranges in Excel is a fast and simple way to identify, define, or refer to a single cell, a range (or group) of cells, a specific or constant value, or a formula. Then you can use ...

Microsoft Excel’s conditional formatting is a wonderful “automatic” feature that allows you to formats cells based on the value of those cells or the value of the formulas in those cells ...