[www.ed2k.online]下載基地為您提供軟件、遊戲、圖書、教育等各種資源的ED2K電驢共享下載和MAGNET磁力鏈接下載。
設為首頁
加入收藏
首頁 圖書資源 軟件資源 游戲資源 教育資源 其他資源
 電驢下載基地 >> 其他资源 >> 電腦基礎 >> 《Excel 2007: Macros深入詳解教程》(Excel 2007: Macros in Depth)[光盤鏡像]
《Excel 2007: Macros深入詳解教程》(Excel 2007: Macros in Depth)[光盤鏡像]
下載分級 其他资源
資源類別 電腦基礎
發布時間 2017/7/13
大       小 -
《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
電驢資源下載/磁力鏈接資源下載:
全選
"《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
截圖預覽:


目錄:
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

資源來自網絡收集 未經過一一的質量 安全等檢測
只是把收集的資源和各位驢友分享 僅作網絡學習交流使用 請勿用於商業用途 !
希望各位下載的驢友能多多參與分流保源


相關資源:

免責聲明:本網站內容收集於互聯網,本站不承擔任何由於內容的合法性及健康性所引起的爭議和法律責任。如果侵犯了你的權益,請通知我們,我們會及時刪除相關內容,謝謝合作! 聯系信箱:[email protected]

Copyright © 電驢下載基地 All Rights Reserved