This video is about the solution of the Secant Method to find the root of the non-linear equation. The tutorial consists of:

  1. Theory of Secant Method
  2. Solution of Secant Method in Excel
  3. Solution of Secant Method in VBA

Download the starter file

The final expression of the secant method can be written as:

The secant method involves the following steps:

  1. Choose the guess values x0 and x1.
  2. Find the value of f(x0) and f(x1).
  3. Estimate the value of x2 using the given equation.
  4. Repeat steps 2 & 3 until f(xi) = 0 or all the values of x becomes equal within specified accuracy.

Please like and follow us on:

  • Facebook:
  • Instagram:
  • LinkedIn:

Join the Facebook group for interactive learning:

For any queries please write: