VBA Crash Course
• Setting Up Excel_VBA
• For-Next Loop
• Do-While Loop
• Nested Loops
• If-Else Statement
• Factorial
• In-built Functions
Taylor Series & Functions
• Taylor Series & Exp(x) - Concept
• Taylor Series & Exp(3x) + Code + Difference between True & Approximate Error
Numerical Differentiation
• Conventional Finite Difference Approximation of 1st Derivative - Concept
• Finite Difference Approximation of 1st Derivative Code + Comparison
• Finite Difference Approximation of 2nd Derivative - Concept + Code + Comparison
• High Accuracy Finite Difference Approximation of 1st & 2nd Derivative
Numerical Integration
• Trapezoidal Rule
• Simpson's 1/3 Rule
• Romberg Integration
Ordinary Differential Equations
• Euler's Method
• Heun's, Midpoint & Ralston Methods
• Fourth order Runge-Kutta & General Runge-Kutta Method
Roots of Equations
• Bracketing Methods - Bisection Method
• Bracketing Methods - False Position Method & How it Compares to Bisection
• Open Methods - Newton Raphson and how it compares to Bracketing Methods
• Open Methods - Secant Method and how it compares to Newton Raphson
• Multiple Roots
• Goal Seek & Solver
Optimization
• Introduction to Optimization
• Analytical Solutions of Optimization Problems
• Newton Raphson to Find optimums
• Golden Section Search Method
Linear Algebraic Equations
• Arrays
• Matrix Properties & manipulations
• Gauss Elimination - Concept
• Gauss Elimination - Code
• Gauss Elimination with partial pivoting
• Gauss Jordan
• LU Decomposition
• LU Decomposition By Generating A inverse
Curve Fitting
• Linear Regression
• Polynomial Regression
• Linearization
• Cubic Spline