資料介紹

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

資源簡介:

Lynda出品的Excel 2007: Managing Multiple Worksheets and Workbooks. 利用Excel 2007管理多工作表及工作簿教程.Dennis Taylor 講解了如何復制和轉移資料到多個工作表中、介紹了很多添加、移動和定位工作表的使用技巧. 涵蓋了使用全局修改、創建簡單的公式來關聯不同的工作邊、使用三維公式來進行多工作表內容匯總..........

教程時長: 1小時12分

主講: Dennis Taylor

Description:

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

截圖預覽：