資料介紹

• 辦公軟件與office教程
• 計算機資料

資源簡介:

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

教程預覽: