Excel 2007: 管理多工作表教程

:

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

截图预览：

本文链接: https://www.books51.com/29315.html

上一篇: Word 2007:邮件合并功能深入讲解教程

下一篇: Word 2010: 邮件合并深入讲解教程

(0 次顶, 0 人已投票)
你必须注册后才能投票！

Loading...