Matrix Multiplication In Excel
First you need matrixes. Here are my sample matrixes.
Then you need to use MMULT Excel function to multiply them.
MMULT function takes matrixes as arguments so it is obvious to use.
To use it highlight the whole matrix and type formula in first cell.
MMULT formula in my example is
This is how multiplied matrix looks like.