巧学Excel 2010视频教程 Lynda.com Excel 2010 Power Shortcuts [光盘镜像]

游客，本帖隐藏的内容需要积分高于 1 才可浏览，您当前积分为 0

资源信息： 中文名: 巧学Excel 2010视频教程 英文名: Lynda.com Excel 2010 Power Shortcuts 资源格式: 光盘镜像 发行日期: 2010年08月12日 地区: 美国 对白语言: 英语 文字语言: 英文 概述:

资源简介: Lynda最新出品的Excel 2010 Power Shortcuts视频教程. Dennis Taylor 主要讲解了很多快速、高效掌握Excel 2010强大功能的技巧、捷径. 教程时长： 3小时41分 教程难度：中级 主讲： Dennis Taylor 教程光盘提供有配套练习素材. In Excel 2010 Power Shortcuts, Excel expert Dennis Taylor shares tips and shortcuts to vastly increase efficiency and get the full power out of Excel 2010. There are tips for working with the Ribbon and Quick Access toolbar, navigating workbooks and selecting cells, rapid data entry and editing, working with formulas, formatting data, working with charts, sorting data, and much more. Exercise files accompany the course. 教学主要内容有： Creating charts with keyboard shortcuts Converting formulas to values by dragging Repeating Undo and Redo actions Displaying formulas instantly Navigating quickly through worksheets and across workbooks Formatting numeric, and date/time data in a flash with keystroke shortcuts Inserting dates or times instantly Grouping rows or columns to create collapsible regions Building data-entry shortcuts with Auto-fill Displaying unique items from large lists 教程预览:

目录: 具体课程目录安排： Introduction 01:37 Welcome 01:17 Using the exercise files 00:20 22:45 1. Top Ten Shortcuts Entering data or formulas in non-adjacent cells simultaneously 02:28 Converting formulas to values with a simple drag 02:34 Copying data or formulas down a column instantly 02:56 Adjusting all or selected column widths or row heights in a flash 02:21 Instantly displaying all worksheet formulas 03:16 Two quick shortcuts for creating charts 01:18 Print Preview 01:07 Instant date or time entry 01:16 Undo/Redo/Repeat 03:19 Zooming in and out quickly 02:10 07:37 2. Ribbon and Quick Access Toolbar Tips Expanding and collapsing the Ribbon and Full Screen view 01:23 Keyboard command access 02:22 Quick Access toolbar display tips 03:52 14:30 3. Display Shortcuts Split screens and frozen titles in a flash 05:56 Repeating title creation and suppression 06:17 Customizing your display of Status Bar totals 02:17 11:31 4. Navigation Shortcuts Navigation shortcuts 02:30 Tips for navigating between workbooks 03:48 Navigating within worksheets 05:13 11:12 5. Selection Shortcuts Selecting an entire row, column, or worksheet 03:20 Selecting noncontiguous ranges and visible cells only 04:39 Selecting the current region and moving around region corners 03:13 22:16 6. Data Entry and Editing Shortcuts Accelerating data entry 06:27 Auto-Fill techniques for entering dates 04:59 Auto-Fill techniques for entering times 02:37 Custom lists for rapid entry 05:54 Cell editing tips 02:19 12:38 7. Drag-and-Drop Techniques Copy/Move acceleration tips 03:27 Worksheet Copy/Move shortcuts 02:29 Dragging and inserting variations 03:47 Instantly displaying Paste Special options 02:55 29:31 8. Formula Shortcuts Rapid formula creation 03:48 Selecting all cells that depend on the active cell 05:24 Selecting all cells that can affect the active cell 02:38 AutoSum shortcuts 02:57 Rounding shortcuts 05:14 Generating random numbers 03:16 Counting unique entries 03:11 Performing calculations without formulas 03:03 17:04 9. Operational Shortcuts Controlling rows and columns 05:50 Realigning imported text 02:27 Handling blank cells 04:20 Collapsing and expanding detail 04:27 28:08 10. Formatting Shortcuts Formatting numbers 06:49 Aligning data 03:49 Adding background color for readability 03:43 Formatting data conditionally 01:54 Creating custom formats 06:23 Formatting periods over 24 hours 03:02 Applying strikethroughs and borders 02:28 23:43 11. Database Techniques Sorting shortcuts 02:40 Cleaning up spaces 04:47 Identifying duplicates 04:07 Splitting columns 03:57 Ensuring unique entries 02:46 Forcing dates to be weekdays only 03:56 Displaying unique items from large lists 01:30 18:38 12. Charting and Visual Object Tips Placing and adjusting charts 02:37 Creating chart titles from cell content 02:22 Creating and manipulating shapes 05:31 Linking and unlinking pictures 08:08 00:09 Conclusion Goodbye 00:09 资源来自网络收集 未经过一一的质量 安全等检测 只是把收集的资源和各位驴友分享 仅作网络学习交流使用 请勿用于商业用途 ! 希望各位下载的驴友能多多参与分流保源