LYNDA.COM EXCEL 2010 POWER SHORTCUTS 教學課程 英文版

FORWIN95/WIN98/WIN2K/WINXP
(此處作業系統的支援，僅供參考，詳情請至官方網站查閱)

XYZSTUDIO搶先上市

　　２０１０．０９．２４全新上市XYZStudio
≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒
LYNDA.COMEXCEL2010POWERSHORTCUTS教學課程英文版

【參考網址】:

http://www.lynda.com

【安裝說明】:

　無

【內容說明】★◇以下中文譯文說明僅供參考，實際軟體內容請依參考網址介紹為準◇★

Lynda最新出品的Excel2010PowerShortcuts視頻教學課程.DennisTaylor主要講解
了很多快速、高效掌握Excel2010強大功能的技巧、捷徑.

教學課程時長：3小時41分教學課程難度：中級

主講：DennisTaylor

教學課程光碟提供有配套練習素材.

目錄:

具體課程目錄安排：
Introduction01:37
Welcome01:17
Usingtheexercisefiles00:20
22:451.TopTenShortcuts
Enteringdataorformulasinnon-adjacentcellssimultaneously02:28
Convertingformulastovalueswithasimpledrag02:34
Copyingdataorformulasdownacolumninstantly02:56
Adjustingallorselectedcolumnwidthsorrowheightsinaflash02:21
Instantlydisplayingallworksheetformulas03:16
Twoquickshortcutsforcreatingcharts01:18
PrintPreview01:07
Instantdateortimeentry01:16
Undo/Redo/Repeat03:19
Zoominginandoutquickly02:10
07:372.RibbonandQuickAccessToolbarTips
ExpandingandcollapsingtheRibbonandFullScreenview01:23
Keyboardcommandaccess02:22
QuickAccesstoolbardisplaytips03:52
14:303.DisplayShortcuts
Splitscreensandfrozentitlesinaflash05:56
Repeatingtitlecreationandsuppression06:17
CustomizingyourdisplayofStatusBartotals02:17
11:314.NavigationShortcuts
Navigationshortcuts02:30
Tipsfornavigatingbetweenworkbooks03:48
Navigatingwithinworksheets05:13
11:125.SelectionShortcuts
Selectinganentirerow,column,orworksheet03:20
Selectingnoncontiguousrangesandvisiblecellsonly04:39
Selectingthecurrentregionandmovingaroundregioncorners03:13
22:166.DataEntryandEditingShortcuts
Acceleratingdataentry06:27
Auto-Filltechniquesforenteringdates04:59
Auto-Filltechniquesforenteringtimes02:37
Customlistsforrapidentry05:54
Celleditingtips02:19
12:387.Drag-and-DropTechniques
Copy/Moveaccelerationtips03:27
WorksheetCopy/Moveshortcuts02:29
Draggingandinsertingvariations03:47
InstantlydisplayingPasteSpecialoptions02:55
29:318.FormulaShortcuts
Rapidformulacreation03:48
Selectingallcellsthatdependontheactivecell05:24
Selectingallcellsthatcanaffecttheactivecell02:38
AutoSumshortcuts02:57
Roundingshortcuts05:14
Generatingrandomnumbers03:16
Countinguniqueentries03:11
Performingcalculationswithoutformulas03:03
17:049.OperationalShortcuts
Controllingrowsandcolumns05:50
Realigningimportedtext02:27
Handlingblankcells04:20
Collapsingandexpandingdetail04:27
28:0810.FormattingShortcuts
Formattingnumbers06:49
Aligningdata03:49
Addingbackgroundcolorforreadability03:43
Formattingdataconditionally01:54
Creatingcustomformats06:23
Formattingperiodsover24hours03:02
Applyingstrikethroughsandborders02:28
23:4311.DatabaseTechniques
Sortingshortcuts02:40
Cleaningupspaces04:47
Identifyingduplicates04:07
Splittingcolumns03:57
Ensuringuniqueentries02:46
Forcingdatestobeweekdaysonly03:56
Displayinguniqueitemsfromlargelists01:30
18:3812.ChartingandVisualObjectTips
Placingandadjustingcharts02:37
Creatingcharttitlesfromcellcontent02:22
Creatingandmanipulatingshapes05:31
Linkingandunlinkingpictures08:08
00:09Conclusion
Goodbye00:09

XYZSTUDIO強力推薦！！！一定讓你值回票價，保證錯不了。
≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒≒

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