xyz資訊工坊

xyz 軟體補給站



商品分類

  商品編號: CAI4623
  商品名稱: LYNDA.COM EXCEL 2010 POWER SHORTCUTS 教學課程 英文版
  語系版本:
  運行平台:
  更新日期:
  光碟片數: 1片
  銷售價格: $100元
  熱門標籤:
您可能感興趣:
您可能也喜歡:
dci0045--Adweek – 12 December 2016-P2P
dci0018--LIFEstyle News MiXture Images Wallpapers #1121-P2P
dci0027--True West – February 2017-P2P
dci0043--Electric & Hybrid Vehicle Technology International – January 2017-P2P
dci0024--Fashink Magazine – Issue 06, 2016-P2P
LYNDA.COM EXCEL 2010 POWER SHORTCUTS 教學課程 英文版

FOR WIN 95/WIN 98/WIN 2K/WIN XP
(此處作業系統的支援,僅供參考,詳情請至官方網站查閱)

XYZ STUDIO搶先上市

   2010.09.24 全新上市 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 目錄編輯
最後,有句老話還是要再強調一次!本目錄僅僅只是幫助您試用/選購各種應用軟
體之用,如果您覺得這些試用的軟體真的對您工作上真正有幫助,敬請務必要買原
版軟體,以支持作者或出版公司能再出版最好的軟體!!! 為了您將來的後續服務,
更應該要購買原版的軟體!謝謝!!!
≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒
≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒