中文名: 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
截图预览：
