Numerical Methods in EXCEL/VBA PROGRAMING
Learn the workings of the most common numerical methods and a step by step process on how to program each of them
4.43 (94 reviews)
5,630
students
9.5 hours
content
Mar 2020
last update
$54.99
regular price
What you will learn
Program using VBA Programming Language
Approximate functions using Taylor series expansions
Approximate derivatives using conventional and high accuracy formulas
Approximate integrals using Trapezoidal rule, Simpson's 1/3 rule and Romberg integration
Find roots of equations using bisection, False position, newton Raphson and secant methods
Find analytically the optimum min and max of a function
Solve Ordinary differential Equations using Runge Kutta Methods (i.e. Euler, Heun's, Midpoint and Ralston Methods in addition to fourth order Runge Kutta Method
Find numerically the optimum min and max using Golden section Search method, newton Raphson Technique and finally the gradient decent/ascent method
Solve Systems of Equations using Gauss elimination, Gauss Jordan and LU Decomposition and generate inverse matrices
Perform curve fitting using regression analysis including linear and polynomial regression in addition to linearization for fitting more complex functions
Perform curve fitting using Cubic Spline
Related Topics
1770320
udemy ID
6/27/2018
course created date
5/17/2019
course indexed date
Bot
course submited by