Lynda.com Excel 2010 Managing Multiple Worksheets and Workbooks

seeders: 12
leechers: 9
Added on February 17, 2015 by VIP-Naruin Other > Tutorials
Torrent verified.



Lynda.com Excel 2010 Managing Multiple Worksheets and Workbooks (Size: 205.04 MB)
 0001 Welcome.mov12.33 MB
 0002 Using the exercise files.mov1.36 MB
 0101 Learning basic navigation tips.mov18.34 MB
 0105 Using the Hide function on worksheet tabs.mov11.09 MB
 0102 Inserting and deleting new sheets.mov8.33 MB
 0103 Copying and moving sheets within a workbook.mov7.55 MB
 0104 Changing tab colors and renaming sheets.mov5.39 MB
 0201 Displaying multiple worksheets from the same workbook.mov17.55 MB
 0203 Applying global changes to worksheets.mov7.37 MB
 0202 Copying, moving, and inserting data on different sheets.mov5.61 MB
 0303 Summarizing multiple worksheets with PivotTables or Consolidate.mov19.51 MB
 0302 Creating 3D formulas for worksheets with identical layouts.mov10.32 MB
 0301 Creating linkage formulas.mov6.84 MB
 0403 Copying and moving data and entire worksheets across different workbooks.mov11.98 MB
 0402 Displaying multiple worksheets from different workbooks.mov9.97 MB
 0401 Navigating between open workbooks.mov7 MB
 0503 Summarizing data from multiple workbooks with PivotTables or Consolidate.mov19.17 MB
 0502 Locating and managing links between multiple workbooks.mov11.02 MB
 0501 Creating formulas that link worksheets in different workbooks.mov7.71 MB
 0601 Final thoughts.mov2.71 MB
 Chartdata2011.xlsx938.44 KB
 DivisionFiles.xlsx367.64 KB
 QuarterlyBudget.xlsx73.76 KB
 StateSalesData.xlsx50.1 KB
 Olive-California.xlsx22.36 KB
 Olive-Arizona.xlsx21.39 KB
 Olive-Oregon.xlsx20.96 KB
 Olive-Nevada.xlsx20.43 KB
 sample.xlsx370.84 KB
 HiddenSheets.xlsx369.35 KB
 Hyperlink State File.xlsx118.8 KB
 RegionalFile.xlsx21.33 KB
 SalesData.xlsx21.29 KB
 RegionalFile2.xlsx21.22 KB
 CorporateData.xlsx369.5 KB
 california.xlsx28.3 KB
 washington.xlsx28.29 KB
 Oregon.xlsx28.27 KB
 Arizona.xlsx28.22 KB
 Olive-California.xlsx22.36 KB
 Olive-Arizona.xlsx21.39 KB
 Olive-Oregon.xlsx20.96 KB
 Olive-Nevada.xlsx20.43 KB
 CorpLink.xlsx15.37 KB
 DepartmentData.xlsx367.65 KB
 sample.xlsx367.61 KB
 SalesData.xlsx21.32 KB
 RegionalData.xlsx21.3 KB
 3D formulas.xlsx111.51 KB
 LinkageFormulas.xlsx21.64 KB
 sample.xlsx21.3 KB
 PivotTableSummary.xlsx20.79 KB

Description

1h 29m Intermediate Jan 07, 2011

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

Source page
Software:
Excel Office
Author:
Dennis Taylor


Related Torrents

torrent name size seed leech

Sharing Widget


Download torrent
205.04 MB
seeders:12
leechers:9
Lynda.com Excel 2010 Managing Multiple Worksheets and Workbooks