Build Neural Network With Ms Excel New Now

Excel cannot auto-differentiate, so we manually optimize using trial & error (or Excel Solver later).

Highlight the loss cell (L8). Go to Insert > Sparklines > Line. As you press F9 (Manual Recalc), you will see the loss line trending downward. This is oddly satisfying. build neural network with ms excel new

Set a Learning Rate (Alpha) in cell R2 (e.g., 0.1). Excel cannot auto-differentiate