In this section we review the key characteristics of matrices and describe how to perform various matrix operations in Excel. We also describe some related topics, such as determinants and solution of simultaneous linear equations, as well as iterative procedures, such as Newton’s method and Iterative Proportional Fitting Procedure (IPFP). Finally we show how to use Excel’s built-in iterative methods Goal Seek and Solver.

Topics:

- Basic Concepts of Matrices
- Matrix Operations
- Determinants and Simultaneous Linear Equations
- Newton’s Method
- Goal Seeking and Solver
- Iterative Proportional Fitting Procedure (IPFP)