資料介紹

• 辦公軟件與office教程
• 計算機資料

資源簡介

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