Using Matrices to Solve equations
- Introduction to Excel arrays
- Matrix Operations
- Matrix Method
- Cramer's Method
- Examples from Real Life
What you'll learn
- Using arrays in MS Excel
- Organize data in Matrix
- Make Matrix Addition And Subtraction
- Learn How Excel handles Matrix Math
- Multiply Two Matrices
- Matrix Inverse
- Matrix Transpose, and Matrix Identity
- Calculate Matrix Determinant
- Solving system of Linear Equations using Matrix
- Solving system of Linear Equations using Cramer's Rule
Description
This training course is considered a link between matrices in mathematics and operations in the Excel program, especially the topic of matrices and solving equations using them.
Through this training course, you can learn how to deal with Excel matrices and use regular Excel formulas and functions and those related to matrices through examples and models that simplify the use of matrices for you. You can also perform mathematical operations on matrices such as adding two matrices, subtracting two matrices, multiplying two matrices, transposing the matrix, inverting the matrix, and the unit matrix through examples and models that suit the Excel environment.
After completing this course, you can also solve a system of linear equations using matrices, and use Cramer's rule with a set of exercises and practical examples inspired by practical training on real-life examples.
After completing this course, you can also solve a system of linear equations using matrices, and use Cramer's rule with a set of exercises and practical examples inspired by practical training on real-life examples.
After completing this course, you can also solve a system of linear equations using matrices, and use Cramer's rule with a set of exercises and practical examples inspired by practical training on real-life examples.
The University of Sheffield
Other Courses
Personal Success Strategy
Achieve Success through Goal setting and Lasting Change, following Tactics Proven to Accelearate the Cycle of Success
Build an Augmented Reality Strategy for your Business
An AR Playbook for Determining Technologies & Strategies
Survival Chinese
The perfect survival course to prepare you for simple daily Chinese conversations
Artist Action Plan Mini Course
How to prepare yourself fully to release music effectively, and in the right way!
CAE Grammar Preparation - Key Word Transformations
Improve your CAE Use of English results
About the instructors
- 4.23 Calificación
- 5935 Estudiantes
- 4 Cursos
Mofeed Abouseafa
Educational consultant
I am an educational consultant, worked more than 35 years, in the field of education in Egypt, Libya, Saudi Arabia and interested in the fields of Programming,database systems,information technology,using technology in education, and writing . I wrote a series of books in mathematics and computer and was given a wide range of lectures and training courses, and I designed many programs that serve my work ...for more see my website.
Student feedback
4.5
Course Rating
Reviews
Ahmed Medhat
19-06-2023
This course is the best course i have enrolled in about matrices and excel it's just very deep and simple and short in the same time , i must thank the instructor as he seems very experienced and he is direct to the point and very friendly , thank you very much i learned a lot , i'm just waiting for another courses in excel by you .. Thanks.
Adam David
19-06-2023
I can tell that this course is very deep into arrays and excel , very recommended