This lecture covers the basics of optimization and how to use optimization methods in Excel and Python.
This includes the use of Excel’s Solver tool and the scipy.optimize.minimize function in Python.
This video and the file below, show how to do optimization using scipy.optimize.minimize in Python. This is the same video as above, cued to start at the 19:35 mark.