Iterative Solutions of Nonlinear Equations Using Excel Solver: Screencasts
We suggest that after watching each screencast, you write down the important points as a way to increase retention.
Screencast 1:
An Excel spreadsheet is used to determine the volume from a cubic equation of state. Three approaches are presented: 1) using a pressure-volume plot, 2) using sliders to vary the volume, 3) using Excel Solver. Spreadsheet: Solve a Nonlinear Equation in Excel
Screencast 3: Iterative Solutions/Excel (optional)
Screencast 2:
Demonstrates how to use Excel Solver to solve three nonlinear equations simultaneously. Spreadsheet: Solve Multiple Nonlinear Equations Using Solver