xyz軟體王

DVD1585--Alias Discover Maya Medical Visualization 英文光碟正式版 (DVD版)
DVD13515--Neil Peart Taking Center Stage A Lifetime Of Live Performance 2011 D1 教學 英文正式版(DVD一片裝)
DVD5718--駭客攻擊類比多媒體自學教程 英文正式版 Career Academy Computer Forensics Training Digital Forensics and Electronic Discovery-NSiD(dvd7片裝)
TIC1324--TestsNow CIW 1D0-510 Exam Q And A.v2.31-DDU英文正式版(認證考試問答軟體)
CB1975-2--Lynda.com Advanced ActionScript 2.0 in Macromedia Flash MX 2004 英文教學光碟正式版(2CD)

軟體簡介:



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