v

您的位置:VeryCD教育计算机


《Excel 2010:详解宏语言视频教程》(Lynda.com Excel 2010 Tutorials Macros in Depth)[光盘镜像]

  • 状态: 精华资源
  • 摘要:
    发行日期2011年
    对白语言英语
    文字语言英文
  • 时间: 2011/02/01 16:23:58 发布 | 2011/02/02 01:33:37 更新
  • 分类: 教育  计算机 

xiaochenjia

精华资源: 673

全部资源: 675

相关: 分享到新浪微博   转播到腾讯微博   分享到开心网   分享到人人   分享到QQ空间   订阅本资源RSS更新   美味书签  subtitle
该内容尚未提供权利证明,无法提供下载。
中文名Excel 2010:详解宏语言视频教程
英文名Lynda.com Excel 2010 Tutorials Macros in Depth
资源格式光盘镜像
发行日期2011年
地区美国,日本
对白语言英语
文字语言英文
简介

IPB Image

资源简介

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



目录

Introduction
Welcome 01:12
Using the exercise files 00:16
27:15 1. Getting Started
Understanding what a macro does 07:31
Reviewing macro examples 04:29
Understanding security 03:40
Reviewing the recording method 07:27
Understanding other techniques for macros 04:08
14:34 2. Running a Macro (Execute, Play Back, Etc.)
Running macros from the View tab 01:31
Running macros from a keyboard shortcut 02:32
Running macros from the Quick Access toolbar button 06:35
Running macros from an object or clip art 03:56
10:45 3. Using Visual Basic for Applications (VBA)
Introducing the VBA environment 03:55
Viewing the VBA components 06:50
14:04 4. Recording a Macro in Stages
Recording a simple macro 05:52
Adding functionality to a macro 08:12
32:59 5. Creating Non-Recordable VBA Code
Understanding absolute and relative references 10:25
Using For and For...Next statements 08:33
Using Do...While and Do...Until statements 07:58
Creating interactive macros 06:03
48:51 6. Macro Project: Converting a Mailing List into a Database List
Planning a macro 03:51
Recording partial code 10:31
Using loop structures in context 06:40
Testing a macro in Step mode 09:31
Pulling the data together 07:11
Joining two macros 04:15
Streamlining macros 06:52
14:00 7. The Personal Macro Workbook
Creating a personal macro workbook for macros with wide applicability 09:14
Closing and updating the personal macro workbook 04:46
00:27 Conclusion
Final thoughts 00:27

引用

引用
希望更多的网友加入到国外名校开放课程整理、发布的队伍中来...

引用
下载链接来自TLF

引用
资源来自网络收集 未经过一 一的质量 安全等检测
只是把收集的资源和各位驴友分享 仅作网络学习交流使用 请勿用于商业用途 !
希望各位下载的驴友能多多参与分流保源 happy.gif

正在读取……

这里是其它用户补充的资源(我也要补充):

暂无补充资源
正在加载,请稍等...

点击查看所有39网友评论

 

(?) [公告]留口水、评论相关规则 | [活动]每日签到 轻松领取电驴经验

    小贴士:
  1. 类似“顶”、“沙发”之类没有营养的文字,对勤劳贡献的楼主来说是令人沮丧的反馈信息。
  2. 提问之前请再仔细看一遍楼主的说明,或许是您遗漏了。
  3. 勿催片。请相信驴友们对分享是富有激情的,如果确有更新版本,您一定能搜索到。
  4. 请勿到处挖坑绊人、招贴广告。既占空间让人厌烦,又没人会搭理,于人于己都无利。
  5. 如果您发现自己的评论不见了,请参考以上4条。