|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/a-beginners-and-intermediate-guide-to-vba-programming/
课程评论：没有评论
**课程名称：** Excel VBA 编程入门与进阶指南 **课程概述：** 本课程旨在帮助您掌握 Microsoft VBA 编程语言，从而自动化 Excel 中的重复性任务，提高工作效率。您将学习如何利用 VBA 扩展 Excel 的功能，甚至与其他 Microsoft Office 应用程序（如 Outlook、Word 和 MS Access）进行集成。 **适合人群：** * 希望成为熟练的 VBA 程序员的任何人。 * 希望学习如何有效利用 VBA 自动化和解决手动任务的任何人。 **课程内容：** * **基础概念回顾：** 复习 VBA 编程的基本概念和 VBA 编辑器，这是您将使用的开发环境。 * **核心语句与功能：** * 条件语句：IF 语句，Select Case 语句。 * 循环语句：For Next, Do While, Do Until 循环。 * 退出语句：Exit Statements, Goto 语句。 * 枚举与数据类型。 * DoEvents 语句。 * 宏。 * 数组：声明、重新初始化、自动填充和删除数组。 * 错误处理。 * 标准 Excel 对象。 * 函数与过程。 * 通过值传递参数。 * 通过引用传递变量。 * **高级主题：** * 高级字符串操作：使用 Trim, LTrim, RTrim, Left, Right, Instr 和 InstrRev 语句。 * 用户窗体。 * 类/自定义对象：学习面向对象编程的概念，设计和开发自定义对象。 * **实践应用：** 课程包含大量实际操作示例，帮助您理解和应用所学概念。最后将重点回顾如何将关键概念应用于实际场景。 **课程亮点：** * 提供大约 9 小时的视频课程内容。 * 配有实践文件和示例，助您成为高效的 VBA 程序员。 * 涵盖 VBA 编程的方方面面，从基础到进阶，再到实际应用。
Have you ever felt frustrated using Microsoft Excel to perform mundane and often repetitive tasks? Have you ever felt that there has to be an easier and faster way to perform to do something? Well, using Microsoft Visual Basic for Application (VBA) programming language allows you to automate manual tasks within Excel and allows you to be more effective and efficient with your time. Not only does it provide you access to a rich library of additional tools and capabilities, over and above what a standard user may have access to, it can also be used to integrate with some of the Microsoft other Office applications such as Outlook, Word and MS Access. So, who should take this course? Anyone who wants to learn how to be a proficient VBA programming Anyone who wants to learn how to effectively utilize the tool to solve and automated manual tasks In this course you will learn some of the fundamental concepts of the VBA programming language. Not only does this course include a review of the basic concepts and key functionality available within this rich programming language such as the IF, Select Case and Loop Statements, you will also learn how to design and develop your own custom objects using the concepts of object orientated programming through the use of class modules. This course starts off with a brief refresher on the basic concepts of the VBA programming language and a review of the VBA Editor, the development environment that we will use during this course. This program also includes a number of practical examples, to help demonstrate how to effectively utilize the concepts that you have covered during this course. This course includes the key concepts and practical examples of the following VBA statements and functionality: IF Statements Loop Statements (For Next, Do While, Do Until) Exit Statements Goto Statements Select Case Statements Enumeration Data Types The DoEvents Statement Macros Arrays (declaring, re-initializing, auto populating and deleting arrays) Error Handling Standard Excel Objects Functions and Procedures Passing Values To Functions By Value Passing Variables to Functions By Reference Advance String Manipulation using the Trim, LTrim, RTrim, Left, Right, Instr and InstrRev Statements User forms Classes / Custom Objects Variable Declaration And Scope We finish the training course by reviewing additional practical examples of how to apply the key concepts that we have reviewed during this course. In total, this course provides approximately 9 hours of course videos, including practical files and examples to help you become a proficient and effective programming.
