【Lynda】Excel 2007 Power Shortcuts【CHN】中英文字幕[SRT]
==========教程信息=====================================================
教程名称：Excel 2007 Power Shortcuts
作者：Michael Ninness
主题：Business, Productivity
使用软件：Excel 2007
难度等级：中级
时长： 2h 4m
发布日期： Nov 17, 2009
┏ACELY STUDIO，2012
┃更多资源请访问
┃◆唯一发布站：ACELY.CN
┗◆我的博客：http://blog.sina.com.cn/u/1991840741
==========教程目录文件列表=============================================
Excel 2007 Power Shortcuts[SRT]
├─◆0. Introduction
│ └─◇ 0001 Welcome.srt
│ └─◇ 0002 Using the exercise files.srt
├─◆1. The Top 10
│ └─◇ 0101 The Repeat command.srt
│ └─◇ 0102 The AutoSum keyboard shortcut.srt
│ └─◇ 0103 Changing the Excel 2007 defaults.srt
│ └─◇ 0104 The Format Painter.srt
│ └─◇ 0105 Creating charts with a keyboard shortcut.srt
│ └─◇ 0106 Adding custom keyboard shortcuts via macros.srt
│ └─◇ 0107 Sharing a spreadsheet using the Send command.srt
│ └─◇ 0108 Getting statistics from the Status bar.srt
│ └─◇ 0109 Expanding and collapsing the Formula bar.srt
│ └─◇ 0110 Autofitting all columns and rows to data.srt
├─◆2. Ribbon and Toolbar Shortcuts
│ └─◇ 0201 Hiding the Ribbon.srt
│ └─◇ 0202 Revealing and using the Ribbon keytips.srt
│ └─◇ 0203 Accessing the Mini toolbar.srt
│ └─◇ 0204 Customizing the Quick Access toolbar.srt
│ └─◇ 0205 Using the Quick Access toolbar keyboard shortcuts.srt
├─◆3. Sheet Navigation Shortcuts
│ └─◇ 0301 The Go To command.srt
│ └─◇ 0302 Moving around a worksheet.srt
│ └─◇ 0303 Zooming in and out with the keyboard.srt
│ └─◇ 0304 The Zoom to Selection command.srt
│ └─◇ 0305 Hiding and revealing rows and columns.srt
├─◆4. Cell Selection Shortcuts
│ └─◇ 0401 Selecting a range of cells with the keyboard.srt
│ └─◇ 0402 Selecting the current region of cells.srt
│ └─◇ 0403 Selecting non-adjacent cells.srt
│ └─◇ 0404 Selecting entire rows and columns.srt
│ └─◇ 0405 Selecting the same cell range in multiple sheets.srt
│ └─◇ 0406 Selecting, copying, and pasting content between cells.srt
│ └─◇ 0407 Grouping rows or columns to create collapsible regions.srt
├─◆5. Data Entry Shortcuts
│ └─◇ 0501 Extending a series or pattern with Autofill.srt
│ └─◇ 0502 Creating a custom list for Autofill.srt
│ └─◇ 0503 Data entry shortcuts with AutoCorrect.srt
│ └─◇ 0504 Creating a custom data drop-down list.srt
│ └─◇ 0505 Inserting the current date and or time.srt
│ └─◇ 0506 Entering fractions versus dates.srt
│ └─◇ 0507 Removing duplicate rows of data.srt
│ └─◇ 0508 Keeping row and column headings in view.srt
├─◆6. Formatting Shortcuts
│ └─◇ 0601 Quick formatting shortcuts.srt
│ └─◇ 0602 Adding and removing cell borders.srt
│ └─◇ 0603 Custom date formats.srt
│ └─◇ 0604 Custom time formats.srt
│ └─◇ 0605 Adding time values and formatting them correctly.srt
│ └─◇ 0606 Shading every other row automatically.srt
│ └─◇ 0607 Parsing names into multiple columns.srt
│ └─◇ 0608 Changing uppercase text to proper case with the Proper function.srt
│ └─◇ 0609 Removing automatic hyperlinks.srt
│ └─◇ 0610 Changing colors by picking a different theme.srt
├─◆Conclusion
│ └─◇ Goodbye.srt
◇
【本字幕由ACELY.CN独家制作发布】
┏
┃本套教程字幕包含中文字幕
┃中文字幕使用机器翻译，对翻译结果中不当内容不承担任何责任！
┃更多中文字幕请访问唯一发布站【ACELY.CN】
┃本站中文字幕未经允许一律严禁转载！
┗