Matrix Calculations are complex when it is solved manually. Let us see how to use MS Excel ® to solve complex matrix calculations.

**EXAMPLE 1: ADDITION AND SUBTRACTION OF MATRICES**

**EXAMPLE 2: MULTIPLICATION OF MATRICES**

It is to be noted that the order of the matrix is denoted by “m × n”, where m = number of rows in the matrix and n = number of columns in the matrix.

For any two matrix to be multiplied and if the order of Matrix 1 is “m1 × n1” and the order of Matrix 2 is “m2 × n2” then n1 = m2, resulting in the final order of the matrix as “m1 × n2”.

In the below example, Matrix A is of the order 3 × 2 and Matrix B is of the order 2 × 1. The resulting matrix will be of the order 3 × 1. We will see how to multiply the matrix.

**EXAMPLE 3: DETERMINANT OF A MATRIX**

The Determinant of a Matrix can only be found out for a Square Matrix (Matrix with equal number of columns and rows).

**EXAMPLE 4: INVERSE OF A MATRIX**

The Inverse of a Matrix can only be found out for a Square Matrix (Matrix with equal number of columns and rows).

**EXAMPLE 5: TRANSPOSE OF A MATRIX**

Transpose of a Matrix is nothing but changing the order of the matrix (Rows becomes Columns and viceversa).