. Fill these cells with small random numbers between -0.5 and 0.5 using =RAND() - 0.5 . Create a row below the weights for . Initialize them to 0 . Output Layer Weights ( W[2]cap W raised to the open bracket 2 close bracket power ): Create a
Use Excel's MAX() and MIN() functions to determine these values automatically. Step 2: Initialize Weights and Biases (The "New" Way)
In cell K6 , put the Target (Y). For XOR, the target is 1 if inputs are different, else 0 . In cell L6 (Loss): =(I6# - K6)^2 (Instantaneous error) In cell L8 (Total MSE): =AVERAGE(L6#)
If you prefer building without external tools, you can manually construct a neural network using Excel’s core mathematical functions: Forward Propagation =SUMPRODUCT() build neural network with ms excel new
: Format your training data as an Excel Table.
: A sophisticated professional add-in that imitates brain functions to "learn" data structures and make predictions without manual coding. Dynamic Array Functions : Modern Excel functions like
1 neuron with a Sigmoid activation function (ideal for binary classification) Initialize them to 0
If you prefer not to build formulas manually, newer tools automate the process within the Excel interface: ANN-Excel Framework (2025/2026)
If you prefer not to use Python, you can build a "hardcoded" neural network using and Matrix Multiplication ( MMULT ) . Build Machine Learning Model with Python in Excel
Do you need help adjusting for larger networks? Share public link For XOR, the target is 1 if inputs are different, else 0
x−xminxmax−xminthe fraction with numerator x minus x sub m i n end-sub and denominator x sub m a x end-sub minus x sub m i n end-sub end-fraction 3. Designing the Network Architecture (Nodes & Weights) Create distinct sections for your parameters. A matrix (3 nodes, 2 inputs) in F2:H3 . Hidden Layer Biases ( ): Three cells in F4:H4 . Output Layer Weights ( W2cap W sub 2 ): A matrix in J2:J4 . Output Layer Bias ( ): One cell in J5 .
This single cell formula now contains the entire neural network training logic.
In cell M6 : =(I6# - K6) * (I6# * (1 - I6#))