|
|
| 商品编号: |
CAI4623 |
|
| 商品名稱： |
LYNDA.COM EXCEL 2010 POWER SHORTCUTS 教學課程 英文版 |
|
| 碟片數量： |
1片 |
|
| 銷售價格： |
100 |
|
| 瀏覽次數： |
117152 |
|
【轉載TXT文檔】 |
|
| LYNDA.COM EXCEL 2010 POWER SHORTCUTS 教學課程 英文版 |
FOR WIN 95/WIN 98/WIN 2K/WIN XP
(此處作業系統的支援，僅供參考，詳情請至官方網站查閱)
XYZ STUDIO搶先上市
２０１０．０９．２４ 全新上市 XYZ Studio
≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒
LYNDA.COM EXCEL 2010 POWER SHORTCUTS 教學課程 英文版
【參考網址】:
http://www.lynda.com
【安裝說明】:
無
【內容說明】★◇以下中文譯文說明僅供參考，實際軟體內容請依參考網址介紹為準◇★
Lynda最新出品的Excel 2010 Power Shortcuts視頻教學課程. Dennis Taylor 主要講解
了很多快速、高效掌握Excel 2010強大功能的技巧、捷徑.
教學課程時長： 3小時41分 教學課程難度：中級
主講： Dennis Taylor
教學課程光碟提供有配套練習素材.
目錄:
具體課程目錄安排：
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
XYZ STUDIO 強力推薦！！！一定讓你值回票價，保證錯不了。
≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒
XYZ Studio 目錄編輯
最後，有句老話還是要再強調一次！本目錄僅僅只是幫助您試用/選購各種應用軟
體之用，如果您覺得這些試用的軟體真的對您工作上真正有幫助，敬請務必要買原
版軟體，以支持作者或出版公司能再出版最好的軟體!!! 為了您將來的後續服務，
更應該要購買原版的軟體！謝謝!!!
≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒
≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒
|
|
|
專業電腦教學