【Lynda】Excel 2007: Macros in Depth【CHN】中英文字幕[SRT]
==========教程信息=====================================================
教程名称:Excel 2007: Macros in Depth
作者:Dennis Taylor
主题:Business, Productivity, Spreadsheets
使用软件:Excel 2007
难度等级:中级
时长: 2h 29m
发布日期: May 19, 2010
┏ACELY STUDIO,2012
┃更多资源请访问
┃◆唯一发布站:ACELY.CN
┗◆我的博客:http://blog.sina.com.cn/u/1991840741
==========教程目录文件列表=============================================
Excel 2007- Macros in Depth[SRT]
├─◆0. Introduction
│ └─◇ 0001 Welcome.srt
│ └─◇ 0002 Using the exercise files.srt
├─◆1. Getting Started
│ └─◇ 0101 Definition and examples.srt
│ └─◇ 0102 Single-action macro examples.srt
│ └─◇ 0103 Understanding security.srt
│ └─◇ 0104 Short examples of the recording method.srt
│ └─◇ 0105 Overview of other techniques.srt
├─◆2. Running a Macro (Execute, Play Back, Etc.)
│ └─◇ 0201 Running macros from the View tab.srt
│ └─◇ 0202 Running macros from a keystroke shortcut.srt
│ └─◇ 0203 Running macros from the Quick Access toolbar button.srt
│ └─◇ 0204 Running macros from an object or ClipArt.srt
├─◆3. Using VBA
│ └─◇ 0301 Introducing the VBA environment.srt
│ └─◇ 0302 Viewing the VBA components.srt
├─◆4. Recording a Macro in Stages
│ └─◇ 0401 Recording a simple macro.srt
│ └─◇ 0402 Adding functionality to a macro.srt
├─◆5. Creating Non-Recordable VBA Code
│ └─◇ 0501 Understanding absolute and relative references.srt
│ └─◇ 0502 For and For Next statements.srt
│ └─◇ 0503 Do While and Do Until statements.srt
│ └─◇ 0504 Creating interactive macros.srt
├─◆6. Macro Project- Converting a Mailing List into a Database List
│ └─◇ 0601 Planning a macro.srt
│ └─◇ 0602 Recording partial code.srt
│ └─◇ 0603 Using loop structures in context.srt
│ └─◇ 0604 Testing a macro in Step mode.srt
│ └─◇ 0605 Pulling the data together.srt
│ └─◇ 0606 Joining two macros.srt
│ └─◇ 0607 Streamlining macros.srt
├─◆7. The Personal Macro Workbook
│ └─◇ 0701 Creating a personal macro workbook for macros with wide applicability.srt
│ └─◇ 0702 Closing and updating the personal macro workbook.srt
├─◆Conclusion
│ └─◇ Goodbye.srt
◇
【本字幕由ACELY.CN独家制作发布】
┏
┃本套教程字幕包含中文字幕
┃中文字幕使用机器翻译,对翻译结果中不当内容不承担任何责任!
┃更多中文字幕请访问唯一发布站【ACELY.CN】
┃本站中文字幕未经允许一律严禁转载!
┗