We may earn an affiliate commission when you visit our partners.

Numerical Methods in EXCEL/VBA PROGRAMING

Shams El-Din El-Fouly

4.4

Based on 96 ratings

Shams El-Din El-Fouly

It is a branch that can differentiate and integral without the need to use any of the sometimes complex differentiation and integration rules. It can create best fit models with just knowing a data set. It can create functions where the only thing we know is its derivative and a condition. And best of all, it can generate approximations that have such a low percentage error that they are as good as the true value.

But...

There is a limitation to numerical methods. They depend of iterative calculations. If for example you want an approximation with a low error, for example 0.001%, this will require a large amount of calculations which can be sometimes impossible to do by hand not to mention tedious. This is where programming comes in.

In this course I will walk you through not only the workings of each technique but a step by step process on how to program each of these techniques and preform hundreds if not thousands of calculations with a click of a button using one of the most powerful softwares created, EXCEL. And I'll be using excel's inbuilt programming language, VBA.

The great thing about programming languages is they all follow the same programming structure, sequence, repetition and decision making. Meaning, if you know one language you can learn another very easily by just knowing how these structures are defined in the new language.

In this course you'll have a very good grasp of these structure so if you decide to learn another language afterwards it will be very easy.

This project was a means for me to give back and contribute. I hope you find some value in this course.

Thank you and Enjoy.

Enroll now

Or start a personal plan

And upskill with Udemy

What's inside

Learning objectives

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
Show more
Show less

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
Show more
Show less

Syllabus

Learn the fundamental of how to program in VBA includes creating functions, subroutines, variables, loops, decision structures and more

Setting Up Excel_VBA

Save this course

Create your own learning path. Save this course to your list so you can find it easily later.

Save

Career center

Learners who complete Numerical Methods in EXCEL/VBA PROGRAMING will develop knowledge and skills that may be useful to these careers:

Reading list

We've selected 50 books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Numerical Methods in EXCEL/VBA PROGRAMING.

Numerical Mathematics and Computing

Save

Comprehensive textbook on numerical analysis for graduate students. It covers a wide range of topics, including linear algebra, approximation theory, and differential equations, and provides a thorough theoretical foundation for numerical methods.

Numerical Mathematics and Computing

Paperback

$$$$

Introduction to Linear Algebra

Save

Is excellent for gaining a broad understanding of matrix operations and linear algebra fundamentals. It is widely used as a textbook in undergraduate courses and provides a solid foundation with a focus on applications. It is particularly helpful for students new to the topic or those needing to solidify their basic understanding.

Numerical Methods in EXCEL/VBA PROGRAMING

What's inside

Learning objectives

Syllabus

Save this course

Career center

Reading list

Share

Similar courses

Udemy Buyer Protection & Guarantee

Free Lecture Previews

30-Day Money-Back Guarantee

Verified Academic & Industry Partner