Matrix

4 lessons in order

Learn how to create a matrix in Excel using grids, SmartArt, PivotTables, bubble charts, or 4-quadrant charts for analysis and visualization.

Learn how to do matrix multiplication in Excel using MMULT, SUMPRODUCT, and TRANSPOSE functions with clear examples.

Learn how to calculate an inverse matrix in Excel using the MINVERSE function and VBA with step-by-step guidance and examples.

Learn how to transpose a matrix in Excel using Paste Special, the TRANSPOSE function, and Power Query with easy step-by-step methods.