![]()
軟體簡介:
Lynda com Excel 2007 Macros in Depth 英文正式版(Excel 2007: 財務分析教學)
Lynda.com推出的教學 Excel 2007: 財務分析 (Excel 2007: Financial Analysis)
主講：Curt Frye
官方網站 http://www.lynda.com/home/DisplayCourse.aspx?lpk2=52291
數位和財務資料正在驅動著當今的商業世界，本教學旨在幫助讀者瞭解這方面的資訊。
正確的理解這些數位以及數位背後的公式，是企業與個人通往成功之路的關鍵。微軟
的MVP(最有價值專家) Curt Frye 在教學中講解了在公司理財中基本流暢性(fluency)
，使得用戶能夠看到基本財務計算背後的意義。Curt 介紹了如何進行公式審查以確保
適當的投入，並說明了如何解釋公式輸出。他還介紹了如何計算杠杆比率，攤銷，折
舊時間表，以及預測未來增長。
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 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
