Linear regression and curve fitting

How does the Excel "trendline" tool work? I talk about the underlying math and show how to do linear regression in Python. I also show how to use curve_fit in scipy.optimize to solve the same kind of problem