Verification easier by decreasing the complexity and number of formulas. – Using Excel built-in matrix operation functions might improveĬalculation efficiency but it definitely makes model development and TRANSPOSE() & MMULT() – two important Excel spreadsheet functions for matrix manipulations A bench-marking post will follow in which the two matrix functions will be compared speed wise with regular spreadsheet functions and also with user defined custom VBA functions. There are some basic rules to follow while entering or modifying such arrays. These functions are a bit harder to use than the regular spreadsheet functions in the sense that the result is a matrix and a matrix cell range is treated by the program as a unity (you cannot change the formula since you cannot operate on a single cell). This is a tutorial introducing two important matrix manipulation spreadsheet functions in Excel: the matrix transposition function TRANSPOSE() and the matrix multiplication function MMULT().
