Excel VBA for Modelling using Numerical Methods

Excel VBA for Modelling using Numerical Methods

Hello everyone,

As it is known, the engineers deal with a big amount of data and they use the sophisticated calculations to solve the problems. However, sometimes the analytical approaches are not efficient, because of the complexity or impossibility. In this case, the numerical methods are very useful to solve the problem with the low level of the errors.

In this course, you will learn how to find the most approximate result to the real solution using the Excel VBA. The key points of each method is explained and the examples are given with detailed explanation. The course starts from the beginner level to explain the basics of VBA. Then, explaining the theoretical background of the each method, we will learn how to solve the different tasks in Excel VBA. In the end of the course, there will be problems which can improve your skills.

The course will provide you with both theoretical and practical skills to solve any modelling problem with numerical methods. For each topic, the scientific papers are also added in the course which will elaborate you with advanced background.

Learning the application and theory of the numerical methods for modelling in Excel VBA for 3 hours with practical test

Url: View Details

What you will learn

• Fundamentals of VBA
• Making a data table for single and multi variable functions
• Numerical integration with Trapezoid and Simpson's rule

Rating: 3.5

Level: All Levels

Duration: 3 hours

Instructor: Safar Asad