加入VIP
  • 专属下载特权
  • 现金文档折扣购买
  • VIP免费专区
  • 千万文档免费下载

上传资料

关闭

关闭

关闭

封号提示

内容

首页 Head First Excel

Head First Excel.pdf

Head First Excel

阿然
2014-03-19 0人阅读 举报 0 0 暂无简介

简介:本文档为《Head First Excelpdf》,可适用于IT/计算机领域

AdvancePraiseforHeadFirstExcel“HeadFirstExcelisawesome!LikeotherHeadFirstbooks,it’saveryapproachablemixofknowledge,businesssituations,andhumorNotonlydoyoulearnallyouneedtoknowaboutExcel,butyoualsogettolearnsomerealbusinesslingoandsmartsaswellNeedtocreateformulasNeedtomakereports,charts,orpivottablesThisisthebookforyouHeadFirstExcelgivesyouthegoodsandwillhelpyouexcelatExcel!”KenBluttman,wwwkenbluttmancom“HeadFirstExcelshowshowtofullyutilizesomeofthebestfeaturesExcelhastooffertoimproveproductivityanddataanalysisskillsIfI’vebeenusingExcelforoveryearsandstillfoundmanyusefultopics,socanyou,regardlessofyourexperiencelevel”AnthonyRose,President,SupportAnalytics“DoyouuseExceltokeeplistsandcalculatetheoccasionalbudgetWouldyouliketodivedeeperandlearnhowExcelcangiveyouanedgeinyourdailyworkflowUnlockyourExcelsuperpowerswithMichaelMilton’sHeadFirstExcelYou’lllearntocreatedatavisualizationsanddesignspreadsheetsthatmakeyourpointandgetyounoticedDiscoverhowtoeasilyauditcomplexformulaswrittenbyothers,soyoucanquicklyvalidate(orcall‘BS’on)theircalculationsBuildmodelsthatoptimizeyourbusinessandorfinancesbasedonallpossiblescenariosExcel’smanyfeaturescanseemintimidatingMichaelcutsthroughthecomplexityandteachesyoutobendExceltoyourwill”BillMietelski,softwareengineerPraiseforotherHeadFirstbooks“KathyandBert’sHeadFirstJavatransformstheprintedpageintotheclosestthingtoaGUIyou’veeverseenInawry,hipmanner,theauthorsmakelearningJavaanengaging‘what’retheygonnadonext’experience”WarrenKeuffel,SoftwareDevelopmentMagazine“BeyondtheengagingstylethatdragsyouforwardfromknownothingintoexaltedJavawarriorstatus,HeadFirstJavacoversahugeamountofpracticalmattersthatothertextsleaveasthedreaded‘exerciseforthereader’It’sclever,wry,hipandpracticaltherearen’talotoftextbooksthatcanmakethatclaimandliveuptoitwhilealsoteachingyouaboutobjectserializationandnetworklaunchprotocols”DrDanRussell,DirectorofUserSciencesandExperienceResearchIBMAlmadenResearchCenter(andteachesArtificialIntelligenceatStanfordUniversity)“It’sfast,irreverent,fun,andengagingBecarefulyoumightactuallylearnsomething!”KenArnold,formerseniorengineeratSunMicrosystemsCoauthor(withJamesGosling,creatorofJava),TheJavaProgrammingLanguage“Ifeellikeathousandpoundsofbookshavejustbeenliftedoffofmyhead”WardCunningham,inventoroftheWikiandfounderoftheHillsideGroup“Justtherighttoneforthegeekedout,casualcoolgurucoderinallofusTherightreferenceforpracticaldevelopmentstrategiesgetsmybraingoingwithouthavingtoslogthroughabunchoftired,staleprofessorspeak”TravisKalanick,founderofScourandRedSwooshMemberoftheMITTR“Therearebooksyoubuy,booksyoukeep,booksyoukeeponyourdesk,andthankstoO’ReillyandtheHeadFirstcrew,thereisthepenultimatecategory,HeadFirstbooksThey’retheonesthataredogeared,mangled,andcarriedeverywhereHeadFirstSQLisatthetopofmystackHeck,eventhePDFIhaveforreviewistatteredandtorn”BillSawyer,ATGCurriculumManager,Oracle“Thisbook’sadmirableclarity,humor,andsubstantialdosesofclevermakeitthesortofbookthathelpsevennonprogrammersthinkwellaboutproblemsolving”CoryDoctorow,coeditorofBoingBoingAuthor,DownandOutintheMagicKingdomandSomeoneComestoTown,SomeoneLeavesTownPraiseforotherHeadFirstbooks“Ireceivedthebookyesterdayandstartedtoreadit…andIcouldn’tstopThisisdefinitelytrès‘cool’Itisfun,buttheycoveralotofgroundandtheyarerighttothepointI’mreallyimpressed”ErichGamma,IBMDistinguishedEngineerCoauthor,DesignPatterns“OneofthefunniestandsmartestbooksonsoftwaredesignI’veeverread”AaronLaBerge,VPTechnology,ESPNcom“Whatusedtobealong,trialanderrorlearningprocesshasnowbeenreducedneatlyintoanengagingpaperback”MikeDavidson,CEO,Newsvine,Inc“Elegantdesignisatthecoreofeverychapterhere,eachconceptconveyedwithequaldosesofpragmatismandwit”KenGoldstein,ExecutiveVicePresident,DisneyOnline“I♥HeadFirstHTMLwithCSSXHTMLitteachesyoueverythingyouneedtolearnina‘funcoated’format”SallyApplin,UIdesignerandartist“Usuallywhenreadingthroughabookorarticleondesignpatterns,I’dhavetooccasionallystickmyselfintheeyewithsomethingjusttomakesureIwaspayingattentionNotwiththisbookOddasitmaysound,thisbookmakeslearningaboutdesignpatternsfun“Whileotherbooksondesignpatternsaresaying,‘Bueller…Bueller…Bueller,’thisbookisonthefloatbeltingout‘Shakeitup,baby!’”EricWuehler“IliterallylovethisbookInfact,Ikissedthisbookinfrontofmywife”SatishKumarwwwwowebookcomOtherrelatedbooksfromO’ReillyHeadFirstDataAnalysisAnalyzingBusinessDatawithExcelExcelScientificandEngineeringCookbookAccessDataAnalysisCookbookOtherbooksinO’Reilly’sHeadFirstseriesHeadFirstJavaTMHeadFirstObjectOrientedAnalysisandDesign(OOAD)HeadFirstHTMLwithCSSandXHTMLHeadFirstDesignPatternsHeadFirstServletsandJSPHeadFirstEJBHeadFirstPMPHeadFirstSQLHeadFirstSoftwareDevelopmentHeadFirstJavaScriptHeadFirstAjaxHeadFirstPhysicsHeadFirstStatisticsHeadFirstRailsHeadFirstPHPMySQLHeadFirstAlgebraHeadFirstWebDesignHeadFirstNetworkingHeadFirstDataAnalysisHeadFirstDGeometryHeadFirstProgrammingBeijing•Cambridge•Farnham•K�ln•Sebastopol•Taipei•TokyoHeadFirstExcelWouldn’titbedreamyiftherewasabookonExcelthatcouldturnmeintoanexpertwhilekeepingmeengagedandentertainedButit’sprobablyjustafantasyMichaelMiltonHeadFirstExcelbyMichaelMiltonCopyright©MichaelMiltonAllrightsreservedPrintedintheUnitedStatesofAmericaPublishedbyO’ReillyMedia,Inc,GravensteinHighwayNorth,Sebastopol,CAO’ReillyMediabooksmaybepurchasedforeducational,business,orsalespromotionaluseOnlineeditionsarealsoavailableformosttitles(http:mysafaribooksonlinecom)Formoreinformation,contactourcorporateinstitutionalsalesdepartment:()orcorporateoreillycomSeriesCreators:KathySierra,BertBatesSeriesEditor:BrettDMcLaughlinEditor:BrianSawyerCoverDesigners:LouiseBarr,SteveFehlerProductionEditor:RachelMonaghanIndexer:AngelaHowardProofreader:ColleenToporekPageViewers:Mandarin,thefam,andPrestonPrintingHistory:March:FirstEditionTheO’ReillylogoisaregisteredtrademarkofO’ReillyMedia,IncTheHeadFirstseriesdesignations,HeadFirstExcel,andrelatedtradedressaretrademarksofO’ReillyMedia,IncManyofthedesignationsusedbymanufacturersandsellerstodistinguishtheirproductsareclaimedastrademarksWherethosedesignationsappearinthisbook,andO’ReillyMedia,Inc,wasawareofatrademarkclaim,thedesignationshavebeenprintedincapsorinitialcapsWhileeveryprecautionhasbeentakeninthepreparationofthisbook,thepublisherandtheauthorassumenoresponsibilityforerrorsoromissions,orfordamagesresultingfromtheuseoftheinformationcontainedhereinISBN:MThisbookusesRepKover™,adurableandflexiblelayflatbindingTMThefamPrestonMandarinviiitheauthorAuthorofHeadFirstExcelWhenMichaelMilton’sfriendswereprogramminginBASICandplayingLeisureSuitLarrybackinthes,hewascreatingchartsinSuperCalcHiscareerhasconsistedmainlyofhelpingpeopleoutbyshowingupwiththerightspreadsheetattherightmoment,andhehopesthatafterreadingHeadFirstExcel,you’llhavethesameexperienceWhenhe’snotinthelibraryorthebookstore,youcanfindhimrunning,takingpictures,brewingbeer,orbloggingatmichaelmiltonnetMichaelMiltontableofcontentsixTableofContents(therealthing)YourbrainonExcelHereyouaretryingtolearnsomething,whilehereyourbrainisdoingyouafavorbymakingsurethelearningdoesn’tstickYourbrain’sthinking,“Betterleaveroomformoreimportantthings,likewhichwildanimalstoavoidandwhethernakedsnowboardingisabadidea”SohowdoyoutrickyourbrainintothinkingthatyourlifedependsonknowingspreadsheetsIntroWhoisthisbookforxxviWeknowwhatyou’rethinkingxxviiMetacognitionxxixHere’swhatYOUcandotobendyourbrainintosubmissionxxxiReadMexxxiiThetechnicalreviewteamxxxivAcknowledgmentsxxxvTableofContents(Summary)IntroxxvIntroductiontoformulas:Excel’srealpowerVisualdesign:SpreadsheetsasartReferences:PointintherightdirectionChangeyourpointofview:Sort,zoom,andfilterDatatypes:MakeExcelvalueyourvaluesDatesandtimes:StayontimeFindingfunctions:MineExcel’sfeaturesonyourownFormulaauditing:VisualizeyourformulasCharts:GraphyourdataWhatifanalysis:AlternaterealitiesTextfunctions:LettersasdataPivottables:HardcoregroupingBooleans:TRUEandFALSESegmentation:SliceanddiceiLeftovers:TheTopTenThings(wedidn’tcover)iiInstallExcel’sSolver:TheSolvertableofcontentsxExcel’srealpowerIntroductiontoformulasWealluseExceltokeeplistsAndwhenitcomestolists,ExceldoesagreatjobButtherealExcelninjasarepeoplewhohavemasteredtheworldofformulasUsingdatawellisallaboutexecutingthecalculationsthatwilltellyouwhatyouneedtoknow,andformulasdothosecalculations,moldingyourdataintosomethingusefulandilluminatingIfyouknowyourformulas,youcanreallymakeyournumberssingCraftMasaJeanGeorgesAquavitLeBernardinTacoChuloBrooklynQuesadilla$Tacos$ChileconQueso$Tip$Total$LupaSalad$Baccala$FruttidiMare$Olives$BagnaCauda$SpaghettiallaCarbonara$EggplantParm$Tip$Total$CanyouliveituponthelastnightofyourvacationHere’swhatyoubudgetedandwhatyouspentExcelisgreatforkeepingrecordsFormulasworkwithyourdataReferenceskeepyourformulasworkingevenifyourdatachangesCheckyourformulascarefullyRefertoabunchofcellsusingarangeUseSUMtoaddtheelementsinarangeWhenyoucopyandpasteaformula,thereferencesshiftExcelformulasletyoudrilldeepintoyourdataEveryonehasplentyofcashleftforafoodfillednightinNewYorkCity!tableofcontentsxiSpreadsheetsasartMostpeopleusuallyuseExcelforpagelayoutAlotofformulawritingmasters,whoarefamiliarwithjusthowpowerfulExcelcanbe,areshockedthatpeople“just”usethesoftwareforshowinginformationwithagridButExcel,especiallyinitsmorerecentversions,hasbecomequitehandyasapagelayouttoolYou’reabouttogetcomfortablewithsomeimportantandnotsoobviousExceltoolsforseriousvisualdesignvisualdesignCRMFreakneedstopresenttheirfinancialstoanalystsThedollarsignispartofyourcell’sformattingHowtoformatyourdataThebossapproves!Designprinciple:keepitsimpleClashofthedesigntitans…UsefontstodrawtheeyetowhatismostimportantCellstyleskeepformattingconsistentforelementsthatrepeatWithyourcellstylesselected,useThemestochangeyourlookHelikesit,butthere’ssomethingelse…UseproximityandalignmenttogrouplikethingstogetherYourspreadsheetisahit!IncomestatementRevenueCostofrevenueExpensesBalancesheetAssetsLiabilitiesStockholderequitytableofcontentsxiiMINreturnsthelowestnumberinaseriesLetExcelfillinrangesbystartingyourformulaandusingyourmouseExcelgottherightanswerusingamoresophisticatedreferenceUseabsolutereferencestopreventshiftingoncopypasteAbsolutereferencesgiveyoualotofoptionsNamedrangessimplifyyourformulasExcel’sTablesmakeyourreferencesquickandeasyStructuredreferencesareadifferentdimensionofabsolutereferenceYourprofitabilityforecastsprovedaccuratePointintherightdirectionreferencesAformulaisonlyasgoodasitsreferencesNomatterhowcreativeandbrilliantyourformulais,itwon’tdoyoumuchgoodifitdoesnotpointtothecorrectdataIt’seasytogetreferencesrightforshort,individualformulas,butoncethoseformulasgetlongandneedtobecopied,thechanceofreferencemistakesincreasesdramaticallyInthischapter,you’llexploitabsoluteandrelativereferencesaswellasExcel’sadvancednewstructuredreferencefeature,ensuringthatnomatterhowbigandnumerousyourreferencesare,yourformulaswillstaytightandaccurateHoweachwouldlookifyoucopiedandpastedtoCOriginalreferencesRelativeAbsoluteRangesSingleReferencesCBB$C$B:CC:D$B$:$C$$B$:$C$tableofcontentsxiiiSort,zoom,andfilterThedetailsofyourdataaretantalizingButonlyifyouknowhowtolookatthemInthischapter,you’llforgetaboutformattingandfunctionsandjustfocusonhowtochangeyourperspectiveonyourdataWhenyouareexploringyourdata,lookingforissuestoinvestigate,thesort,zoom,andfiltertoolsoffersurprisingversatilitytohelpyougetagriponwhatyourdatacontainschangeyourpointofviewPoliticalconsultantsneedhelpdecodingtheirfundraisingdatabaseFindthenamesofthebigcontributorsSortchangestheorderofrowsinyourdataSortingshowsyoudifferentperspectivesonalargedatasetSeealotmoreofyourdatawithZoomYourclientisimpressed!Filtershidedatayoudon’twanttoseeUseFilterdropboxestotellExcelhowtofilteryourdataAnunexpectednotefromtheMainCampaign…TheMainCampaignisdelightedwithyourworkDonationsarepouringin!SortbydonationSortbyZIPSortbynametableofcontentsxivYourdoctorfriendisonadeadlineandhasbrokendataSomehowyouraverageformuladividedbyzeroDatainExcelcanbetextornumbersThedoctorhashadthisproblembeforeYouneedafunctionthattellsExceltotreatyourtextasavalueAgradstudentalsoransomestats…andthere’saproblemErrorsareaspecialdatatypeNowyou’reapublishedscientistMakeExcelvalueyourvaluesdatatypesExceldoesn’talwaysshowyouwhatit’sthinkingSometimes,ExcelwillshowyouanumberbutthinkofitastextOritmightshowyousometextthatitseesasanumberExcelwillevenshowyoudatathatisneithernumbernortext!Inthischapter,you’regoingtolearnhowtoseedatathewayExcelseesit,nomatterhowit’sdisplayedNotonlywillthisknowledgegiveyougreatercontroloveryourdata(andfewer“Whatthe#$!isgoingon”experiences),butitwillalsohelpyouunlockthewholeuniverseofformulasSUM()COUNT()AVERAGE()NumbertableofcontentsxvStayontimeDatesandtimesinExcelarehardUnlessyouunderstandhowExcelrepresentstheminternallyAllofusatonepointoranotherhavehadtodocalculationsinvolvingthesetypesoffigures,andthischapterwillgiveyouthekeystofiguringouthowmanydays,months,years,andevensecondstherearebetweentwodatesThesimpletruthisthatdatesandtimesareareallyspecialcaseofthedatatypesandformattingthatyoualreadyknowOnceyoumasteracoupleofbasicconcepts,you’llbeabletouseExceltomanageschedulingflawlesslydatesandtimesDoyouhavetimetoampupyourtrainingfortheMassachusettsMarathonVALUE()returnsanumberondatesstoredastextExcelseesdatesasintegersSubtractingonedatefromanothertellsyouthenumberofdaysbetweenthetwodatesWhensubtractingdates,watchyourformattingLookslikeyoudon’thavetimetocompletetrainingbeforeaKCoachhasabetterideaDATEDIF()willcalculatetimebetweendatesusingavarietyofmeasuresCoachishappytohaveyouinherclassExcelrepresentstimeasdecimalnumbersfromtoCoachhasanExcelchallengeforyouYouqualifiedfortheMassachusettsMarathonYougivetheformulayourtextA=VALUE()Excelreadsthetextvalueandseesthatit’sreallyanumberJun,TheformulareturnsanumbertableofcontentsxviMineExcel’sfeaturesonyourownfindingfunctionsExcelhasmorefunctionsthanyouwilleveruseOvermanyyearsandmanyversions,theprogramhasaccumulatedspecializedfunctionsthatareterriblyimportanttothesmallgroupofpeoplewhousethemThat’snotaproblemforyouButwhatisaproblemforyouisthegroupoffunctionsthatyoudon’tknowbutthatareusefulinyourworkWhichfunctionsarewetalkingaboutOnlyyoucanknowforsure,andyou’reabouttolearnsometipsandtechniquestofindingquicklytheformulasyouneedtogetyourworkdoneefficientlyExcellent!ShouldyourentadditionalparkingYouneedaplantofindmorefunctionsExcel’shelpscreensareloadedwithtipsandtricksHere’stheconventioncenter’sticketdatabaseforthenextmonthAnatomyofafunctionreferenceTheDatavilleConventionCenterCOOchecksin…FunctionsareorganizedbydatatypeanddisciplineYourspreadsheetshowsticketcountssummarizedforeachdateBoxticketsforyou!tableofcontentsxviiVisualizeyourformulasExcelformulascangetreallycomplicatedAndthatisthepoint,rightIfallyouwantedtodowassimplecalculation,you’dbefinewithapaper,pen,andcalculatorButthosecomplicatedformulascangetunwieldyespeciallyoneswrittenbyotherpeople,whichcanbealmostimpossibletodecipherifyoudon’tknowwhattheywerethinkingInthischapter,you’lllearntouseasimplebutpowerfulgraphicalfeatureofExcelcalledformulaauditing,whichwilldramaticallyillustratetheflowofdatathroughoutthemodelsinyourspreadsheetformulaauditingShouldyoubuyahouseorrentUseNetPresentValuetodiscountfuturecoststotoday’svaluesThebrokerhasaspreadsheetforyouModelsinExcelcangetcomplicatedFormulaauditingshowsyouthelocationofyourformula’sargumentsExcel’sloanfunctionsallusethesamebasicelementsThePMTformulainthebroker’sspreadsheetcalculatesyourmonthlypaymentFormulasmustbecorrect,andassumptionsmustbereasonableThebrokerweighsin…Yourhousewasagoodinvestment!DownPurchasepriceNPERRateLoanOthercostsgainsYearYearYearYearYear

用户评价(0)

关闭

新课改视野下建构高中语文教学实验成果报告(32KB)

抱歉,积分不足下载失败,请稍后再试!

提示

试读已结束,如需要继续阅读或者下载,敬请购买!

文档小程序码

使用微信“扫一扫”扫码寻找文档

1

打开微信

2

扫描小程序码

3

发布寻找信息

4

等待寻找结果

我知道了
评分:

/49

Head First Excel

仅供在线阅读

VIP

在线
客服

免费
邮箱

爱问共享资料服务号

扫描关注领取更多福利