Lynda Excel 2010 Managing Multiple Worksheets and Workbooks

Home
Software for Windows
Lynda Excel 2010 Managing Multiple Worksheets and Workbooks

Lynda Excel 2010 Managing Multiple Worksheets and Workbooks

Price:

$19.95

Vendor:

Lynda

Payment methods:

Delivery Method:

Electronic Download

Product Videos

lynda.com Tutorial | Excel 2010: Managing Worksheets and Workbooks—Tab colors and renaming (02:55)

Watch the entire course at http://www.lynda.com/home/DisplayCourse.aspx?lpk2=75924&utm_source=youtube&utm_medium=viral&utm_content=youtube&utm_campaign=youtubeIn 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.

Product Videos

Product Description

Lynda Excel 2010 Managing Multiple Worksheets and Workbooks

Author: Dennis Taylor
Duration (hr:min): 01:29
Released on: 2011
Exercise files: Yes
Software works on: Windows only

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

Content:

Introduction - 00:01:46

Welcome - 00:01:27
Using the exercise files - 00:00:19

1. Mastering the Utility Tasks Associated with Multiple Worksheets - 00:29:15

Learning basic navigation - 00:11:36
Inserting and deleting new sheets - 00:04:47
Copying and moving sheets within a workbook - 00:05:59
Changing tab colors and renaming sheets - 00:02:47
Using the Hide function on worksheet tabs - 00:04:06

2. Working with Multiple Worksheets - 00:13:26

Displaying multiple worksheets from the same workbook - 00:06:35
Copying, moving, and inserting data on different sheets - 00:02:43
Applying global changes to worksheets - 00:04:08

3. Linking Worksheets with Formulas - 00:16:29

Creating linkage formulas - 00:04:09
Creating 3D formulas for worksheets with identical layouts - 00:05:31
Summarizing multiple worksheets with PivotTables or Consolidate - 00:06:49

4. Working with Multiple Workbooks - 00:11:25

Navigating between open workbooks -00:02:04
Displaying multiple worksheets from different workbooks - 00:04:04
Copying and moving data and entire worksheets across different workbooks - 00:05:17

5. Linking Formulas Across Multiple Workbooks - 00:16:19

Creating formulas that link worksheets in different workbooks - 00:04:01
Locating and managing links between multiple workbooks - 00:04:54
Summarizing data from multiple workbooks with PivotTables or Consolidate - 00:07:24

Conclusion - 00:00:32