|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-vba-macro-1-hour-crash-course-for-absolute-beginner/
课程评论：没有评论
Coursera 上的 Excel VBA (宏)：1小时入门速成课 本课程专为希望快速学习编写 Excel 宏以自动化日常工作任务的学生设计。无论您对 Excel 宏/VBA 一无所知，还是只知道如何录制宏，本课程都将进一步教您如何编写自己的代码来帮助您处理单调/重复性的任务。 **课程特色：** * **精炼高效：** 课程设计紧凑，直击要点，旨在尽快教会您编写 Excel VBA 代码来解决实际问题。 * **聚焦核心：** 课程内容经过精心挑选，只涵盖自动化管理/后台任务所需的必要知识。 * **非专业导向：** 本课程的目标不是培养专业的 VBA 编写者，而是帮助您快速解决实际问题。 **您将学到：** * 宏的录制及根据需求进行编辑。 * Excel VBA 的核心构建模块。 * 通过搜索在线内容编写更复杂的函数。 * 修复 Excel 宏错误（调试）的方法。 **注意事项：** * 本课程使用 Microsoft Excel 2019 进行教学，但所教授的技术适用于所有 Excel 版本。 * 课程不提供 Mac 版 Excel 用户的支持，讲师本人不使用 Mac 版 Excel。
This course is suited for students who wish to quickly learn how to write their own Excel Macro for their daily work tasks. If you have zero knowledge on Excel Macro/VBA or only knows how to record macro, this course takes a step further to teach you how to do write your own piece of code to help you with your mundane/repetitive tasks.What is the difference between this course and the rest?What set this course apart from the rest is that it is designed to be compact and right to the point. The main goal of this course is to teach you how to write Excel VBA code to help you with your own tasks in the soonest possible time. The topics covered are carefully picked so that you will only learn the essentials that are needed for the purpose of administrative/back-end tasks automation. This course does not aim to teach you to be a professional VBA writer who conforms to the best practices.What you will learn:Macro Recording and editing it to suit your needsWrite essential building blocks of Excel VBAWrite more complex functions by sourcing online contentLearn how to fix Excel Macro errors (Debugging)NoteThe course is taught using Microsoft Excel 2019 but the technique works with any version of Excel.No support for students who are using Excel in Mac as I do not use Excel in Mac
