巧學Excel 2010視頻教程 Lynda.com Excel 2010 Power Shortcuts 英文版 CD

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

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

主講：DennisTaylor

教程光盤提供有配套練習素材.

InExcel2010PowerShortcuts,ExcelexpertDennisTaylorsharestipsandshortcutstovastlyincreaseefficiencyandgetthefullpoweroutofExcel2010.TherearetipsforworkingwiththeRibbonandQuickAccesstoolbar,navigatingworkbooksandselectingcells,rapiddataentryandediting,workingwithformulas,formattingdata,workingwithcharts,sortingdata,andmuchmore.Exercisefilesaccompanythecourse.

教學主要內容有：

Creatingchartswithkeyboardshortcuts
Convertingformulastovaluesbydragging
RepeatingUndoandRedoactions
Displayingformulasinstantly
Navigatingquicklythroughworksheetsandacrossworkbooks
Formattingnumeric,anddate/timedatainaflashwithkeystrokeshortcuts
Insertingdatesortimesinstantly
Groupingrowsorcolumnstocreatecollapsibleregions
Buildingdata-entryshortcutswithAuto-fill
Displayinguniqueitemsfromlargelists
目錄:

具體課程目錄安排：
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