Subscribe
Tutorial search

Excel Array Tutorials


Sort by:
MMult Function
MMult Function
The MMULT function in Excel is used for matrix multiplication. It takes as inputs two arrays or matrices and outputs the matrix product of the two
Difficulty:
SUMPRODUCT
SUMPRODUCT
The SUMPRODUCT function in Excel is a useful tool when you are working with large datasets or multiple arrays.
Difficulty:
Array Formulas in Excel
Array Formulas in Excel
Arrays in Microsoft Excel are not a single function, but actually a variety of different formulas that you can use to simplify your work with arrays.
Difficulty:
Excel VBA Array
Excel VBA Array
An Excel VBA Array is a group of variables. You can refer to a specific variable (element) of an Array by using the Array name and the index fnumber. This tutorial explains how to declare and initialize a one-dimensional and two-dimensional Array, how to Redim an Array and how to find the size of an Array.
Difficulty:
Search Term(s) (1): array