Build Neural Network With Ms Excel Full -
We need 4 weight matrices and 2 bias vectors.
Setting up Input → Hidden (Shape: 4x2)
Setting up Hidden Bias (Shape: 4x1)
Setting up Hidden → Output (Shape: 1x4)
Setting up Output Bias (Scalar)
This is the core "feature" of the build. You are not writing Python scripts; you are writing Excel formulas.
MMULT):
More complex, but in essence:
For h1 (cell W14):
= ($Q$14*$R$14*$J$4) * (J14*(1-J14))
(Delta_Output * W12_O) * H2_Act * (1 - H2_Act)
Copy rows L20:W20 down for rows 21, 22, 23. build neural network with ms excel full
Go to the Forward_Prop tab.
But as a learning tool, Excel is unmatched. You will never again treat neural networks as magic. We need 4 weight matrices and 2 bias vectors