|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learning-programming-numerical-methods-in-excel-vba/
课程评论：没有评论
Coursera课程《Excel/VBA编程中的数值方法》 本课程深入探讨了数值方法这一强大的数学分支，它能以简单技术解决复杂问题。课程将教授如何使用数值方法进行微分、积分、最佳拟合模型创建以及求解已知导数和条件的函数。这些方法能生成误差极低的近似值，堪比精确值。 然而，数值方法依赖于迭代计算，复杂的逼近可能需要大量手动计算。为此，本课程将引导学员一步步学习如何利用Excel强大的编程语言VBA来实现这些数值方法，并通过简单的按钮操作完成海量计算。 课程强调了编程语言的通用结构：顺序、重复和决策。掌握了这些核心概念，学员将能轻松学习其他编程语言。本课程旨在分享知识，希望学员能从中获得宝贵价值。
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!!
