The application of excel in solving linear equations and nonlinear equation

Abstract-Solutions to linear equations and nonlinear equation are not only the main teaching contents of the course Computer Method , but also widely applied in engineering. It's difficult for non-computer major students to program and understand abstract theoretical explanations of mathematics. During the teaching process, the author finds out that it's vivid, intuitive and understandable to use Excel to solve linear equations and nonlinear equation. Taking equations 10X₁-X₂-2X₃=7.2, -X₁+10X₂-2X₃=8.3, -X₁-X₂+5X₃=4.2 and x³+2x²-16x-20=0 as instance, the author of this paper respectively explains the solution process of Jacobi iteration method, Seidel iteration method by Excel linear equations , and the solution process of Progressive scanning method , Newton iteration method, Interpolation method and Two-point chord cutting method by Excel nonlinear equation as well.