XYZ軟體急先鋒

Lynda com Excel VBA in Depth 英文正式版 (教學)


-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
軟體名稱:Lynda com Excel VBA in Depth 英文正式版 (教學)
語系版本:英文版
光碟片數:單片裝
破解說明:
系統支援:WIN 9x/WIN ME/WIN NT/WIN 2000/WIN XP/WIN 2003
軟體類型:電腦教學認證
硬體需求:PC
更新日期:2010/7/7
官方網站:http://www.lynda.com/home/DisplayCourse.aspx?lpk2=62906
中文網站:http://www.lynda.com/home/DisplayCourse.aspx?lpk2=62906
軟體簡介:
銷售價格:80
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=




軟體簡介:

      

               Lynda com Excel VBA in Depth 英文正式版 (教學)







語言:英語
網址:http://www.lynda.com/home/DisplayCourse.aspx?lpk2=62906
類別:教學 

Lynda.com出品的長達3小時視頻教學中Curt Frye講解了為如何使用VBA的面向物件編程技術自動完成
excel工作和提高excel工作效率。



In Excel: VBA in Depth, Excel and VBA expert Curt Frye
introduces object-oriented programming and shows how to
automate routine tasks and provide custom functionality
to enhance Excel performance and efficiency. This course
introduces the Visual Basic for Applications programming
language, covers creating subroutines and functions to
hold code, and provides a solid grounding in the Excel
2007 object model. Programming techniques are demonstrated
through real-world examples. Exercise files accompany the
course.

Topics include:

* Working in the Visual Basic Editor
* Adding code to a macro
* Creating, exporting, and deleting code modules
* Declaring and using variables
* Managing variable scope
* Defining arrays
* Managing workbooks and worksheets with VBA
* Repeating tasks with loops
* Debugging VBA code
* Cutting, copying, and pasting cell data
* Running and triggering event procedures





             


-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=