|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/intro-excel-macros-part-1/
课程评论：没有评论
**课程名称：Excel 宏入门（第一部分）** **课程概述：** 本课程由 Excel 专家 David Ringstrom 亲自指导，带您一步步掌握 Excel 宏的创建和使用。宏是 Excel 最强大的功能之一，在本课程中，您将了解 Excel 宏的概念、Visual Basic for Applications (VBA) 宏，并学习如何使用“录制宏”功能和 Excel 的“个人宏工作簿”。学完本课程，您将能够立即开始使用宏。 David 将演示每项技术至少两次：首先在带有编号步骤的 PowerPoint 幻灯片上演示，然后在 Excel 2016 中进行实际操作。他还会指出 Excel 2013、2010 或 2007 版本之间的差异，并在详细的讲义中提及。此外，David 还提供了一个 Excel 工作簿，其中包含了他讲解的大部分示例。 **课程内容：** * 理解 Excel 中与宏相关的“启用内容”提示。 * 查找 Excel 用户界面中与宏相关的命令。 * 自动化重复性任务，例如统一格式化一组电话号码。 * 利用“相对引用”设置，创建可在任何单元格而非特定单元格上运行的 Excel 宏。 * 理解 Excel“个人宏工作簿”的用途和细微差别。 * 录制联系人信息宏。 * 解读和管理 Excel 的宏安全提示。 * 仅通过两次按键，即可将 .XLS 工作簿转换为最新的 .XLSX 格式。 * 理解宏在 Excel 中的作用，以及与之相关的风险和优势。 * 学习使用合并单元格在 Excel 工作表中带来的风险和不便。 * 在无需任何编程知识的情况下，学习如何使用 Excel 的“录制宏”功能创建简单的宏。 **重要提示：** 本课程是四部分系列课程的第一部分，后续课程包括："Intro to Excel Macros Part 2"、"Intro to Excel Macros Part 3" 和 "Intro to Excel Macros Part 4"。您可以单独学习每门课程。
Excel expert David Ringstrom, CPA, takes you step-by-step through the process of creating and using macros-one of Excel's most powerful features. In this comprehensive presentation, he introduces the concept of Excel macros as well as the Visual Basic for Applications (VBA) macro. David also explains step-by-step how to use the Record Macro feature and Excel's Personal Macro Workbook. After completing this course, you'll be equipped to use macros immediately.David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws your attention to any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.Topics Covered:Making sense of the Enable Content prompt related to macros in Excel.Uncovering macro-related commands within Excel's user interface.Automating a repetitive task, such as formatting a set of phone numbers consistently.Utilizing the Relative References setting for creating Excel macros to be played back on any cell versus specific cells.Understanding the purpose and nuances of Excel's Personal Macro Workbook.Recording a contact info macro.Deciphering and managing Excel's macro security prompts.Converting.XLS workbooks to the up-to-date.XLSX format with just two keystrokes.Understanding how macros are used in Excel, along with the risks and benefits associated with them.Learning the risks and frustrations of using merged cells in Excel worksheets.Learning how to use Excel's Record Macro feature to create simple macros, without having any knowledge of programming.Although each course may be taken individually, this is part 1 of 4.1. Intro to Excel Macros Part 12. Intro to Excel Macros Part 23. Intro to Excel Macros Part 34. Intro to Excel Macros Part 4
