|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/become-an-excel-vba-expert-for-beginners/
课程评论：没有评论
**Coursera 课程摘要：Excel VBA 专家入门** 本课程专为希望自动化 Excel 任务的用户而设计。您将学习利用强大的 VBA (Visual Basic for Applications) 脚本语言，即使是复杂任务也能在几秒钟内完成。 **课程亮点：** * **零编程基础要求：** 仅需熟悉 Excel 即可。 * **宏录制与应用：** 学习录制操作序列，运行宏，并查看生成的 VBA 代码。 * **VBA 数据类型：** 了解不同类型的数字及其在 VBA 中的应用，并学习进行简单的算术运算。 * **字符串处理：** 学习如何处理文本数据，包括大小写转换、替换、计数等。 * **逻辑控制：** 掌握布尔值、If 语句和循环，实现更复杂的自动化逻辑和决策。 * **Excel 对象操作：** 学习如何通过 VBA 读取和操作 Excel 的单元格区域 (Ranges) 和工作表 (Worksheets)。 * **代码组织：** 了解 Sub 过程和 Function 函数，将代码模块化，提高可读性和可维护性。 * **实战演练：** 通过一个实际案例，学习如何批量统一不同格式的电话号码。 **技术要求：** 推荐使用 Excel 2007 或更高版本，课程提供兼容 `.xlsm` 文件。 通过本课程，您将能够利用 Excel VBA 轻松实现工作自动化，提升效率。
Overview This is a one-hour course that is intended for Excel users who want to learn how to automate their tasks. Excel, as well as other Microsoft Office programs, come with a powerful scripting language known as VBA. With a little bit of programming knowledge, complex tasks can be fully automated and completed in seconds. This course assumes no programming experience; only a reasonable level of familiarity with Excel. Prerequisites Microsoft Excel: This courses uses Excel 2007 for the demonstrations, and comes with.xlsm files for the code examples. These demos and files will be compatible with later versions of Excel as well. If you are using Excel 2003, you will not be able to open the.xlsm files, but you will be able to follow along with the demos. What you will learn The course begins with an introduction to macros. You will learn how to record a sequence of actions, how to run the recorded macro, and how to inspect the VBA code that gets generated from this process. You will then learn how to use numbers in VBA. There are different types of numbers which are used in different situation, so you'll be a given an overview of the differences between them. You will be shown how to do simple arithmetic operations inside your VBA code. You will then be introduced to strings. Strings are used in programming to represents words and characters. For example, "hello world" could be stored in your VBA code as a string. You could then perform various operations on your string, such as converting it to upper-case, replacing a word, counting the number of characters, and many others. Then you will look at booleans, if-statements and loops. These concepts will allow you to create complex behaviors that would not have been possible by simply recording a macro. You will able to write code that implements logical rules and makes decisions. Ranges and Worksheets will be introduced next. These objects are what will allow you to read and manipulate your Excel data from your VBA code. We will then move on to subs and functions. These will allow you to organize your code into small, cohesive pieces, making it easier to reason about complex tasks. Finally, we will end the course with a simple, practical exercise. We will take a list of phone numbers that are in inconsistent formats, and write some code that will convert them into a standard format at the press of a button.
