Excel 2007: Macros深入详解教程 Excel 2007: Macros in Depth [光盘镜像]

游客，本帖隐藏的内容需要积分高于 1 才可浏览，您当前积分为 0

资源信息： 中文名: Excel 2007: Macros深入详解教程 英文名: Excel 2007: Macros in Depth 资源格式: 光盘镜像 主讲人: Dennis Taylor 发行日期: 2010年05月19日 地区: 美国 对白语言: 英语 文字语言: 英文 概述:

资源简介: Lynda出品的Excel 2007: Macros in Depth.深入详解教程. 教程时长: 2小时29分 教学光盘提供有练习素材. 主讲: Dennis Taylor Description: In Excel 2007: Macros in Depth, author Dennis Taylor demonstrates common tasks for which macros are used, and walks through the process of creating and running simple macros. This course also covers more advanced topics, including 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 accompany the course Topics include: Running macros Understanding the VBA environment Storing macros in a Personal Macro Workbook Recording macros in stages Writing VBA code Using loops Debugging macros Testing in step mode Optimizing macros for fast performance 截图预览：

目录: Introduction 01:31 Welcome 01:09 Using the exercise files 00:22 35:26 1. Getting Started Definition and examples 04:36 Single-action macro examples 10:16 Understanding security 07:13 Short examples of the recording method 08:58 Overview of other techniques 04:23 10:28 2. Running a Macro (Execute, Play Back, Etc.) Running macros from the View tab 02:09 Running macros from a keystroke shortcut 02:15 Running macros from the Quick Access toolbar button 02:13 Running macros from an object or ClipArt 03:51 12:58 3. Using VBA Introducing the VBA environment 06:41 Viewing the VBA components 06:17 11:55 4. Recording a Macro in Stages Recording a simple macro 03:04 Adding functionality to a macro 08:51 27:48 5. Creating Non-Recordable VBA Code Understanding absolute and relative references 08:53 For and For Next statements 07:36 Do While and Do Until statements 05:40 Creating interactive macros 05:39 38:51 6. Macro Project: Converting a Mailing List into a Database List Planning a macro 07:36 Recording partial code 06:40 Using loop structures in context 03:30 Testing a macro in Step mode 06:42 Pulling the data together 04:53 Joining two macros 03:25 Streamlining macros 06:05 10:33 7. The Personal Macro Workbook Creating a personal macro workbook for macros with wide applicability 08:37 Closing and updating the personal macro workbook 01:56 00:27 Conclusion Goodbye 00:27 资源来自网络收集 未经过一一的质量 安全等检测 只是把收集的资源和各位驴友分享 仅作网络学习交流使用 请勿用于商业用途 ! 希望各位下载的驴友能多多参与分流保源