【Lynda】Excel 2007 Essential Training【CHN】中英文字幕[SRT]
==========教程信息=====================================================
教程名称：Excel 2007 Essential Training
作者：Lorna Daly
主题：Business, Spreadsheets
使用软件：Excel 2007
难度等级：初级
时长： 5h 13m
发布日期： Jan 31, 2007
┏ACELY STUDIO，2012
┃更多资源请访问
┃◆唯一发布站：ACELY.CN
┗◆我的博客：http://blog.sina.com.cn/u/1991840741
==========教程目录文件列表=============================================
Excel 2007 Essential Training[SRT]
├─◆0. Introduction
│ └─◇ 0001 Welcome.srt
├─◆1. Getting Started
│ └─◇ 0101 Why use a spreadsheet.srt
│ └─◇ 0102 What’s changed in Excel 2007.srt
│ └─◇ 0103 The Ribbon.srt
│ └─◇ 0104 The Microsoft Office Button.srt
├─◆2. Setting Up Excel 2007
│ └─◇ 0201 What’s on the Ribbon.srt
│ └─◇ 0202 Making your way around the Ribbon.srt
│ └─◇ 0203 Customizing the Ribbon.srt
│ └─◇ 0204 Customizing the Microsoft Office Button.srt
├─◆3. Modifying Worksheets
│ └─◇ 0301 Opening old worksheets.srt
│ └─◇ 0302 Adding and deleting worksheets.srt
│ └─◇ 0303 Inserting and deleting cells.srt
│ └─◇ 0304 Freezing areas of a worksheet.srt
├─◆4. Basic Formatting
│ └─◇ 0401 Width and height.srt
│ └─◇ 0402 Numeric formats.srt
│ └─◇ 0403 Alignment of data.srt
│ └─◇ 0404 Playing with fonts.srt
│ └─◇ 0405 AutoFilter.srt
│ └─◇ 0406 Formatting as a table.srt
├─◆5. Advanced Formatting
│ └─◇ 0501 Removing duplicates.srt
│ └─◇ 0502 What is Conditional Formatting.srt
│ └─◇ 0503 Working with Conditional Formatting.srt
│ └─◇ 0504 Managing Conditional Formatting rule preferences.srt
│ └─◇ 0505 Converting text to columns.srt
│ └─◇ 0506 Data validation.srt
├─◆6. Using Templates, Styles, and AutoFormat
│ └─◇ 0601 Templates.srt
│ └─◇ 0602 Styles.srt
│ └─◇ 0603 AutoFormat.srt
├─◆7. Managing Lists in Excel
│ └─◇ 0701 Excel lists have now become tables.srt
│ └─◇ 0702 Converting text to columns.srt
│ └─◇ 0703 Sorting and Grouping.srt
│ └─◇ 0704 Creating a summary report.srt
├─◆8. Reviewing Worksheets
│ └─◇ 0801 Proofing your work.srt
│ └─◇ 0802 Providing comments on worksheets.srt
├─◆9. Sharing Worksheets
│ └─◇ 0901 Protecting and sharing a worksheet.srt
│ └─◇ 0902 Allowing others to edit ranges.srt
│ └─◇ 0903 Track Changes.srt
├─◆10. Printing Workbooks
│ └─◇ 1001 Preparing to print.srt
│ └─◇ 1002 Print Preview.srt
│ └─◇ 1003 The Page Layout Tab.srt
│ └─◇ 1004 Page Breaks.srt
│ └─◇ 1005 The Page Layout View.srt
│ └─◇ 1006 Headers and Footers.srt
├─◆11. Enhancing Worksheets
│ └─◇ 1101 Adding themes to your worksheet.srt
│ └─◇ 1102 Page setup options.srt
│ └─◇ 1103 Scale to Fit.srt
│ └─◇ 1104 Worksheet options.srt
│ └─◇ 1105 Inserting images.srt
├─◆12. Using Templates
│ └─◇ 1201 Using templates.srt
├─◆13. Manipulating the Screen Display
│ └─◇ 1301 Workbook Views.srt
│ └─◇ 1302 Hiding and Zooming.srt
│ └─◇ 1303 Window Panes.srt
│ └─◇ 1304 More screen options.srt
├─◆14. Importing Data
│ └─◇ 1401 Importing from Access.srt
│ └─◇ 1402 Using the Import Wizard for text files.srt
├─◆15. Finding and Replacing Data
│ └─◇ 1501 The Find and Select button.srt
│ └─◇ 1502 Find and Replace.srt
│ └─◇ 1503 Removing duplicates.srt
├─◆16. Working with Formulas
│ └─◇ 1601 What are formulas.srt
│ └─◇ 1602 Order of Operations.srt
│ └─◇ 1603 Relative and absolute referencing.srt
│ └─◇ 1604 The new Formula Tab.srt
├─◆17. Working with Basic Functions
│ └─◇ 1701 What are Functions.srt
│ └─◇ 1702 AutoSum.srt
│ └─◇ 1703 Minimum.srt
│ └─◇ 1704 Trim.srt
│ └─◇ 1705 Left.srt
├─◆18. Working with Advanced Functions
│ └─◇ 1801 Concatenation.srt
│ └─◇ 1802 SumIf.srt
│ └─◇ 1803 Lookup.srt
│ └─◇ 1804 What-If Analysis.srt
├─◆19. Charts
│ └─◇ 1901 Why create a chart.srt
│ └─◇ 1902 Creating your chart.srt
│ └─◇ 1903 Modifying your chart.srt
│ └─◇ 1904 Laying out your chart.srt
├─◆20. Pivot Tables
│ └─◇ 2001 What are PivotTable reports and PivotChart reports.srt
│ └─◇ 2002 Creating a PivotTable.srt
│ └─◇ 2003 Laying out your PivotTable.srt
│ └─◇ 2004 Designing your PivotTable.srt
│ └─◇ 2005 Creating a PivotChart.srt
├─◆21. Working with Macros
│ └─◇ 2101 Why use macros.srt
│ └─◇ 2102 Creating a macro.srt
│ └─◇ 2103 Macro security.srt
├─◆22. Workflow in Excel 2007
│ └─◇ 2201 Reviewing a workflow in Excel.srt
├─◆Conclusion
│ └─◇ Conclusion.srt
◇
【本字幕由ACELY.CN独家制作发布】
┏
┃本套教程字幕包含中文字幕
┃中文字幕使用机器翻译，对翻译结果中不当内容不承担任何责任！
┃更多中文字幕请访问唯一发布站【ACELY.CN】
┃本站中文字幕未经允许一律严禁转载！
┗