Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Solving The Linear Equations system with matrices in Excel
Rating: 4.8 out of 5(9 ratings)
1,465 students

Solving The Linear Equations system with matrices in Excel

Matrix Method and Cramer's Method
Last updated 3/2018
Arabic
Arabic [Auto],English

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

Course content

1 section • 5 lectures • 1h 15m total length
  • Introduction to Excel arrays17:36
  • Matrix Operations9:42
  • Matrix Method15:05
  • Cramer's Method18:09
  • Examples from Real Life15:09

Requirements

  • MS Excel
  • Mathematics basics

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.

Who this course is for:

  • Teachers
  • Accountant
  • High school or college students
  • Anyone who wants to study math using MS Excel