Articles Index

Excel Single Cell Array Formula Step by Step Tutorial

An array formula in Excel is a formula that carries out calculations on one or more elements in an array. There are two types of array formulas - multi cell and single cell array formulas. This tutorial includes a step by step example of using a single cell array formula in Excel.

Excel Multi Cell Array Formula Step by Step Tutorial

An array formula in Excel is a formula that carries out calculations on one or more elements in an array. There are two types of array formulas - multi cell and single cell array formulas. This tutorial includes a step by step example of using a multi cell array formula in Excel.

Changing the Order of Operations in Excel Formulas

Excel's order of operations is the set order followed by Excel when it evaluates formulas containing more than one mathematical operator. This tutorial includes step by step examples of changing the order operations in Excel formulas.