|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-macros-with-vba/
课程评论：没有评论
**课程名称：** Excel VBA 宏入门指南 (Excel Macros with VBA) **课程概述：** 本课程旨在帮助您在没有编程背景的情况下，掌握 Excel 宏（Excel 自动化）的全部知识。在竞争激烈的职场环境中，自动化是成功的关键。本课程将教您如何自动化 Excel 中重复性和例行性的任务。您将从宏录制器开始，学习创建简单的宏，然后逐步深入 Excel VBA，体验构建更动态、更强大的 Excel 体验的乐趣，从而为自己和同事带来便利。 **课程要求：** * 需要安装 Microsoft Excel 软件以进行实践操作。任何版本的 Excel 均可使用，视频使用 Excel 2016 录制，但 Excel 2007, 2010, 2013, 2016, 365, 或 2019 版本均可跟随学习。 * 具备基本的 Microsoft Excel 使用知识，以便轻松上手宏和 VBA。 **适合人群：** 本 Excel 宏/VBA 课程适合所有使用 Microsoft Excel 并希望通过自动化日常 Excel 任务来提高工作效率的用户。无需任何编程经验。 **课程特色：** * 2 小时以上点播视频 * 6 个视频 * 提供可下载的练习文件 * 永久课程访问权限 * 课程语言：印地语 * 支持在手机和电脑上访问 **课程模块：** * 宏基础 * 宏的准备、录制、运行及创建按钮 * VBA 代码的编辑与调试 * 宏中的动态选择 * 宏中的相对引用 * 创建自动化的数据录入表单 * 宏的 VBA 代码保护
Excel Macros with VBA (Beginner's Guide)This course will give you everything you need to know about macro (excel automation) without a coding background. Automation is the answer to being successful in this competitive work environment. Here you will see Automate your Excel repetitive & routine tasksThis course takes you on a journey of learning where you will start at point A, which is getting introduced to the wonders of creating simple Macros through the Macro Recorder and, with a few clicks, you will be released into the waters of Excel VBA where you will feel the exhilaration of building a more dynamic, robust experience for yourself and your colleagues.Requirements:To practice while learning, you will need Microsoft Excel loaded on your computer. Any version of Excel will work.Videos have been recorded using Excel 2016, but Excel 2007, 2010, 2013, 2016, 365, or 2019 will work to follow along.Should have basic Microsoft Excel knowledge to work with macros & VBA.Who This Course Is For:This Excel Macro/VBA course is meant for those who use Microsoft Excel and are looking to become more efficient by automating their daily Excel tasks. No prior programming experience is required.Course Features:2+ hrs on-demand video6 videosDownloadable practice filesFull lifetime accessExplained in Hindi LanguageAccess on mobile and ComputerCourse Modules:Basics of Macro Macro Preparation, record, run, & creating button Editing & debugging of VBA Code Dynamic Selection in Macro Use Relative Reference in MacroCreate Automated Data Entry Form Protect VBA coding of Macro.
