【Lynda】Excel 2010 Power Shortcuts【CHN】中英文字幕[SRT]
==========教程信息=====================================================
教程名称：Excel 2010 Power Shortcuts
作者：Dennis Taylor
主题：Business, Productivity
使用软件：Excel 2010
难度等级：中级
时长： 3h 43m
发布日期： Aug 12, 2010
┏ACELY STUDIO，2012
┃更多资源请访问
┃◆唯一发布站：ACELY.CN
┗◆我的博客：http://blog.sina.com.cn/u/1991840741
==========教程目录文件列表=============================================
Excel 2010 Power Shortcuts[SRT]
├─◆0. Introduction
│ └─◇ 0001 Welcome.srt
│ └─◇ 0002 Using the exercise files.srt
├─◆1. Top Ten Shortcuts
│ └─◇ 0101 Entering data or formulas in non-adjacent cells simultaneously.srt
│ └─◇ 0102 Converting formulas to values with a simple drag.srt
│ └─◇ 0103 Copying data or formulas down a column instantly.srt
│ └─◇ 0104 Adjusting all or selected column widths or row heights in a flash.srt
│ └─◇ 0105 Instantly displaying all worksheet formulas.srt
│ └─◇ 0106 Two quick shortcuts for creating charts.srt
│ └─◇ 0107 Print Preview.srt
│ └─◇ 0108 Instant date or time entry.srt
│ └─◇ 0109 Undo Redo Repeat.srt
│ └─◇ 0110 Zooming in and out quickly.srt
├─◆2. Ribbon and Quick Access Toolbar Tips
│ └─◇ 0201 Expanding and collapsing the Ribbon and Full Screen view.srt
│ └─◇ 0202 Keyboard command access.srt
│ └─◇ 0203 Quick Access toolbar display tips.srt
├─◆3. Display Shortcuts
│ └─◇ 0301 Split screens and frozen titles in a flash.srt
│ └─◇ 0302 Repeating title creation and suppression.srt
│ └─◇ 0303 Customizing your display of Status Bar totals.srt
├─◆4. Navigation Shortcuts
│ └─◇ 0401 Navigation shortcuts.srt
│ └─◇ 0402 Tips for navigating between workbooks.srt
│ └─◇ 0403 Navigating within worksheets.srt
├─◆5. Selection Shortcuts
│ └─◇ 0501 Selecting an entire row, column, or worksheet.srt
│ └─◇ 0502 Selecting noncontiguous ranges and visible cells only.srt
│ └─◇ 0503 Selecting the current region and moving around region corners.srt
├─◆6. Data Entry and Editing Shortcuts
│ └─◇ 0601 Accelerating data entry.srt
│ └─◇ 0602 Auto-Fill techniques for entering dates.srt
│ └─◇ 0603 Auto-Fill techniques for entering times.srt
│ └─◇ 0604 Custom lists for rapid entry.srt
│ └─◇ 0605 Cell editing tips.srt
├─◆7. Drag-and-Drop Techniques
│ └─◇ 0701 Copy Move acceleration tips.srt
│ └─◇ 0702 Worksheet Copy Move shortcuts.srt
│ └─◇ 0703 Dragging and inserting variations.srt
│ └─◇ 0704 Instantly displaying Paste Special options.srt
├─◆8. Formula Shortcuts
│ └─◇ 0801 Rapid formula creation.srt
│ └─◇ 0802 Selecting all cells that depend on the active cell.srt
│ └─◇ 0803 Selecting all cells that can affect the active cell.srt
│ └─◇ 0804 AutoSum shortcuts.srt
│ └─◇ 0805 Rounding shortcuts.srt
│ └─◇ 0806 Generating random numbers.srt
│ └─◇ 0807 Counting unique entries.srt
│ └─◇ 0808 Performing calculations without formulas.srt
├─◆9. Operational Shortcuts
│ └─◇ 0901 Controlling rows and columns.srt
│ └─◇ 0902 Realigning imported text.srt
│ └─◇ 0903 Handling blank cells.srt
│ └─◇ 0904 Collapsing and expanding detail.srt
├─◆10. Formatting Shortcuts
│ └─◇ 1001 Formatting numbers.srt
│ └─◇ 1002 Aligning data.srt
│ └─◇ 1003 Adding background color for readability.srt
│ └─◇ 1004 Formatting data conditionally.srt
│ └─◇ 1005 Creating custom formats.srt
│ └─◇ 1006 Formatting periods over 24 hours.srt
│ └─◇ 1007 Applying strikethroughs and borders.srt
├─◆11. Database Techniques
│ └─◇ 1101 Sorting shortcuts.srt
│ └─◇ 1102 Cleaning up spaces.srt
│ └─◇ 1103 Identifying duplicates.srt
│ └─◇ 1104 Splitting columns.srt
│ └─◇ 1105 Ensuring unique entries.srt
│ └─◇ 1106 Forcing dates to be weekdays only.srt
│ └─◇ 1107 Displaying unique items from large lists.srt
├─◆12. Charting and Visual Object Tips
│ └─◇ 1201 Placing and adjusting charts.srt
│ └─◇ 1202 Creating chart titles from cell content.srt
│ └─◇ 1203 Creating and manipulating shapes.srt
│ └─◇ 1204 Linking and unlinking pictures.srt
├─◆Conclusion
│ └─◇ Goodbye.srt
◇
【本字幕由ACELY.CN独家制作发布】
┏
┃本套教程字幕包含中文字幕
┃中文字幕使用机器翻译，对翻译结果中不当内容不承担任何责任！
┃更多中文字幕请访问唯一发布站【ACELY.CN】
┃本站中文字幕未经允许一律严禁转载！
┗