In Excel 2010: Managing Multiple Worksheets and Workbooks, author
Dennis Taylor shows how to share data between multiple worksheets
and workbooks 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 worksheets,
make super-efficient 3D 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:188.15 MB