Excel 2007: 管理多工作表教程 Excel 2007: Managing Multiple Worksheets and Workbooks [光盘镜

游客，本帖隐藏的内容需要积分高于 1 才可浏览，您当前积分为 0

资源信息： 中文名: Excel 2007: 管理多工作表教程 英文名: Excel 2007: Managing Multiple Worksheets and Workbooks 资源格式: 光盘镜像 主讲人: Dennis Taylor 发行日期: 2010年05月20日 地区: 美国 对白语言: 英语 文字语言: 英文 概述:

资源简介: 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 截图预览：

目录: Introduction 02:05 Welcome 01:28 Using the exercise files 00:37 15:35 1. Mastering Utility Tasks Using worksheet navigation tips 04:58 Inserting and deleting sheets 04:00 Copying and moving sheets in a workbook 01:56 Changing tab colors and sheet names 01:36 Hiding and protecting worksheets 03:05 14:05 2. Working with Multiple Worksheets Displaying multiple worksheets 04:25 Copying data and inserting it on different sheets 05:42 Applying global changes to worksheets 03:58 12:28 3. Linking Worksheets with Formulas Creating linkage formulas 02:58 Creating 3D formulas for worksheets 04:32 Summarizing multiple worksheets with PivotTables 04:58 09:47 4. Working with Multiple Workbooks Using workbook navigation tips 02:17 Displaying worksheets from different workbooks 02:47 Moving and copying data across multiple workbooks 04:43 18:17 5. Linking Formulas Across Workbooks Creating formulas that link worksheets in different workbooks 05:46 Locating and managing links between multiple workbooks 07:06 Summarizing data from multiple workbooks with PivotTables 05:25 00:33 Conclusion Goodbye 00:33 资源来自网络收集 未经过一一的质量 安全等检测 只是把收集的资源和各位驴友分享 仅作网络学习交流使用 请勿用于商业用途 ! 希望各位下载的驴友能多多参与分流保源