关闭

关闭

封号提示

内容

首页 Financial Analysis With Excel.pdf

Financial Analysis With Excel.pdf

Financial Analysis With Excel.p…

上传者: duncum 2010-01-07 评分1 评论0 下载460 收藏0 阅读量1229 暂无简介 简介 举报

简介:本文档为《Financial Analysis With Excelpdf》,可适用于哈哈哈哈领域,主题内容包含CHAPTERSpreadsheetBasicsTheterm“spreadsheet”coversawidevarietyofelementsus符等。

CHAPTERSpreadsheetBasicsTheterm“spreadsheet”coversawidevarietyofelementsusefulforquantitativeanalysisofallkindsEssentially,aspreadsheetisasimpletoolconsistingofamatrixofcellsthatcanstorenumbers,text,orformulasThespreadsheet’spowercomesfromitsabilitytorecalculateresultsasyouchangethecontentsofothercellsNolongerdoestheuserneedtodothesecalculationsbyhandoronacalculatorInstead,withaproperlyconstructedspreadsheet,changingasinglenumber(say,asalesforecast)canresultinliterallythousandsofautomaticchangesinthemodelThefreedomandproductivityenhancementprovidedbymodernspreadsheetspresentsanunparalleledopportunityforlearningfinancialanalysisAfterstudyingthischapter,youshouldbeableto:ExplainthebasicpurposeofaspreadsheetprogramIdentifythevariouscomponentsoftheExcelscreenNavigatetheExcelworksheet(entering,correcting,andmovingdatawithintheworksheet)ExplainthepurposeandusageofExcel’sbuiltinfunctionsandmacrofunctionsCreategraphicsandknowhowtoprintandsavefilesinExcelCHAPTER:SpreadsheetBasicsSpreadsheetUsesSpreadsheetstodaycontainbuiltinanalyticalcapabilitiespreviouslyunavailableinasinglepackageUsersoftenhadtolearnavarietyofspecializedsoftwarepackagestodoanyrelativelycomplexanalysisWiththenewestversionsofMicrosoftExcel,userscanperformtasksrangingfromtheroutinemaintenanceoffinancialstatementstomultivariateregressionanalysistoMonteCarlosimulationsofvarioushedgingstrategiesItisliterallyimpossibletoenumerateallofthepossibleapplicationsforspreadsheetsYoushouldkeepinmindthatspreadsheetsareusefulnotonlyforfinancialanalysis,butforanytypeofquantitativeanalysiswhetheryourspecialtyisinmarketing,management,engineering,statistics,oreconomicsForthatmatter,aspreadsheetcanalsoprovevaluableforpersonalusesWithExcelitisafairlysimplemattertobuildaspreadsheettomonitoryourinvestmentportfolio,doretirementplanning,experimentwithvariousmortgageoptionswhenbuyingahouse,keepamailinglist,etcThepossibilitiesarequiteliterallyendlessThemorecomfortableyoubecomewiththespreadsheet,themorevaluableusesyouwillfindAboveall,feelfreetoexperiment!TrynewthingsUsingaspreadsheetcanhelpyoufindsolutionsthatyouneverwouldhaveimaginedonyourownStartingMicrosoftExcelBeforeyoucandoanyworkinExcel,youhavetoruntheprogramInWindows,programsaregenerallystartedbydoubleclickingontheprogram’siconThelocationoftheExceliconwilldependontheorganizationofyoursystemYoumayhavetheExcelicon(left)onthedesktopOtherwise,youcanstartExcelbyclickingtheStartbuttonandthenchoosingMicrosoftExcelfromtheAllProgramsmenuForeasieraccess,youmaywishtocreateaDesktoporTaskbarshortcutTodothisrightclickontheExceliconintheAllProgramsmenuandeitherchooseCreateShortcutordragtheicontotheDesktoporTaskbarRememberthatashortcutisnottheprogramitself,soyoucansafelydeletetheshortcutifyoulaterdecidethatyoudon’tneeditExcelIconSpreadsheetBasicsPartsoftheExcelScreenPartsoftheExcelScreenFIGUREMICROSOFTEXCELTheTitleBarThetitlebaristheareaattheverytopoftheExcelscreenItservesanumberoffunctions:•IdentifiestheprogramasMicrosoftExcelanddisplaysthenameofthecurrentlyactiveworkbook•AppearsbrightlycoloredwhenExcelistheactiveprogram•Canbe“grabbed”withthemousetomovethewindowaroundwithintheWindowsenvironment,ifthewindowisnotmaximizedSpreadsheetBasicsCHAPTER:SpreadsheetBasics•Containsthesystemmenu(leftcorner)andtheminimize,maximize,andclosebuttons(rightcorner)ThesystemmenuprovideschoicesformovingthewindoworchangingitssizeaswellastheabilitytoswitchtoorrunotherprogramsTheminimizebuttonwillcollapsethewindowdowntoaniconatthebottomoftheWindowsscreenwhereitisstillactive,butoutofthewayThemaximizebuttoncausestheprogramtooccupytheentirescreenTheclosebuttonwillexittheprogram•Whendoubleclicked,thetitlebarduplicatesthefunctioningofthemaximizebuttonTheMenuBarFIGURETHEEXCELMAINMENUSThemainmenubarinExcelprovidesaccesstoninemenus,eachofwhichleadstofurtherchoicesTherearetwowaystoselectamenu:clickonthemenuofchoicewiththemouse,orusetheAltkeyincombinationwiththeunderlinedletterinthemenunameForexample,tochoosetheFilemenu,youcouldeitherclickontheword“File”orpressAltFonthekeyboardEithermethodwillleadtotheFilemenudroppingdown,allowingyoutomakeanotherchoiceInWindows,menusarepersistent,meaningthattheystayvisibleonthescreenuntilyoueithermakeaselectionorcancelthemenubypressingtheEsckeyWhilethemenuisvisible,youmayuseeitherthearrowkeysorthemousetoselectafunctionAttimes,somemenuselectionsaredisplayedinalightgraycolor(grayed)TheseoptionsarenotavailableforselectionatthetimethatthemenuisselectedForexample,ifyouhavenotcutorcopiedacell,thePasteoptionfromtheEditmenuhasnothingtopaste,soitisgrayedOnlythemenuoptionsdisplayedinblackmaybeselectedRefertoAppendixAforashortdescriptionofeachmenuselectionSpreadsheetBasicsPartsoftheExcelScreenTheToolbarsFIGUREMOSTCOMMONEXCELTOOLBARSImmediatelybelowthemenubar,ExceldisplaysaseriesofshortcutbuttonsonToolbarsTheexactbuttons,andtheirorder,maybedifferentondifferentmachinesThebuttonsprovideaquickwaytocarryoutcertaincommandswithoutwadingthroughmenusanddialogboxesToadd,delete,orrearrangebuttonschooseViewToolbarsCustomizefromthemenusYoucanlearnwhatfunctioneachbuttonperformsbysimplymovingthemousepointeroverabuttononaToolbarAfterafewseconds,amessagewillappearthatinformsyouofthebutton’sfunctionThismessageisknownasaToolTipToolTipsareusedfrequentlybyExceltohelpyoutoidentifythefunctionofvariousitemsonthescreenNotethatyoucanmoveaToolbar,ormakeitfloatovertheworksheet,byclickingonablankareaoftheToolbaranddraggingittothenewlocationDroppingitovertheworksheetareawillleaveitfloatingTheToolbarwillstaywhereveryoudropit,evenafterexitingandrestartingExcelTheFormulaBarFIGURETHEEXCELFORMULABARTheformulabardisplaysinformationaboutthecurrentlyselectedcellTheleftpartoftheformulabarindicatesthenameoftheselectedcellTherightpartoftheformulabardisplaysthecontentsoftheselectedcellIfthecellcontainsaformula,theformulabardisplaystheformula,andthecelldisplaystheresultoftheformulaSpreadsheetBasicsCHAPTER:SpreadsheetBasicsThefxbuttonontheformulabarisusedtoshowtheInsertFunctiondialogboxThisdialogboxhelpsyoutoenterfunctionswithouthavingtomemorizethemSeepageformoreinformationTheWorksheetAreaTheworksheetareaiswheretherealworkofthespreadsheetisdoneTheworksheetisamatrix(columnsand,rows)ofcells,eachofwhichcancontaintext,numbers,formulas,orgraphicsEachcellisreferredtobyacolumnletterandarownumberColumnletters(A,B,C,,IV)arelistedatthetopofeachcolumn,andrownumbers(,,,,)arelistedtotheleftofeachrowThecellintheupperleftcorneroftheworksheetisthereforereferredtoascellA,thecellimmediatelybelowAisreferredtoascellA,thecelltotherightofAiscellB,andsoonThisnamingconventioniscommontoallspreadsheetsandwillbecomecomfortableonceyouhavepracticedabitTheactivecell(theoneintowhichanyinputwillbeplaced)canbeidentifiedbyasolidblackborderaroundthecellNotethattheactivecellisnotalwaysvisibleonthescreen,butitisalwaysnamedintheleftmostportionofformulabarSheetTabsFIGURETHESHEETTABSExcelworksheetsarestoredinaformatwhichcombinesmultipleworksheetsintoonefileknownasaworkbookThisallowsseveralrelatedworksheetstobecontainedinonefileThesheettabs,nearthebottomofthescreen,allowyoutoswitchbetweensheetsinaworkbookYoumayrename,copy,ordeleteanyexistingsheetorinsertanewsheetbyclickingatabwithyourrightmousebuttonandmakingachoicefromtheresultingmenuYoucaneasilychangetheorderofthesheettabsbyleftclickingatabanddraggingittoanewpositionItiseasytodoanyoftheseoperationsonmultipleworksheetsatonce,exceptrenamingSimplyclickthefirstsheetandthenCtrlclickeachoftheothers(Youcanselectacontiguousgroupofsheetsbyselectingthefirst,andthenShiftclickthelast)Now,rightclickoneoftheselectedsheetsandselecttheappropriateoptionfromthepopupmenuWhensheetsaregrouped,anythingyoudotooneSpreadsheetBasicsNavigatingtheWorksheetsheetgetsdonetoallThisisusefulif,forexample,youneedtoenteridenticaldataintomultiplesheetsorneedtoperformidenticalformattingonseveralsheetsToungroupthesheets,eitherclickonanynongroupedsheetorrightclickasheettabandchooseUngroupSheetsfromthepopupmenuAnewfeatureinExcelallowsyoutochooseacolorforeachtabTodothisjustrightclickthetabandchooseTabColorfromthepopupmenuTheVCRstylebuttonstotheleftofthesheettabsarethesheettabcontrolbuttonstheyallowyoutoscrollthroughthelistofsheettabsRightclickingonanyoftheVCRstylebuttonswilldisplayapopupmenuthatallowsyoutoquicklyjumptoanysheettabintheworkbookThisisespeciallyhelpfulwhenyouhavetoomanytabsforthemalltobeshownStatusBarFIGURETHESTATUSBARThestatusbarcontainsinformationregardingthecurrentstateofExcel,aswellascertainmessagesForexample,mostofthetimetheonlymessageis“Ready”indicatingthatExceliswaitingforinputAtothertimes,Excelmayadd“Calculate”tothestatusbartoindicatethatitneedstorecalculatetheworksheetbecauseofchangesYoucanalsodirectExceltodocertaincalculationsonthestatusbarForexample,inFigureExceliscalculatingtheaverageofthecellsthatarehighlightedintheworksheetByrightclickingonthestatusbaryoucanalsogetExceltocalculatethesum,count,minimum,ormaximumofanyhighlightedcellsThisisusefulwhenyouneedaquickcalculation,butitdoesn’tneedtobeintheworksheetTherightsideofthestatusbarshowsiftheNumLockorScrollLockkeysareonNavigatingtheWorksheetTherearetwoprinciplemethodsformovingaroundwithintheworksheetarea:thearrowkeysandthemouseGenerallyspeaking,forsmalldistancesthearrowkeysprovideaneasymethodofchangingtheactivecell,butmovingtomoredistantcellsisusuallyeasierwiththemouseSpreadsheetBasicsCHAPTER:SpreadsheetBasicsMostkeyboardshaveaseparatekeypadcontainingarrowspointingup,down,left,andrightIfyourkeyboarddoesnot,thenthenumerickeypadcanbeusediftheNumLockfunctionisoff(youwillseethewordNUMinthestatusbarifNumLockison)Tousethearrowkeys,simplypresstheappropriatekeyonceforeachcellthatyouwishtomoveacrossForexample,assumingthatthecurrentcellisAandyouwishtomovetocellD,simplypresstheRightarrowkeythreetimesTomovefromDtoDpresstheDownarrowkeyfourtimesYoucanalsousetheTabkeytomoveonecelltotherightThemouseiseveneasiertouseWhilethemousepointerisovertheworksheetareaitwillbeintheshapeofafatcross(seeFigure)TochangetheactivecellmovethemousepointeroverthedestinationcellandclicktheleftbuttonTomovetoacellthatisnotcurrentlydisplayedonthescreen,clickonthescrollbarsuntilthecellisvisibleandthenclickonitForexample,iftheactivecellisAandyouwishtomakeAtheactivecell,merelyclickonthearrowatthebottomofthescrollbarontherighthandpartofthescreenuntilAisvisibleMovethemousepointerovercellAandclickwiththeleftbuttonEachclickonthescrollbarmovestheworksheetupordownonepageIfyouwishtomoveup,clickabovethethumbIfdown,clickbeneaththethumbThethumbisthesmallbuttonthatmovesupanddownthescrollbartoindicateyourpositionintheworksheetTomovemorequickly,youcandragthethumbtothedesiredpositionIfyouknowthenameoraddressofthecelltowhichyouwishtomove(forlargeworksheetsrememberingthecelladdressisn’teasy,butyoucanusenamedranges)usetheGoTocommandTheGoTocommandwillchangetheactivecelltowhatevercellyouindicateTheGoTodialogboxcanbeusedbychoosingtheEditmenuandthentheGoTocommand,bypressingtheFfunctionkey,orbypressingtheCtrlGkeycombinationTomovetocellA,simplypressF,type:AintheReferencebox,andthenpressEnterYouwillnoticethatcellAisnowhighlightedandvisibleonthescreenYoucanalsouseGoTotofindcertainspecialcells(eg,thelastcellthathasdatainit)bypressingtheSpecialbuttonintheGoTodialogboxSelectingaRangeofCellsManytimesyouwillneedtoselectmorethanonecellatatimeForexample,youmaywishtoapplyaparticularnumberformattoawholerangeofcells,oryoumightwishtoclearawholerangeSinceitwouldbecumbersometodothisonecellatatime,especiallyforalargerange,ExcelallowsyoutosimultaneouslyselectawholerangeandperformvariousfunctionsonallofthecellsatonceTheeasiestwaytoselectacontiguousrangeofcellsistousethemouseSimplypointSpreadsheetBasicsNavigatingtheWorksheettothecellintheupperleftcorneroftherange,clickandholddowntheleftbutton,anddragthemouseuntiltheentirerangeishighlightedAsyoudragthemouse,watchtheleftsideoftheformulabarExcelwillinformyouofthenumberofselectedrowsandcolumnsYoucanalsousethekeyboardtoselectarangeFirstchangetheactivecelltotheupperleftcorneroftherangetobeselected,pressandholddowntheShiftkey,andusethearrowkeystohighlighttheentirerangeNotethatifyoureleasetheShiftkeywhilepressinganarrowkeyyouwilllosethehighlightAveryusefulkeyboardshortcutistheShiftCtrlArrow(anyarrowkeywillwork)combinationThisisusedtoselectallofthecellsfromtheactivecellupto,butnotincluding,thefirstblankcellForexample,ifyouhavenumbersinacolumnandneedtoapplyaformat,justselectthefirstcellandthenpressShiftCtrlDownArrowtoselectthemallThisisfasterandmoreaccuratethanusingthemouseManytimesitisalsousefultoselectadiscontiguousrange(ie,twoormoreunconnectedranges)ofcellsTodothis,simplyselectthefirstrangeasusual,andthenholddowntheCtrlkeyasyouselecttheotherrangesTheabilitytoselectcellsinExceliscrucialbecauseExcel,likemostotherWindowsapplications,worksinthe“select,thenact”mode(Intheolddays,usersofDOSprogramswerefamiliarwiththe“act,thenselect”methodofoperation)InExcel,youfirstselectthecellsthatyouwishtoacton,thenchoosetheoperation(eg,EditCopy)thatyouwanttoperformThiswouldseemtobeaminorpoint,butitisactuallyabigproductivityimprovementInthe“select,thenact”method,thecellsstayselectedaftertheoperationhasbeenperformed,therebyallowinganotheroperationonthosecellswithoutreselectingthemUsingNamedRangesAnamedrangeisacell,orgroupofcells,forwhichyouhavesuppliedanameRangenamescanbeusefulinanumberofdifferentways,butlocatingarangeonabigworksheetisprobablythemostcommonuseTonamearangeofcells,startbyselectingtherangeForexample,selectA:CandthenchooseInsertNameDefinefromthemenusIntheeditboxatthetopoftheDefineNamedialogbox,enteraname,sayMyRange(notethatarangenamecannotcontainspacesormostspecialcharacters)Now,clicktheAddbuttonandtherangeisnamedFigureSpreadsheetBasicsCHAPTER:SpreadsheetBasicsshowshowthedialogboxshouldlookNotethatatthebottomtheRefersToeditboxshowstheaddresstowhichthenamerefersFIGURETHEDEFINENAMEDIALOGBOXOncetherangeisnamed,youcanselectitusingtheGoTocommandThenamewillappearinthelistontheGoTodialogboxAnevenfastermethodistousetheNameBoxontheleftsideoftheformulabarSimplydropthelistandchoosethenamedrangethatyouwishtoselectNamedrangescanalsobeusedinformulasinplaceofcelladdresses,andcanbeusedintheChartSeriesfunctionforchartsAsusefulastheycanbeattimes,thereisnorequirementtousethemEnteringTextandNumbersEachcellinanExcelworksheetcanbethoughtofasaminiaturewordprocessorTextcanbeentereddirectlyintothecellandthenformattedinavarietyofwaysToenteratextstring,firstselectthecellwhereyouwantthetexttoappearandthenbegintypingItisthatsimpleNotethatthenameisactuallydefinedasaformulaThissubtlepointisimportantforsomeofthemoreadvancedusesofnamedrangesForexample,therangeofcellsreferredtobythenamecanbemadetochangeautomaticallydependingoncircumstancesSpreadsheetBasicsNavigatingtheWorksheetExcelissmartenoughtoknowthedifferencebetweennumbersandtext,sotherearenoextrastepsforenteringnumbersLet’strythefollowingexampleofenteringnumbersandtextintotheworksheetMovethecellpointertocellA(usingthearrowkeys,mouse,ortheGoTocommand)andtype:MicrosoftCorporationSalesIncellAenter:(MillionsofDollars)SelectcellAandtype:toNotethattheentryincellAwillbetreatedastextbyExcelbecauseofthespacesandlettersincludedIncellsAtoFwenowwanttoentertheyearsInAtype:,inBtype:,nowselectA:BandmovethemousepointeroverthelowerrightcorneroftheselectionThemousepointerwillnowchangetoaskinnycrossindicatingthatyoucanusetheAutoFillfeatureClickanddragthemousetotherighttofillintheremainingyearsNoticethatthemostrecentdataistypicallyenteredattheleft,andthemostdistantdataattherightThisconventionallowsustoeas

类似资料

该用户的其他资料

Barclays CDS Curve Trading Handbook.pdf

F._William_Engdahl-A_Century_of_War__Anglo-American_Oil_Politics_and_the_New_World_Order-Pluto_Press(2004).pdf

On China.pdf

Red Capitalism.pdf

banach-tarski.pdf

职业精品

精彩专题

注册化工工程师,专业考试如何备考?

注册化工工程师含金量很高,在经济建设中从事化工工程(包括化工、石化、化纤、医药和轻化)设计及相关业务活动的专业技术人员必须要有这个证书。那么全国注册化工工程师报考条件,注册化工工程师考几年,注册化工工程师如何备考~等等这些问题你都知道吗?

用户评论

0/200
    暂无评论
上传我的资料

精选资料

热门资料排行换一换

  • 章太炎:国学概论.PDF

  • 王国维:人间词话.pdf

  • 近代汉语探源--江蓝生.pdf

  • 汉语语法化的历程--石毓智.pdf

  • [现代思想译丛3]【加】菲利普.…

  • 日常生活-[匈]赫勒.pdf

  • 鲁迅手稿管窥+朱正+湖南人民+1…

  • 《王安忆自选集》之四·漂泊的语言…

  • 逻辑研究特辑.pdf

  • 资料评价:

    / 387
    所需积分:0 立即下载

    意见
    反馈

    返回
    顶部