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