This course has been discontinued
Most engineers and scientists spend a large part of their workday solving problems, usually with the help of calculations and computers. Therefore, whether you are problem solver or someone who manages problem solvers, you must be familiar with current methods of performing calculations. Numerical methods are schemes that convert engineering and science problems into a form we can solve with arithmetic calculations. Using numerical methods with computers for scientific problem solving is a basic skill for all problem solvers and an important skill for engineers and scientists.
Excel is the Microsoft spreadsheet computer program that allows you to manipulate data stored in rows and columns. Should you change even one item, the program automatically updates the entire set of calculations, saving time in problem solving. Thus, Numerical Methods and Excel are made for each other! You even have the ability to write your own programs, called macros, using Visual Basic for Applications (VBA).
This 6-hour interactive online course covers Excel methods for solving nonlinear equations, linear equations, optimization, curve fitting, differentiation and integration, ordinary differential equations, partial differential equations, and VBA programming concepts for Excel. You will need a copy of Microsoft Excel handy to complete this course.