Explaining the Other Matrix Functions in Excel

In this video, I discuss the use of the other matrix functions (aside from TRANPOSE and MMULT): MDETERM, MINVERSE, and MUNIT, namely their outputs and operations (what do they actually do?). If you know some linear algebra, this is effectively, obvious, of course.

There really isn't much else to say about them as their names are self-explanatory and have specific math usages and terminology which I will not be describing here and are more suitable for a programming language anyways. For example, for a system of equations, Laplace expansion can be used to find the determinant of a row, which can be used for solving the system of equations.

If you found this helpful or enjoyable, please consider subscribing to our newsletter for more.  

You can reach out to us here for consulting services.