Disclosure: when you buy through links on our site, we may earn an affiliate commission.

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
3.9
3.9/5
(74 reviews)
5,502 students
Created by

8.1

CourseMarks Score®

7.4

Freshness

6.9

Feedback

9.4

Content

Platform: Udemy
Video: 9h 44m
Language: English
Next start: On Demand

Table of contents

Description

Numerical modeling is a very powerful branch of mathematics. It is capable to solve very complex problems using very simple techniques.
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!!

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

Requirements

• Computer & Access to Microsoft Excel
• Knowledge of basic Algebra, Geometry & Calculus Concepts
• No previous experience in VBA programming Language is required

This course is for

• Students enrolled in their first numerical Methods Class and interested in additional mentoring
• Students interested to learn the most common Numerical Methods Techniques used in science and engineering
• Students interested in understanding how to program and create Numerical Modeling Techniques from scratch
• Students interested in Learning VBA Programming Language

How much does the Numerical Methods in EXCEL/VBA PROGRAMING course cost? Is it worth it?

The course costs $14.99. And currently there is a 82% discount on the original price of the course, which was $84.99. So you save $70 if you enroll the course now.
The average price is $41.4 of 21 Excel Modeling courses. So this course is 64% cheaper than the average Excel Modeling course on Udemy.

Does the Numerical Methods in EXCEL/VBA PROGRAMING course have a money back guarantee or refund policy?

YES, Numerical Methods in EXCEL/VBA PROGRAMING has a 30-day money back guarantee. The 30-day refund policy is designed to allow students to study without risk.

Are there any SCHOLARSHIPS for this course?

Currently we could not find a scholarship for the Numerical Methods in EXCEL/VBA PROGRAMING course, but there is a $70 discount from the original price ($84.99). So the current price is just $14.99.

Who is the instructor? Is Shams El-Din El-Fouly a SCAM or a TRUSTED instructor?

Shams El-Din El-Fouly has created 1 courses that got 74 reviews which are generally positive. Shams El-Din El-Fouly has taught 5,503 students and received a 3.9 average review out of 74 reviews. Depending on the information available, Shams El-Din El-Fouly is a TRUSTED instructor.
Petroleum Engineer | Entrepreneur | Teacher
My passion was always to learn and teach everyone around me. I found this very fulfilling. For this reason I have pursued an engineering degree in petroleum engineering and later continued to a masters in the same discipline. Along the way I would help friends and mentor students new in the program and along the way  also discovered my passion in sharing ideas and knowledge.
It was only when I was hired to create an online course that I discovered a way to expand my impact and contribution where before I could only impact the people in close proximity to me at school.
I am aiming to demystify a lot of the core engineering courses and also some more specific courses in my discipline. 
I hope you enjoy and find value in my courses!
Browse all courses by on Coursemarks.
Platform: Udemy
Video: 9h 44m
Language: English
Next start: On Demand

Students are also interested in