|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-vba-for-beginners/
课程评论：没有评论
**Coursera 课程总结：Excel VBA 入门** 本课程专为非 IT 背景的 Excel 用户设计，旨在帮助您超越 Excel 的基础功能，实现报表自动化和日常任务的自动化。 **课程亮点：** * **VBA 基础入门：** 深入理解 VBA 的概念和重要性，特别是对于会计等部门的用户。 * **面向对象的编程：** 学习 Excel 对象模型，了解如何通过 VBA 操作对象的属性和方法。 * **宏录制与修改：** 掌握宏的录制、执行、以及如何阅读、理解和修改 VBA 代码以满足个性化需求。 * **用户交互与自动化：** 利用 UserForms、MsgBox 和 InputBox 与用户进行数据交互，实现报表的自动格式化。 * **数据处理与管理：** 学习使用循环和条件指令读取和选择数据，处理字符串，并理解数组、Type 数据结构和 Collections。 * **文件操作：** 掌握使用 VBA 读取和写入文本及二进制文件的能力。 * **错误处理：** 学习如何管理因用户与 Excel 交互而产生的错误。 * **综合案例：** 通过一个包含多个工作表的 Excel 文件案例，学习工作表之间的数据交换以及导入导出外部文件。 **学习目标：** 完成本课程后，您将能够： * 独立编写和修改 VBA 代码以实现 Excel 自动化。 * 创建交互式 UserForms 来简化工作流程。 * 高效地处理和管理工作簿中的数据。 * 实现与外部文件的读写操作。 * 提高 Excel 使用效率，节省宝贵时间。 课程内容节奏恰当，确保所有学员都能轻松理解和掌握 VBA 的核心概念和实用技巧。课程最后提供练习题，帮助您巩固所学知识并提升 VBA 技能。
I created this corse since I have experienced during my live trainings and even from my students of other VBA courses that I released on the Internet, that most of my students are not IT-skilled people. They are just users of Excel and want to go beyond the basic functionalities of Excel and create automated report or automate daily tasks.For this reason I have created a course with the right pace to make it clear to anyone.In this course I start explaining what VBA is and why VBA. For example, if you are an user of Excel, e.g. in the Accounting Department, what VBA is and why you need it.For this reason it is important to understand first of all the concept of object oriented programming and explain how Excel is an application structured in objects whose properties and actions/events can be managed, manipulated and updated using VBA.I start with an overview of the Developer ribbon, which is the menu section where to record macros, execute macros, access the VBA editor and much more.I will show and explain the structure of a VBA object and how to record a VBA macro.Once recorded, I will explain how to read and interpret a VBA code and how to modify it for your goals.I will show how to make the user interact with the data in the worksheets using userforms and how to format the reports automatically.I have organized this course focusing on an example which is an Excel file or workbook composed of more worksheets. At the end the user will be able to exchange data between the worksheets and import/export them to external text and binary files.In details:Begin with VBA: why VBA, understand the VBA editor, learn how to record and execute a VBA macro, learn to read and interpret the VBA code, modify the VBA code, modify the macro security level.Understand the VBA code: the Excel objects and how and where to manage/edit their properties and actions/methods based on their eventsThe VBA project: what is a VBA project, how it is structure, the components, where to insert your code, how to set the properties of the objectsThe VBA programming principles: variables, constants, functions and subroutines. What is the difference between private and public. What is a module. What are the variable types.Interact with the data: read/retrieve data with loop instructions. Select data using conditional instructions. Strings and string functions.Interact with the user: exchange data and information using userforms, msgboxes and inputboxes. Understand the VBA control objects on userforms.VBA commands on worksheets: interact directly on a worksheet using control objects and directly on it and how to trigger actions and events.Structure of data: understand arrays and their size, how to populate arrays and manage their size. The Type data structure to save data into records. Collections.Manage external files with VBA: read and write to text and binary files.Errors: manage errors caused by the interection of the user with Excel.At the end you will find some exercise to improve your skill and verify your knowledge in VBA.
