Guitar World Guitar Heroes
GuitarWorldGuitarHeroes英文合輯版(音效素材軟體)(DVD版)
內容說明:
Lynda最新出品的Excel2010PowerShortcuts影片教程.DennisTaylor主要講解了很多快速、高效掌握Excel2010強大功能的技巧、
捷徑.

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

主講：DennisTaylor

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

InExcel2010PowerShortcuts,ExcelexpertDennisTaylorsharestipsandshortcutstovastlyincreaseefficiencyand
getthefullpoweroutofExcel2010.TherearetipsforworkingwiththeRibbonandQuickAccesstoolbar,navigating
workbooksandselectingcells,rapiddataentryandediting,workingwithformulas,formattingdata,workingwith
charts,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
英文說明:
InExcel2010PowerShortcuts,ExcelexpertDennis
Taylorsharestipsandshortcutstovastlyincrease
efficiencyandgetthefullpoweroutofExcel2010.
TherearetipsforworkingwiththeRibbonandQuick
Accesstoolbar,navigatingworkbooksandselecting
cells,rapiddataentryandediting,workingwith
formulas,formattingdata,workingwithcharts,
sortingdata,andmuchmore.Exercisefiles
accompanythecourse.
相關商品:HalLeonardGuitarPlay-AlongNirvanaTUTORiAL英文正式版(吉他教學演示素材軟體)(DVD版)TrueFireTommyEmmanuelCertifiedGemsFingerstyleGuitar2011DVDRHYBRIDTUTORiAL英文正式版(吉它認證培訓教程軟體)(DVD版)PlatinumLoops12StringEssentialsVol.1AcousticGuitarMULTiFORMAT英文正式版LickLibraryLearnRockGuitarin6WeeksWk4英文正式版(LickLibrary出品搖滾吉它視頻教程軟體)(DVD版)GuitarLab50BluesGuitarLicksYouMustKnowTUTORiAL英文正式版(藍調吉他教學素材軟體)(DVD版)HalLeonardRockabillyGuitarTUTORiAL英文正式版(吉它視頻教程軟體)(DVD版)HomespunLearnToPlayDjango-StyleGypsyJazzGuitarV2TUTORiAL英文正式版(吉他教學吉普賽爵士樂素材軟體)(DVD版)