|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-macro-recorder-to-automate-tasks/
课程评论：没有评论
**课程名称：** Microsoft Excel - 60分钟掌握宏的强大功能 **课程概述：** 本课程是一系列循序渐进的视频课程，旨在帮助您熟悉Excel的宏录制器。许多Excel用户并未意识到宏能为工作簿带来的强大功能，以及由此节省的大量时间。本课程将教授您足够的技巧，利用Excel的宏录制器来自动化任何重复性任务。从自动生成模板，到控制AutoFilter、数据透视表等对象自行运行，您将在60分钟内学到这一切。 **您将学到：** 1. 宏基础与宏录制 2. 宏录制器的工作原理 3. 录制简单与复杂的宏 4. 优化录制的代码（添加少量VBA语句） 5. 一些实用的练习示例 **课程特色：** * 易于理解的视频课程和辅助阅读材料。 * 预计完成时间约为1小时。 * 提供练习文件，方便您边学边练。 * 特别适合有Excel使用经验并希望深入学习宏或VBA的用户，为您的进阶学习打下坚实基础。
A step-by-step video series that will help you get familiar with Excel's Macro Recorder. Many Excel users across the globe are unaware of the power, macros can bring to their workbooks, and the amount of time that can be saved. This course aims at getting you equipped with enough tips & tricks to automate any repetitive task that you might be performing, using Excel's Macro Recorder. From teaching Excel to automatically generate templates for you, to controlling objects like AutoFilter, Pivot Tables etc., to work on their own, you will learn it all in a matter of 60 mins. In this course you will learn - 1) Basics of Macros & Macro recording 2) Elements of the macro recorder 3) Recording Simple & Complex Macros 4) Optimizing a recorded code with some VBA lines 5) Some helpful examples for hands on training The course contains easy to understand video lessons & other reading material and should take approximately 1 hour to finish. Easy to follow along with the help of exercise files that are provided with lessons wherever required for practice. Those who have been using Excel and are looking to get into Macros or VBA, this course will provide a good foundation to build upon.
