Excel Basics

Basic principles of Excel.

The Excel Match Function

The Excel Match function searches an array (either a row or column) for a specified value and returns the relative position of the value in the array. For example, if we have a list of fruits including bananas, cantaloupes, grapes and watermelon, using match to find grapes would return 3 as grapes is the third […]

The Excel Match Function Read More »

What is a Cell Range

Tutorials / richard.goeggel

The simplest and most general definition of a cell range in Excel is a range is a group of one or more cells. A group of adjacent cells can be a range, but a range can also include scattered cells. Our Example Worksheet Create named range using the name box One way to create a

What is a Cell Range Read More »