|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excelvba/
课程评论：没有评论
**课程名称：** Visual Basic for Applications: 成为Excel VBA程序员 **课程概述：** 本课程旨在帮助学员掌握Microsoft VBA（Visual Basic for Applications）编程语言，从而构建高效强大的Excel程序。课程将从基础的宏录制、快捷键定义、宏调试与运行入手，逐步深入到VBA环境的熟悉。 学员将学习常用的VBA命令，包括循环结构（Do While, For Next）、输入框（Input Box）、用户窗体（Userform）以及工作簿和工作表事件（Workbook and Worksheet Events）。 课程强调通过大量的实际案例研究来进阶VBA知识，认为这是学习宏的最佳途径。通过案例学习，学员不仅能掌握多种编程方式，发挥创造力，还能显著提升工作效率，将原本需要数小时完成的任务在短短几秒内搞定。更重要的是，学员将能够实现仅使用Excel本身无法完成的高级功能。
In this course, Learn how to unlock the power of Microsoft's VBA programming language to build effective and powerful programs.You will first learn how to record a Basic macro, how to define Short cut key, how to debug and run macros. Once you are comfortable with VBA environment, we will cover most frequently used commands like Do while, For Next, Input box, Userform, Workbook and worksheet Events. At last we shall take many practical long problems to advance your knowledge on VBA. The best way to learn Macro is to learn it with case studies. With case studies, you develop your creativity. You will learn multiple ways to write a program with different coding. Once you learn VBA, the task that you do in several hours, you will be able to complete that in just few seconds. You will be able to perform even that task which is not possible with Only Excel.
