快捷索引

Lynda.com 出品的时长2小时44分的 Excel 2010: 详解宏语言 视频教程。由Dennis Taylor讲解如何用宏语言可以在Excel中使工作任务自动化和通过创建与运行简单宏的过程。本教程涵盖高级进阶课题,如通过个人宏工作簿可使宏广泛使用,录制一个分段、 完全和相对记录的宏,利用Visual Basic for Applications (VBA)操作不被记录的宏等。本教程附带练习文件。

官网:http://www.lynda.com/home/DisplayCourse.aspx?lpk2=74463

简介摘自:(xuehui@TLF)

In Excel 2010: Macros in Depth, author Dennis Taylor explains how macros can be used to automate tasks in Excel and walks through the process of creating and running simple macros. This course also covers advanced topics such as making macros widely available through the Personal Macro Workbook, recording a macro in stages, absolute and relative recording, and using Visual Basic for Applications (VBA) for actions 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. Exercise files are included with the course.
Topics include:

* Understanding what a macro does
* Recording and adding functionality to a macro
* Running macros
* Creating non-recordable VBA code
* Testing a macro in Step mode
* Joining two macros
* Using loop structures
* Streamlining macros
* Creating a Personal Macro Workbook



会员福利

资源无源时,可利用百度网盘 & 迅雷云盘取回

此内容仅供注册用户。请 %登录%.

神秘内容,请 登录 / 注册 后查看

会员可见全站福利 !


标签: ,


文章类别:

本文链接: https://www.books51.com/188188.html

【点击下方链接,复制 & 分享文章网址】

Excel 2010详解宏语言视频教程 TLF-SOFT-Lynda com Excel 2010 Tutorials Macros in Depth-iRONiSO bin → https://www.books51.com/188188.html

上一篇:

下一篇:

0 ratings, 0 votes0 ratings, 0 votes (0 次顶, 0已投票)
你必须注册后才能投票!
Loading...

添加新评论