Lynda com Excel 2010 Managing Multiple Worksheets and Workbooks | 2DB7BF427DAB5D85F04BCC2247FB36666F43694F

Lynda com Excel 2010 Managing Multiple Worksheets and Workbooks

Name	Lynda.com.Excel.2010.Managing.Multiple.Worksheets.and.Workbooks	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	215.0 MB
Total Files	54
Hash	2DB7BF427DAB5D85F04BCC2247FB36666F43694F

/00 Introduction/
0001 Welcome.mov	12.9 MB
0002 Using the exercise files.mov	1.4 MB
/01 Mastering the Utility Tasks Associated with Multiple Worksheets/
0101 Learning basic navigation tips.mov	19.2 MB
0102 Inserting and deleting new sheets.mov	8.7 MB
0103 Copying and moving sheets within a workbook.mov	7.9 MB
0104 Changing tab colors and renaming sheets.mov	5.7 MB
0105 Using the Hide function on worksheet tabs.mov	11.6 MB
/02 Working with Multiple Worksheets/
0201 Displaying multiple worksheets from the same workbook.mov	18.4 MB
0202 Copying, moving, and inserting data on different sheets.mov	5.9 MB
0203 Applying global changes to worksheets.mov	7.7 MB
/03 Linking Worksheets with Formulas/
0301 Creating linkage formulas.mov	7.2 MB
0302 Creating 3D formulas for worksheets with identical layouts.mov	10.8 MB
0303 Summarizing multiple worksheets with PivotTables or Consolidate.mov	20.5 MB
/04 Working with Multiple Workbooks/
0401 Navigating between open workbooks.mov	7.3 MB
0402 Displaying multiple worksheets from different workbooks.mov	10.5 MB
0403 Copying and moving data and entire worksheets across different workbooks.mov	12.6 MB
/05 Linking Formulas Across Multiple Workbooks/
0501 Creating formulas that link worksheets in different workbooks.mov	8.1 MB
0502 Locating and managing links between multiple workbooks.mov	11.6 MB
0503 Summarizing data from multiple workbooks with PivotTables or Consolidate.mov	20.1 MB
/06 Conclusion/
0601 Final thoughts.mov	2.8 MB
/Exercise Files/Chapter 01/
HiddenSheets.xlsx	378.2 KB
Hyperlink State File.xlsx	121.6 KB
RegionalFile.xlsx	21.8 KB
RegionalFile2.xlsx	21.7 KB
SalesData.xlsx	21.8 KB
Sample.xlsx	379.7 KB
/Exercise Files/Chapter 02/
DepartmentData.xlsx	376.5 KB
RegionalData.xlsx	21.8 KB
SalesData.xlsx	21.8 KB
Sample.xlsx	376.4 KB
/Exercise Files/Chapter 03/
3D Formulas.xlsx	114.2 KB
LinkageFormulas.xlsx	22.2 KB
PivotTableSummary.xlsx	21.3 KB
Sample.xlsx	21.8 KB
/Exercise Files/Chapter 04/
Chartdata2011.xlsx	961.0 KB
DivisionFiles.xlsx	376.5 KB
Olive-Arizona.xlsx	21.9 KB
Olive-California.xlsx	22.9 KB
Olive-Nevada.xlsx	20.9 KB
Olive-Oregon.xlsx	21.5 KB
QuarterlyBudget.xlsx	75.5 KB
StateSalesData.xlsx	51.3 KB
/Exercise Files/Chapter 05/
Arizona.xlsx	28.9 KB
California.xlsx	29.0 KB
CorpLink.xlsx	15.7 KB
CorporateData.xlsx	378.4 KB
Olive-Arizona.xlsx	21.9 KB
Olive-California.xlsx	22.9 KB
Olive-Nevada.xlsx	20.9 KB
Olive-Oregon.xlsx	21.5 KB
Olive-WesternConsolidation.xlsx	8.4 KB
Oregon.xlsx	28.9 KB
Washington.xlsx	29.0 KB
~$CorporateData.xlsx	0.2 KB
Total files 54