【Lynda】Excel 2010 Essential Training【CHN】中英文字幕[SRT]
==========教程信息=====================================================
教程名称：Excel 2010 Essential Training
作者：Bob Flisser
主题：Business, Computer Skills (Windows), Spreadsheets
使用软件：Excel 2010
难度等级：初级
时长： 6h 21m
发布日期： Jun 09, 2010
┏ACELY STUDIO，2012
┃更多资源请访问
┃◆唯一发布站：ACELY.CN
┗◆我的博客：http://blog.sina.com.cn/u/1991840741
==========教程目录文件列表=============================================
Excel 2010 Essential Training[SRT]
├─◆0. Introduction
│ └─◇ 0001 Welcome.srt
│ └─◇ 0002 Using the exercise files.srt
├─◆1. Getting Started
│ └─◇ 0101 Exploring three common uses for Excel.srt
│ └─◇ 0102 Touring the interface.srt
│ └─◇ 0103 Finding the commands you need.srt
│ └─◇ 0104 Using Backstage view or the File tab.srt
│ └─◇ 0105 Maintaining file compatibility.srt
├─◆2. Worksheet Basics
│ └─◇ 0201 Creating a worksheet.srt
│ └─◇ 0202 Techniques for copying and pasting.srt
│ └─◇ 0203 Entering data automatically with Auto Fill.srt
│ └─◇ 0204 Targeting large data groups.srt
│ └─◇ 0205 Changing a worksheet’s structure.srt
├─◆3. Excel Formula Basics
│ └─◇ 0301 Understanding formulas and functions.srt
│ └─◇ 0302 Entering data in a worksheet.srt
│ └─◇ 0303 Adding numbers manually.srt
│ └─◇ 0304 Adding numbers using Sum and AutoSum.srt
│ └─◇ 0305 Adding a whole worksheet.srt
│ └─◇ 0306 Working with numbers in columns.srt
│ └─◇ 0307 Preventing errors using absolute references.srt
│ └─◇ 0308 Working with times and dates.srt
│ └─◇ 0309 Using IF.srt
│ └─◇ 0310 Using SUMIF and AVERAGEIF.srt
│ └─◇ 0311 Naming and using cell ranges.srt
├─◆4. Essential Formatting
│ └─◇ 0401 Formatting numbers and dates.srt
│ └─◇ 0402 Applying fonts, background colors, and borders.srt
│ └─◇ 0403 Adjusting columns, rows, and text.srt
│ └─◇ 0404 Using conditional formatting.srt
│ └─◇ 0405 Using custom conditional formatting.srt
│ └─◇ 0406 Adding pictures and shapes.srt
├─◆5. Advanced Formatting
│ └─◇ 0501 Inserting SmartArt.srt
│ └─◇ 0502 Coordinating a look using themes.srt
│ └─◇ 0503 Applying built-in styles.srt
│ └─◇ 0504 Creating and sharing styles.srt
│ └─◇ 0505 Using templates.srt
│ └─◇ 0506 Creating and using original templates.srt
├─◆6. Printing Preparation
│ └─◇ 0601 Making the pieces fit.srt
│ └─◇ 0602 Inserting headers and footers.srt
│ └─◇ 0603 Printing and PDFs.srt
├─◆7. Large Excel Projects
│ └─◇ 0701 Finding and replacing data.srt
│ └─◇ 0702 Freezing panes.srt
│ └─◇ 0703 Repeating row and column titles.srt
│ └─◇ 0704 Creating multiple custom worksheet views.srt
│ └─◇ 0705 Hiding or grouping rows and columns.srt
│ └─◇ 0706 Managing worksheets.srt
│ └─◇ 0707 Calculating formulas across worksheets.srt
├─◆8. Collaborating with Others
│ └─◇ 0801 Importing and exporting data in Excel.srt
│ └─◇ 0802 Setting workbook permissions.srt
│ └─◇ 0803 Inserting and editing comments.srt
│ └─◇ 0804 Sharing a workbook.srt
│ └─◇ 0805 Tracking changes.srt
│ └─◇ 0806 Saving files in shared locations.srt
├─◆9. Exploring Excel’s Database Features
│ └─◇ 0901 Splitting cell data into multiple cells.srt
│ └─◇ 0902 Joining data from multiple cells.srt
│ └─◇ 0903 Basic and multi-field sorting.srt
│ └─◇ 0904 Using tables to sort and filter data.srt
│ └─◇ 0905 Inserting automatic subtotals.srt
│ └─◇ 0906 Creating lookup tables.srt
├─◆10. Analyzing Data
│ └─◇ 1001 Using auditing to diagram.srt
│ └─◇ 1002 Using evaluation in Excel.srt
│ └─◇ 1003 Working with Goal Seek.srt
│ └─◇ 1004 Using data tables in formulas.srt
│ └─◇ 1005 Using scenarios in formulas.srt
│ └─◇ 1006 Exploring the Analysis Toolpak.srt
├─◆11. Advanced Analysis with PivotTables
│ └─◇ 1101 Discovering PivotTables.srt
│ └─◇ 1102 Creating a basic PivotTable.srt
│ └─◇ 1103 Modifying a PivotTable.srt
│ └─◇ 1104 Creating and modifying a PivotChart.srt
├─◆12. Creating and Using Charts
│ └─◇ 1201 Choosing chart types.srt
│ └─◇ 1202 Inserting Sparklines.srt
│ └─◇ 1203 Creating a column chart.srt
│ └─◇ 1204 Modifying a column chart.srt
│ └─◇ 1205 Creating and modifying a pie chart.srt
│ └─◇ 1206 Placing Excel charts into other Office applications.srt
├─◆13. Creating and Using Macros
│ └─◇ 1301 Understanding macros.srt
│ └─◇ 1302 Recording and using a simple macro.srt
│ └─◇ 1303 Editing a macro.srt
├─◆14. Customizing Excel
│ └─◇ 1401 Customizing the Quick Access toolbar.srt
│ └─◇ 1402 Customizing the Ribbon bar.srt
│ └─◇ 1403 Setting Excel options.srt
├─◆Conclusion
│ └─◇ Goodbye.srt
◇
【本字幕由ACELY.CN独家制作发布】
┏
┃本套教程字幕包含中文字幕
┃中文字幕使用机器翻译，对翻译结果中不当内容不承担任何责任！
┃更多中文字幕请访问唯一发布站【ACELY.CN】
┃本站中文字幕未经允许一律严禁转载！
┗