【Lynda】Excel 2010: Managing Multiple Worksheets and Workbooks【CHN】中英文字幕[SRT]
==========教程信息=====================================================
教程名称：Excel 2010: Managing Multiple Worksheets and Workbooks
作者：Dennis Taylor
主题：Business, Spreadsheets
使用软件：Excel 2010, Office 2010
难度等级：中级
时长： 1h 29m
发布日期： Jan 07, 2011
┏ACELY STUDIO，2012
┃更多资源请访问
┃◆唯一发布站：ACELY.CN
┗◆我的博客：http://blog.sina.com.cn/u/1991840741
==========教程目录文件列表=============================================
Excel 2010- Managing Multiple Worksheets and Workbooks[SRT]
├─◆0. Introduction
│ └─◇ 0001 Welcome.srt
│ └─◇ 0002 Using the exercise files.srt
├─◆1. Mastering the Utility Tasks Associated with Multiple Worksheets
│ └─◇ 0101 Learning basic navigation tips.srt
│ └─◇ 0102 Inserting and deleting new sheets.srt
│ └─◇ 0103 Copying and moving sheets within a workbook.srt
│ └─◇ 0104 Changing tab colors and renaming sheets.srt
│ └─◇ 0105 Using the Hide function on worksheet tabs.srt
├─◆2. Working with Multiple Worksheets
│ └─◇ 0201 Displaying multiple worksheets from the same workbook.srt
│ └─◇ 0202 Copying, moving, and inserting data on different sheets.srt
│ └─◇ 0203 Applying global changes to worksheets.srt
├─◆3. Linking Worksheets with Formulas
│ └─◇ 0301 Creating linkage formulas.srt
│ └─◇ 0302 Creating 3D formulas for worksheets with identical layouts.srt
│ └─◇ 0303 Summarizing multiple worksheets with PivotTables or Consolidate.srt
├─◆4. Working with Multiple Workbooks
│ └─◇ 0401 Navigating between open workbooks.srt
│ └─◇ 0402 Displaying multiple worksheets from different workbooks.srt
│ └─◇ 0403 Copying and moving data and entire worksheets across different workbooks.srt
├─◆5. Linking Formulas Across Multiple Workbooks
│ └─◇ 0501 Creating formulas that link worksheets in different workbooks.srt
│ └─◇ 0502 Locating and managing links between multiple workbooks.srt
│ └─◇ 0503 Summarizing data from multiple workbooks with PivotTables or Consolidate.srt
├─◆Conclusion
│ └─◇ Final thoughts.srt
◇
【本字幕由ACELY.CN独家制作发布】
┏
┃本套教程字幕包含中文字幕
┃中文字幕使用机器翻译，对翻译结果中不当内容不承担任何责任！
┃更多中文字幕请访问唯一发布站【ACELY.CN】
┃本站中文字幕未经允许一律严禁转载！
┗