最新消息:网盘下载利器JDownloader--|--发布资讯--|--站务--|--解压出错.密码问题--

Excel 2013: Macros in Depth

其他教程 007 0评论
Excel 2013: Macros in Depth
想在Microsoft Excel里创建日程任务安排提醒吗?宏命令将给你答案。本课程中,作者Dennis Taylor将解释宏命令是如何自动在Excel中运行,以及如何为自己创建一个简单的宏程序。学习如何分阶段记录宏程序,在工作本中共享宏命令,为快速执行宏指令设置快捷键。本教程结合真实环境中多元素的宏指令项目文件:讨论在关联性数据库结构下的会议邮件列表数据。(PengQ译,转载请注明)

Excel 2013: Macros in Depth | 444MB

Duration: 2h 43m | Video: AVC (.mp4) 1280x720 15fps | Audio: AAC 48KHz 1ch

Genre: eLearning | Level: Intermediate | Language: English

Want to save time on routine tasks in Microsoft Excel? Macros are your answer. In this course, author Dennis Taylor explains how macros can be used to automate tasks in Excel, and how you can create simple macros of your own. Learn how to record a macro in stages, share macros between workbooks, set up keyboard shortcuts to run macros quickly, and use Visual Basic for Applications (VBA) to code macros that can't be recorded. The course wraps up with a macro project that brings together each of the elements in a real-world scenario: converting mailing list data into a database-friendly format.

Topics include:

* Understanding what macros can do for you
* Running macros
* Creating a Personal Macro Workbook
* Recording macros
* Creating nonrecordable VBA code
* Expanding a macro with statements
* Using absolute and relative references
* Testing a macro in Step mode
* Joining two macros
* Using loop structures
* Streamlining macros
Excel 2013: Macros in Depth

以下隐藏内容只提供VIP赞助会员

sorry! The following hidden content sponsorship VIP members only.

您必须 登录 才能发表评论!

网友最新评论 (5)

  1. NOTHING BUT VIP 。。。
    bbbullet2年前 (2014-12-28)
  2. 请提供百度云地址,看不见。其他地址已挂。谢谢!
    HannibalBarca2年前 (2014-10-17)
  3. exercise files,这词儿长久不用居然也能拼错,自嘲一下。
    walkqisky3年前 (2014-02-17)
  4. 挺有用的视频,但包里没有excise files,能不能补一下,谢谢。
    walkqisky3年前 (2014-02-17)
  5. 想在Microsoft Excel里创建日程任务安排提醒吗?宏命令将给你答案。本课程中,作者Dennis Taylor将解释宏命令是如何自动在Excel中运行,以及如何为自己创建一个简单的宏程序。学习如何分阶段记录宏程序,在工作本中共享宏命令,为快速执行宏指令设置快捷键。本教程结合真实环境中多元素的宏指令项目文件:讨论在关联性数据库结构下的会议邮件列表数据。
    PengQ(特殊组–翻译)3年前 (2014-02-16)