Lynda com Excel 2007 Managing Multiple Worksheets and Workbooks 英文正式版(Microsoft Office Excel 2007: 財務分析教學)
![]()
軟體簡介:
Lynda com Excel 2007 Managing Multiple Worksheets and Workbooks 英文正式版(Microsoft Office Excel 2007: 財務分析教學)
【內容說明】★◇以下中文譯文說明僅供參考，實際軟體內容請依參考網址介紹為準◇★
數位和財務資料正在驅動著當今的商業世界，本教程旨在幫助讀者瞭解這方面
的資訊。正確的理解這些數位以及數位背後的公式，是企業與個人通往成功之
路的關鍵。微軟的MVP(最有價值專家) Curt Frye 在教程中講解了在公司理財
中基本流暢性(fluency)，使得用戶能夠看到基本財務計算背後的意義。Curt
介紹了如何進行公式審查以確保適當的投入，並說明了如何解釋公式輸出。他
還介紹了如何計算杠杆比率，攤銷，折舊時間表，以及預測未來增長。
In Excel 2007: Managing Multiple Worksheets and Workbooks,
author Dennis Taylor shows how to move and copy data to
multiple worksheets and gives tips for adding, moving, and
navigating worksheets and workbooks efficiently. This
course covers how to make global changes, create simple
formulas that connect different worksheets, make super-
efficient 3-D formulas to calculate summary totals from
multiple worksheets, and use pivot tables to summarize
data from multiple workbooks. Exercise files accompany
the course.
Topics include:
* Navigating across worksheets and workbooks
* Displaying multiple worksheets or workbooks simultaneously
* Inserting, deleting, moving, and copying sheets
* Changing sheet names and tab colors
* Showing and hiding worksheets
* Creating linkage formulas among workbooks
* Locating and managing links
