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

上传资料

关闭

关闭

关闭

封号提示

内容

首页 Microsoft Office Excel 2010 Bible

Microsoft Office Excel 2010 Bible.pdf

Microsoft Office Excel 2010 Bib…

wz_cs
2010-06-03 0人阅读 举报 0 0 暂无简介

简介:本文档为《Microsoft Office Excel 2010 Biblepdf》,可适用于IT/计算机领域

ShelvingCategory:COMPUTERSSpreadsheetsReaderLevel:BeginningtoAdvancedwwwwileycomcompbooks$USA$CanadaWalkenbachIfExcelcandoit,JohnWalkenbachcanshowyouhowWhatbetterwaytolearnExcelthanfrom“MrSpreadsheet”himselfExcelguru,MicrosoftMVP,andauthorofalltheprevioustopsellingeditionsofExcelBible,JohnWalkenbachprovidesmorethan,pagespackedwithtechniques,tips,andtricksforbeginnersaswellasExcelpowerusersDiscoverwhat’snewinExcel,learnshortcutsyoudidn’tknow,maketheRibboninterfaceworkforyou,andmasterallthelatestinsandoutswiththismusthaveguide•GetuptospeedoneverythingnewinExcel•Understandfunctions,charts,worksheets,andworkbooks•PerformmagicwitharrayformulasandevenmorewithSparklines•Master“whatif”analysis,GoalSeeking,externaldatabasefiles,andpivottables•Developcustomfunctions,programwithVBA,andcreateUserForms•TrynewsliceanddicetoolstodynamicallyfilteryourdataCDROMIncludedWhat’sontheCDROMFollowtheexamplesinthebook,chapterbychapter,usingthebonusmaterialsontheCDROM:•Alltheexamplesandworkbookfilesusedinthebook•SearchablePDFofthebookSystemRequirements:SeetheCDAppendixinthebookfordetailsandcompletesystemrequirementsJohnWalkenbachaka“MrSpreadsheet”istheprincipalofJWalkandAssociates,IncandaMicrosoftExcelMVPHeisaleadingauthorityonspreadsheetsoftwareandthecreatoroftheawardwinningPowerUtilityPakJohnhaswrittenmorethanbooks,aswellasarticlesandreviewsforpublicationsincludingPCWorld,InfoWorld,andWindowsHealsomaintainsthepopularSpreadsheetPageatspreadsheetpagecomSpottrendsinyourdatawithSparklinesPreviewhowyourcopiedtextwilllookChartyourdatausingExcel’sdifferentcharttypesJohnWalkenbachMasterExcelformulasforusefulworksheetsCreateeffectivechartssuitablefortheboardroomAnalyzeandpresentdatawithpivottablesThebookyouneedtosucceed!CDROMIncluded!•Allexamplesandworkbooksdiscussedinthebook•Searchableelectronicversionofthisbook,inPDFformatExcelMicrosoft®®ExcelMicrosoft®®“JohnWalkenbach’swritingstylemakesthedifficultseemeasyinthisbookthatcanbeusedasareferenceorreadcovertocoverYouwon’tfindamorecomprehensivebookonExcelthanthis!”DickKusleika,MicrosoftMVP,DailyDoseOfExcelcomffirsinddiiffirsinddii:PM:PMExcel®Bibleffirsinddiffirsinddi:PM:PMffirsinddiiffirsinddii:PM:PMExcel®BibleJohnWalkenbachffirsinddiiiffirsinddiii:PM:PMExcel®BiblePublishedbyWileyPublishing,IncCrosspointBoulevardIndianapolis,INwwwwileycomCopyright©byWileyPublishing,Inc,Indianapolis,IndianaLibraryofCongressControlNumber:PublishedsimultaneouslyinCanadaISBN:ManufacturedintheUnitedStatesofAmericaNopartofthispublicationmaybereproduced,storedinaretrievalsystemortransmittedinanyformorbyanymeans,electronic,mechanical,photocopying,recording,scanningorotherwise,exceptaspermittedunderSectionsoroftheUnitedStatesCopyrightAct,withouteitherthepriorwrittenpermissionofthePublisher,orauthorizationthroughpaymentoftheappropriatepercopyfeetotheCopyrightClearanceCenter,RosewoodDrive,Danvers,MA,(),fax()RequeststothePublisherforpermissionshouldbeaddressedtothePermissionsDepartment,JohnWileySons,Inc,RiverStreet,Hoboken,NJ,(),fax(),oronlineathttp:wwwwileycomgopermissionsLIMITOFLIABILITYDISCLAIMEROFWARRANTY:THEPUBLISHERANDTHEAUTHORMAKENOREPRESENTATIONSORWARRANTIESWITHRESPECTTOTHEACCURACYORCOMPLETENESSOFTHECONTENTSOFTHISWORKANDSPECIFICALLYDISCLAIMALLWARRANTIES,INCLUDINGWITHOUTLIMITATIONWARRANTIESOFFITNESSFORAPARTICULARPURPOSENOWARRANTYMAYBECREATEDOREXTENDEDBYSALESORPROMOTIONALMATERIALSTHEADVICEANDSTRATEGIESCONTAINEDHEREINMAYNOTBESUITABLEFOREVERYSITUATIONTHISWORKISSOLDWITHTHEUNDERSTANDINGTHATTHEPUBLISHERISNOTENGAGEDINRENDERINGLEGAL,ACCOUNTING,OROTHERPROFESSIONALSERVICESIFPROFESSIONALASSISTANCEISREQUIRED,THESERVICESOFACOMPETENTPROFESSIONALPERSONSHOULDBESOUGHTNEITHERTHEPUBLISHERNORTHEAUTHORSHALLBELIABLEFORDAMAGESARISINGHEREFROMTHEFACTTHATANORGANIZATIONORWEBSITEISREFERREDTOINTHISWORKASACITATIONANDORAPOTENTIALSOURCEOFFURTHERINFORMATIONDOESNOTMEANTHATTHEAUTHORORTHEPUBLISHERENDORSESTHEINFORMATIONTHEORGANIZATIONORWEBSITEMAYPROVIDEORRECOMMENDATIONSITMAYMAKEFURTHER,READERSSHOULDBEAWARETHATINTERNETWEBSITESLISTEDINTHISWORKMAYHAVECHANGEDORDISAPPEAREDBETWEENWHENTHISWORKWASWRITTENANDWHENITISREADForgeneralinformationonourotherproductsandservicesortoobtaintechnicalsupport,pleasecontactourCustomerCareDepartmentwithintheUSat(),outsidetheUSat()orfax()Trademarks:Wiley,theWileylogo,andrelatedtradedressaretrademarksorregisteredtrademarksofJohnWileySons,Incandoritsaffiliates,intheUnitedStatesandothercountries,andmaynotbeusedwithoutwrittenpermissionExcelisaregisteredtrademarkofMicrosoftCorporationintheUnitedStatesandorothercountriesAllothertrademarksarethepropertyoftheirrespectiveownersWileyPublishing,IncisnotassociatedwithanyproductorvendormentionedinthisbookWileyalsopublishesitsbooksinavarietyofelectronicformatsSomecontentthatappearsinprintmaynotbeavailableinelectronicbooksffirsinddivffirsinddiv:PM:PMThisbookisdedicatedtoWormpicker,agentlemanandascholarwhoonedaywillbeafineoldtimefiddlerffirsinddvffirsinddv:PM:PMffirsinddviffirsinddvi:PM:PMAbouttheAuthorJohnWalkenbachisabestsellingExcelauthorwhohaspublishedmorethanspreadsheetbooksHelivesamidthesaguaros,javelinas,rattlesnakes,bobcats,andgilamonstersinSouthernArizonabutthecrittersaremostlyscaredawaybyhisclawhammerbanjoplayingFormoreinformation,Googlehimffirsinddviiffirsinddvii:PM:PMffirsinddviiiffirsinddviii:PM:PMAbouttheTechnicalEditorNiekOttenstartedindataprocessingininaninsurancecompanyHeranintoVisiCalcinandhasbeenaddictedtospreadsheetseversinceHisfirstacquaintancewithExcel(version!)wasinonaMacintoshSince,NiekhasbeenselfemployedHeanswersquestionsaboutExcelinnewsgroupsandforums,reviewsandeditsExcelbooks,writesarticles,anddevelopsExcelrelatedsoftware,suchasahighperformanceactuarialaddinNiekhasbeenaMicrosoftMostValuableProfessional(MVP)forExcelsinceffirsinddixffirsinddix:PM:PMCreditsProjectEditorRebeccaSenningerAcquisitionsEditorKatieMohrTechnicalEditorNiekOttenSeniorCopyEditorTeresaArtmanEditorialManagerLeahCameronEditorialDirectorMaryCCorderVicePresidentandExecutiveGroupPublisherRichardSwadleyVicePresidentandPublisherAndyCummingsProjectCoordinatorKatieCrockerMediaDevelopmentProjectManagerLauraMossMediaDevelopmentAssistantProjectManagerJennySwisherMediaDevelopmentAssociateProducersJoshFrankShawnPatrickDougKuhnMarilynHummelProofreadingandIndexingLindaSeifertBroccoliInformationManagementffirsinddxffirsinddx:PM:PMxiAcknowledgments                                        xxxviiIntroduction                                           xxxviiiPartI:GettingStartedwithExcelChapter:IntroducingExcel                                   WhatIsExcelGoodForWhat’sNewinExcelUnderstandingWorkbooksandWorksheetsMovingaroundaWorksheetNavigatingwithyourkeyboardNavigatingwithyourmouseIntroducingtheRibbonRibbontabsContextualtabsTypesofcommandsontheRibbonAccessingtheRibbonbyusingyourkeyboardUsingShortcutMenusCustomizingYourQuickAccessToolbarWorkingwithDialogBoxesNavigatingdialogboxesUsingtabbeddialogboxesUsingtheTaskPaneCreatingYourFirstExcelWorksheetGettingstartedonyourworksheetFillinginthemonthnamesEnteringthesalesdataFormattingthenumbersMakingyourworksheetlookabitfancierSummingthevaluesCreatingachartPrintingyourworksheetSavingyourworkbookftocinddxiftocinddxi:PM:PMContentsChapter:EnteringandEditingWorksheetData                   ExploringtheTypesofDataYouCanUseAboutnumericvaluesAbouttextentriesAboutformulasEnteringTextandValuesintoYourWorksheetsEnteringDatesandTimesintoYourWorksheetsEnteringdatevaluesEnteringtimevaluesModifyingCellContentsErasingthecontentsofacellReplacingthecontentsofacellEditingthecontentsofacellLearningsomehandydataentrytechniquesAutomaticallymovingthecellpointerafterenteringdataUsingnavigationkeysinsteadofpressingEnterSelectingarangeofinputcellsbeforeenteringdataUsingCtrlEntertoplaceinformationintomultiplecellssimultaneouslyEnteringdecimalpointsautomaticallyUsingAutoFilltoenteraseriesofvaluesUsingAutoCompletetoautomatedataentryForcingtexttoappearonanewlinewithinacellUsingAutoCorrectforshorthanddataentryEnteringnumberswithfractionsSimplifyingdataentrybyusingaformEnteringthecurrentdateortimeintoacellApplyingNumberFormattingUsingautomaticnumberformattingFormattingnumbersbyusingtheRibbonUsingshortcutkeystoformatnumbersFormattingnumbersusingtheFormatCellsdialogboxAddingyourowncustomnumberformatsChapter:EssentialWorksheetOperations                      LearningtheFundamentalsofExcelWorksheetsWorkingwithExcelwindowsMovingandresizingwindowsSwitchingamongwindowsClosingwindowsActivatingaworksheetAddinganewworksheettoyourworkbookDeletingaworksheetyounolongerneedChangingthenameofaworksheetChangingasheettabcolorxiiftocinddxiiftocinddxii:PM:PMxiiiContentsRearrangingyourworksheetsHidingandunhidingaworksheetControllingtheWorksheetViewZoominginoroutforabetterviewViewingaworksheetinmultiplewindowsComparingsheetssidebysideSplittingtheworksheetwindowintopanesKeepingthetitlesinviewbyfreezingpanesMonitoringcellswithaWatchWindowWorkingwithRowsandColumnsInsertingrowsandcolumnsDeletingrowsandcolumnsHidingrowsandcolumnsChangingcolumnwidthsandrowheightsChangingcolumnwidthsChangingrowheightsChapter:WorkingwithCellsandRanges                       UnderstandingCellsandRangesSelectingrangesSelectingcompleterowsandcolumnsSelectingnoncontiguousrangesSelectingmultisheetrangesSelectingspecialtypesofcellsSelectingcellsbysearchingCopyingorMovingRangesCopyingbyusingRibboncommands

用户评价(0)

关闭

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

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

提示

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

文档小程序码

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

1

打开微信

2

扫描小程序码

3

发布寻找信息

4

等待寻找结果

我知道了
评分:

/49

Microsoft Office Excel 2010 Bible

仅供在线阅读

VIP

在线
客服

免费
邮箱

爱问共享资料服务号

扫描关注领取更多福利