Play the flash tutorial to learn how to perform matrix algebra in Microsoft Excel.
First we'll use the matrix multiplication function MMULT in the first cell of the array. We tell excel to complete the matrix using a combination of keystrokes:
Select the range (I20:J28) starting with the formula cell (I20).
Press F2, and then press CTRL+SHIFT+ENTER to fill the array.