Solve Equations in Excel

The following tutorials are an introduction to solving linear and nonlinear equations with Excel. The solution to linear equations is through matrix operations while sets of nonlinear equations require a solver to numerically find a solution.

Solve Linear Equations with Excel

Solve Nonlinear Equations with Excel

Linear and nonlinear equations can also be solved with MATLAB and Python. Click on the appropriate link for additional information and source code.

The APMonitor Modeling Language is optimization software for mixed-integer and differential algebraic equations. It is coupled with large-scale solvers for linear, quadratic, nonlinear, and mixed integer programming (LP, QP, NLP, MILP, MINLP). Modes of operation include data reconciliation, real-time optimization, dynamic simulation, and nonlinear predictive control. It is freely available through MATLAB, Python, Julia, or from a web browser interface.