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
Download File Size:111.61 MB