Nonlinear interpolation with Solver to construct yield curve

The speaker uses the "solver" function in microsoft excel to more accurately peform nonlinear interpolation to build the US treasury bond yield curve.  The treasury does not publish yields for every term to maturity and for this reason, interpolation must be used to derive the yield for a non standard period of time.