Lynda - Excel 2010: Managing Multiple Worksheets and Workbooks with Dennis Taylor

seeders: 26

leechers: 11

Download torrent

Added on January 24, 2015 by webcentarain Other > Tutorials
Torrent verified.

Main

add to bookmarks

Lynda - Excel 2010: Managing Multiple Worksheets and Workbooks with Dennis Taylor (Size: 205.04 MB)

		0001 Welcome.mov	12.33 MB
		0002 Using the exercise files.mov	1.36 MB
		0101 Learning basic navigation tips.mov	18.34 MB
		0105 Using the Hide function on worksheet tabs.mov	11.09 MB
		0102 Inserting and deleting new sheets.mov	8.33 MB
		0103 Copying and moving sheets within a workbook.mov	7.55 MB
		0104 Changing tab colors and renaming sheets.mov	5.39 MB
		0201 Displaying multiple worksheets from the same workbook.mov	17.55 MB
		0203 Applying global changes to worksheets.mov	7.37 MB
		0202 Copying, moving, and inserting data on different sheets.mov	5.61 MB
		0303 Summarizing multiple worksheets with PivotTables or Consolidate.mov	19.51 MB
		0302 Creating 3D formulas for worksheets with identical layouts.mov	10.32 MB
		0301 Creating linkage formulas.mov	6.84 MB
		0403 Copying and moving data and entire worksheets across different workbooks.mov	11.98 MB
		0402 Displaying multiple worksheets from different workbooks.mov	9.97 MB
		0401 Navigating between open workbooks.mov	7 MB
		0503 Summarizing data from multiple workbooks with PivotTables or Consolidate.mov	19.17 MB
		0502 Locating and managing links between multiple workbooks.mov	11.02 MB
		0501 Creating formulas that link worksheets in different workbooks.mov	7.71 MB
		0601 Final thoughts.mov	2.71 MB
		Chartdata2011.xlsx	938.44 KB
		DivisionFiles.xlsx	367.64 KB
		QuarterlyBudget.xlsx	73.76 KB
		StateSalesData.xlsx	50.1 KB
		Olive-California.xlsx	22.36 KB
		Olive-Arizona.xlsx	21.39 KB
		Olive-Oregon.xlsx	20.96 KB
		Olive-Nevada.xlsx	20.43 KB
		sample.xlsx	370.84 KB
		HiddenSheets.xlsx	369.35 KB
		Hyperlink State File.xlsx	118.8 KB
		RegionalFile.xlsx	21.33 KB
		SalesData.xlsx	21.29 KB
		RegionalFile2.xlsx	21.22 KB
		CorporateData.xlsx	369.5 KB
		california.xlsx	28.3 KB
		washington.xlsx	28.29 KB
		Oregon.xlsx	28.27 KB
		Arizona.xlsx	28.22 KB
		Olive-California.xlsx	22.36 KB
		Olive-Arizona.xlsx	21.39 KB
		Olive-Oregon.xlsx	20.96 KB
		Olive-Nevada.xlsx	20.43 KB
		CorpLink.xlsx	15.37 KB
		DepartmentData.xlsx	367.65 KB
		sample.xlsx	367.61 KB
		SalesData.xlsx	21.32 KB
		RegionalData.xlsx	21.3 KB
		3D formulas.xlsx	111.51 KB
		LinkageFormulas.xlsx	21.64 KB
		sample.xlsx	21.3 KB
		PivotTableSummary.xlsx	20.79 KB

Description

Lynda - Excel 2010: Managing Multiple Worksheets and Workbooks with Dennis Taylor

Subjects: Business Spreadsheets
Software: Excel Office

1h 29m Intermediate Jan 07, 2011 | Uploaded in Jan 24, 2015 Via Webcentara

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

###################################################

Sharing Widget

Download torrent

205.04 MB

seeders:26

leechers:11

Lynda - Excel 2010: Managing Multiple Worksheets and Workbooks with Dennis Taylor