Academy

An Excel function is a preset formula, that helps perform mathematical, statistical and logical operations.

The combination of INDEX and MATCH, as well as the VLOOKUP function are well known methods for search in Excel. To our great frustration, the latter is used a lot more often, while the combination of INDEX and MATCH is less error prone and a lot more efficient.

The MATCH function in Excel looks for a certain value in a specified lineair cell range and returns the relative position of that value within this range.

Long ago, Excel was not as clever and advanced as it is today, and the so-called array functions are an inheritance of this past. However, most people don’t know about them, and don’t understand them. This is perhaps because of the different nature or the strange method to activate these formulas (CTRL-SHIFT ENTER instead of just ENTER).

A spreadsheet is a file that exists of cells in rows and columns and can help arrange, calculate and sort data. Data in a spreadsheet can be numeric values, as well as text, formulas, references and functions.

An operator sign is a symbol that indicates a type of computation between cells and/or integers and is often used in the more straightforward types of calculations in Excel.