《Excel 2007: Macros深入详解教程》(Excel 2007: Macros in Depth)[光盘镜像]
中文名: 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
截图预览：
