: As of late 2025, Microsoft Copilot's Agent Mode can generate the structure of a predictive model or neural network by simply describing the task in plain English. 2. Step-by-Step Build (Traditional Formula Approach)
You can now write these formulas in Excel, referencing the weight, bias, and input cells. For the Sigmoid function, use the built‑in EXP() function.
Once XOR works, try:
If you want, I can:
We will build a . Specifically, we will create a neural network that can learn the XOR Logic Gate (Exclusive OR). build neural network with ms excel new
σ(z)=11+e−zsigma open paren z close paren equals the fraction with numerator 1 and denominator 1 plus e raised to the negative z power end-fraction
The forward pass calculates the network's prediction by moving from left to right. 1. Calculate Hidden Layer Activation : As of late 2025, Microsoft Copilot's Agent
dW2=A1T⋅δ2d cap W sub 2 equals cap A sub 1 to the cap T-th power center dot delta sub 2 Excel Formula: =MMULT(TRANSPOSE(A_1), Delta_2) Gradients for the Hidden Layer Backpropagating the error through the weights.
In Excel, you can simulate one iteration per row, or you can manually copy and paste the updated parameters over the initial ones to run another epoch. With each iteration, you should see the total error decrease as the network slowly learns the mapping from inputs to outputs. For the Sigmoid function, use the built‑in EXP() function
Click , go to the GRG Nonlinear tab, and ensure Use Multistart is checked. This helps the network escape local minima to find global weights. Click Solve .
Predicts a probability between 0 and 1 using a Sigmoid function. The Dataset