华尔街投行-Excel-2003-快捷键---Wall-Street-Prep

LearnmorewithWSP!•Openbootcamps•Selfstudyprograms•Corporate&universitytrainingCTRLShortcutsCTRLShortcutsCTRL+ASelectAllCTRL+BBoldCTRL+CCopyCTRL+C,ALTE+SPasteSpecialCTRL+DFillDownCTRL+FFindCTRL+GGotoCTRL+HReplaceCTRL+IItalicCTRL+KInsertHyperlinkCTRL+NNewWorkbookCTRL+OOpenFileCTRL+PPrintCTRL+RFillrightCTRL+SSaveworkbookCTRL+UUnderlineCTRL+VPasteCTRL+WClosewindowCTRL+XCutCTRL+YRepeatCTRL+ZUndoCTRL+1FormatBoxCTRL+5Strike-throughCTRL+7Hide/showtoolbarCTRL+9HiderowSHIFT+CTRL+9UnhiderowCTRL+0HidecolumnSHIFT+CTRL+0UnhidecolumnCTRL+~Showformulas/valuesCTRL+‘CopyaboveformulaCTRL+;DisplaydateSHIFT+CTRL+:DisplaytimeCTRL+[PrecedentsCTRL+]DependentsCTRL+EnterFillselectionw/entryFormattingShortcutsFormattingShortcutsALT+‘DisplaystyleCTRL+1FormatBoxSHIFT+CTRL+~GeneralformatSHIFT+CTRL+!NumberformatSHIFT+CTRL+@TimeformatSHIFT+CTRL+#DateformatSHIFT+CTRL+$CurrencyformatSHIFT+CTRL+%PercentageformatSHIFT+CTRL+^ExponentialformatSHIFT+CTRL+&OutlineborderSHIFT+CTRL+_RemoveborderSHIFT+CTRL+*SelectregionToolsCustomizeOptionsShowfullmenusNavigationandDataEditingNavigationandDataEditingArrowkeysMovetonewcellsALT+Displayadrop-downlistALT+TabSwitchprogramsCTRL+PgUp/DownSwitchworksheetsCTRL+TabSwitchworkbooksCTRL+ArrowkeysGotoendofcontiguousrangeSHIFT+ArrowkeysSelectacellrangeSHIFT+CTRL+ArrowkeysHighlightcontiguousrangeHomeMovetobeginningofrowCTRL+HomeMovetocell“A1”F5“Goto”ENTERMovetocellbelowSHIFT+ENTERMovetocellaboveTABMovetocelltotherightSHIFT+TABMovetocelltotheleftBACKSPACEDeletecellandgetinsideDELETEDeletecell/selectionF2Edit/highlightdependentcellsWheninsidecell…ALT+ENTERStartnewlineinsamecellSHIFT+ArrowkeysHighlightwithincellsSHIFT+CTRL+ArrowkeysHighlightcontiguousitemsBACKSPACEDeleteprecedingcharacterDELETEDeletecharactertotherightF4Anchor“Fix”CellsESCCancelacellentryF7SpellcheckSHIFT+F2InsertacommentCTRL+F3NameacellALTShortcutsALTShortcutsALT+TabSwitchprogramALT+‘DisplaystyleALT+T+OOptionsMenuALT+T+IAdd-InsMenuALT+E+SPastespecialboxALT+E+S+TPasteformatonlyALT+W+S(Un)splitpanesALT+W+F(Un)freezewindowsALT+E+MMove/CopyasheetALT+E+LDeleteworksheetALT+V+ZChangeviewsizingALT+O+C+AFitcolumnwidthALT+O+H+RChangetabnameALT+E+AClearscellALT+F+VPrintpreviewALT+F4CloseprogramALT+F8MacroboxALT+F11VisualbasiceditorColumnsandRowsColumnsandRowsSHIFT+SpacebarHighlightrowCTRL+SpacebarHighlightcolumnSHIFT+ALT+Grouprows/columnsSHIFT+ALT+Ungrouprows/columnsCTRL+MinussignDeleteselectedcellsSHIFT+CTRL+PlusSignInsertblankcellsFormulasandAuditingFormulasandAuditing=(equalssign)StartaformulaSHIFT+F3Display“InsertFunction”boxALT+“=“InsertAutoSumformulaCTRL+‘(apostrophe)CopyformulafromabovecellSHIFT+CTRL+“(quote)CopyvaluefromabovecellCTRL+~Showformulas/valuesF9RecalculateallworkbooksAuditingformulas…ALT+T+U+TTraceimmediateprecedentsALT+T+U+DTraceimmediatedependentsALT+T+U+ARemovetracingarrowsCTRL+[GotoprecedentcellsCTRL+]GotodependentcellsSHIFT+CTRL+{Traceallprecedents(indirect)SHIFT+CTRL+}Tracealldependents(indirect)F5+EnterGobacktooriginalcellFunctionKeyShortcutsFunctionKeyShortcutsF1ExcelHelpMenuF2EditcellsF3PasteNameF4RepeatoranchorcellsF5“Goto”F6NextpaneinsplitmodeF7SpellcheckF8AnchortohighlightF9RecalculateworkbooksF10ActivatemenubarF11NewchartF12SaveasSHIFT+F2InsertacommentSHIFT+F3“InsertFunction”BoxSHIFT+F4FindNextSHIFT+F5FindSHIFT+F6PreviouspaneSHIFT+F8AddtoselectionSHIFT+F9CalculateactivesheetSHIFT+F10DisplayshortcutmenuSHIFT+F11NewworksheetCTRL+F3NameacellCTRL+F4ClosewindowCTRL+F9MinimizeworkbookCTRL+F10MaximizewindowCTRL+F12OpenFileWindowsFlag+DMinimizeprogramWindowsFlag+EWindowsexplorerExcel2003ReferenceSheet|800-646-3575•FinancialStatementModeling•DCF,LBO,M&AModeling•ComparablesModeling•AdvancedFinancialModeling•Industry-specificmodeling•Accounting&FSA•AdvancedExcel•PowerPointFrequentlyUsedFormulasFrequentlyUsedFormulasRecordingaMacroRecordingaMacroCost(K)Equity=Rf+β(RiskPremiumMarket)WACC=KDebt*(1-TaxRate)*D+KEquity*ED+ED+EDCF=CashFlowt(1+i)^(periodt)Perpetuity=CashFlowt+1(CostofCapital–GrowthRate)PerpetuityFormulaCostofEquityWeightedAverageCostofCapitalDiscounting(PV)ofaCashFlowExample:Createamacrotoinsertbordersatthebottomofcells1.Placethecursorinthedesiredcell.2.HitAlttmr(ToolsÆMacrosÆRecordMacro)3.Inputmacroname(‘Border’)andshortcutkey(CtrlShiftB).Assoonasyouhit‘OK’,youarestartingtorecordthismacro.4.Whenfinishedinsertingabottomborder(usingCtrl1)inthedesiredcell,hitAlttmrto‘StopRecording’themacro.5.TrygoingtoanycellorarangeofcellsandhittingCtrlShiftBCustomizingaNumberFormatCustomizingaNumberFormatIterationsandCircularityIterationsandCircularityCustomformattingdefinestheformatforpositivenumbers,negativenumbers,zerovalues,andtext,inthatorder:Positive;Negative;Zero;TextExample:[Blue]0.0x;[Red](#,##0.00);OK!;Analysisof@Goto:ToolsOptions(Altto)CalculationtabEnsurethe‘Iteration’boxischeckedfor100iterationsasillustrated.DataValidationDataValidation1.Enterdatatobeinlist(A3:A5)2.Gotocelltobevalidated(A7)3.TypeAltdl(DataÆValidation)4.ClicktheSettingstabtospecify“List”5.Input“Source”info(=$A$3:$A$5)andhit“OK”DataTable