资源描述:
《financial-analysis-with-microsoft-excel英文》由会员上传分享,免费在线阅读,更多相关内容在学术论文-天天文库。
1、CHAPTER11SpreadsheetBasicsAfterstudyingthischapter,youshouldbeableto:1.Explainthebasicpurposeofaspreadsheetprogram.2.IdentifythevariouscomponentsoftheExcelscreen.3.NavigatetheExcelworksheet(entering,correcting,andmovingdatawithintheworksheet).4.Explainthepurposeandu
2、sageofExcel’sbuilt-infunctionsandmacrofunctions.5.CreategraphicsandknowhowtoprintandsavefilesinExcel.Theterm“spreadsheet”coversawidevarietyofelementsusefulforquantitativeanalysisofallkinds.Essentially,aspreadsheetisasimpletoolconsistingofamatrixofcellsthatcanstorenu
3、mbers,text,orformulas.Thespreadsheet’spowercomesfromitsabilitytorecalculateresultsasyouchangethecontentsofothercells.Nolongerdoestheuserneedtodothesecalculationsbyhandoronacalculator.Instead,withaproperlyconstructedspreadsheet,changingasinglenumber(say,asalesforecas
4、t)canresultinliterallythousandsofautomaticchangesinthemodel.Thefreedomandproductivityenhancementprovidedbymodernspreadsheetspresentsanunparalleledopportunityforlearningfinancialanalysis.112SpreadsheetBasicsCHAPTER1:SpreadsheetBasicsSpreadsheetUsesSpreadsheetstodayco
5、ntainbuilt-inanalyticalcapabilitiespreviouslyunavailableinasinglepackage.Usersoftenhadtolearnavarietyofspecializedsoftwarepackagestodoanyrelativelycomplexanalysis.WiththenewestversionsofMicrosoftExcel,userscanperformtasksrangingfromtheroutinemaintenanceoffinancialst
6、atementstomultivariateregressionanalysistoMonteCarlosimulationsofvarioushedgingstrategies.Itisliterallyimpossibletoenumerateallofthepossibleapplicationsforspreadsheets.Youshouldkeepinmindthatspreadsheetsareusefulnotonlyforfinancialanalysis,butforanytypeofquantitativ
7、eanalysiswhetheryourspecialtyisinmarketing,management,engineering,statistics,oreconomics.Forthatmatter,aspreadsheetcanalsoprovevaluableforpersonaluses.WithExcelitisafairlysimplemattertobuildaspreadsheettomonitoryourinvestmentportfolio,doretirementplanning,experiment
8、withvariousmortgageoptionswhenbuyingahouse,keepamailinglist,etc.Thepossibilitiesarequiteliterallyendless.Themorecomfortableyoubecomewithth