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

上传资料

关闭

关闭

关闭

封号提示

内容

首页 Office2007教程

Office2007教程.pdf

Office2007教程

祥云龙四
2010-01-02 0人阅读 举报 0 0 暂无简介

简介:本文档为《Office2007教程pdf》,可适用于职业岗位领域

PARTI:INTRODUCINGMICROSOFTOFFICECHAPTER:StartHerePARTII:WRITINGWITHWORDCHAPTER:LearningWord’sBasicsSetWordOptionsCreateaNewDocumentOpenanExistingDocumentTypeTextintoaDocumentEditTextMoveAroundaDocumentFindandReplaceTextCheckaDocument’sSpellingandGrammarPrintaDocumentCHAPTER:MakingYourWordsLookGoodAbouttheRulersAboutParagraphBreaksandTabsApplyCharacterFormattingApplyParagraphFormattingSetUpPageFormattingCreateaMulticolumnNewsletterAboutStyles,Themes,andTemplatesUseaStyleUseaThemeUseaTemplateCHAPTER:AddingLists,Tables,andGraphicsAddaBulletedListAddaNumberedListCreateaTableofContentsCreateanIndexAboutWordTablesCreateaQuickTableCreateaTableManageTablesCreateaCoverPageInsertGraphicsintoaDocumentDrawwithWordAddaChartorWorksheettoaDocumentCHAPTER:UsingWord’sAdvancedFeaturesLookUpaDefinitionTranslateaWordorPhraseInsertaSymbolCounttheWordsinYourDocumentUseDropCapsUseAutoCorrecttoImproveYourTypingAboutHyphenationAddaWatermarkAboutBuildingBlocksAutoFormatYourDocumentAboutHeadersandFootersAddaHeaderorFooterAddaFootnoteoranEndnoteSaveaDocumentinaDifferentFormatAboutMailMergeWriteFormLetterswithMailMergePrintanAddressonanEnvelopeoraLabelAddWordArttoaDocumentPARTIII:WORKINGWITHEXCELWORKSHEETSCHAPTER:GettingtoKnowExcelAboutWorksheetsandWorkbooksSetExcelOptionsCreateaNewWorkbookOpenanExistingWorksheetEnterDataintoaWorksheetAboutMovingAroundExcelAboutExcelFormulasUseSumtoAddRowsandColumnsCopyandMoveFormulasInsertandDeleteRowsandColumnsEditCellDataPrintaWorksheetCHAPTER:WorkingwithExcelDataFindandReplaceDataAboutExcelRangesCreateaRangeFillCellswithAutoFillDataAboutExcelFunctionsEnterExcelFunctionsContentsataGlanceJumpinanywhere!Findthetaskortechniqueyouwanttolearnfromthislist(forexample,CenteraHeadingoverMultipleColumns)Notethenumberinthetab(,inthiscase)AndthenjustflipthroughthebookuntilyoufindthatsamenumberonthesideofoneofthepagesEachshortlessonlistsanytechniquesthatmightbegoodtoknowasbackground(✔BeforeYouBegin)aswellasotherlessonsthatmayberelatedorthatmightgiveyoumoreinformation(➜SeeAlso)Havefun!UseExcel’sFunctionWizardReferenceDataOutsideThisWorksheetWorkwithDatesandTimesAboutExcelLimitsCHAPTER:FormattingWorksheetswithExcelFreezeRowandColumnHeadersFormatCellsCenteraHeadingoverMultipleColumnsSetUpPageFormattingAttachaCommenttoaCellConditionallyFormatDataAboutExcelStyles,Themes,andTemplatesUseanExcelStyleUseanExcelThemeUseanExcelTemplateCHAPTER:CreatingAdvancedWorksheetsAddaCharttoaWorksheetInsertGraphicsintoaWorksheetProtectWorksheetDataCombineMultipleCellsintoOneEnsureValidDataEntryImportandExportWorksheetDataAboutAdvancedWorksheetPrintingCHAPTER:UsingExcelasaSimpleDatabaseAboutExcelDatabasesCreateanExcelDatabaseImportDataintoanExcelDatabaseSortExcelDatabaseDataFilterDataYouWanttoSeeComputeTableTotalsandSubtotalsPARTIV:IMPRESSINGAUDIENCESWITHPOWERPOINTCHAPTER:LearningAboutPowerPointAboutPresentationCreationinPowerPointSetPowerPointOptionsOpenanExistingPresentationGiveaPresentationPrintaPresentationCHAPTER:AddingFlairtoYourPresentationsEnterTextintoaPresentationFindandReplaceTextAnimateTextReviewPowerPointTemplatesUsePowerPointLayoutsandThemesChangeaPresentation’sBackgroundCHAPTER:MakingMoreImpressivePresentationsInsertaChartintoaPresentationInsertGraphicsintoaPresentationAddaPresentationHeaderorFooterAddSoundandVideotoaPresentationAddSpecialEffectstoaPresentationAddaSlideTransitionMakeanAutomaticPresentationAddNotestoaPresentationCreatePresentationHandoutsTurnaPresentationintoOnlineWebPagesAboutGivingPresentationsPARTV:ORGANIZINGWITHOUTLOOKCHAPTER:IntroducingOutlookAboutOutlook’sCapabilitiesMastertheOutlookScreenSetOutlookOptionsSetUpanEmailAccountCreateanEmailMessageCheckforNewMailReplyToandForwardEmailOrganizeEmailAboutProtectingYourselfAgainstJunkandMaliciousEmailsCreateanEmailSignatureCreateaToDoListCHAPTER:MakingContactAddaContactPrintaContactsListCreateanEmailDistributionListLocateaContactonaMapSearchforContactsandOtherOutlookDataCHAPTER:LivingwithOutlookNavigateTimesandDatesSetUpanAppointmentUseRSSFeedsCreateandShareElectronicBusinessCardsWriteYourselfaNoteContinuesonfollowingpageContentsataGlanceContinuedfrompreviouspagePARTVI:ENHANCINGYOURWORKWITHOTHEROFFICEFEATURESCHAPTER:MakingNoteswithOneNoteAboutOneNoteReviewOneNote’sGuideCreateaNewNotebook,Section,andPagesAddTextNotesAddDrawingstoNotesAddAnyDatatoNotesCHAPTER:AutomaticOfficeAboutOfficeMacrosCreateaMacroAboutVisualBasicforApplicationsCustomizetheQuickAccessToolbarShareOfficeFileswithOtherApplicationsAboutOffice’sXMLFileFormatCHAPTER:SharingDataAmongOfficeApplicationsUseDragandDroptoMoveDataLinktoOfficeDataCreateanOfficeDataShortcutConvertaWordDocumenttoaPowerPointPresentationUseOneNotetoEnhanceOtherOfficeProgramsCHAPTER:CombiningOfficeandtheInternetAboutOfficeandOnlineAccessInsertaWebHyperlinkintoaDocumentInsertLiveStockPricesintoanExcelWorksheetCreateaWebPagewithWordCreateaWebPagewithExcelCreateaWebPagewithPowerPointSendEmailfromWord,Excel,PowerPoint,andOneNoteContentsataGlanceGregPerryEastthStreet,Indianapolis,Indiana,USATeachYourselfTeachYourselfAllinOneOfficeMicrosoft®SamsTeachYourselfMicrosoft®OfficeAllinOneCopyright©bySamsPublishingAllrightsreservedNopartofthisbookshallbereproduced,storedinaretrievalsystem,ortransmittedbyanymeans,electronic,mechanical,photocopying,recording,orotherwise,withoutwrittenpermissionfromthepublisherNopatentliabilityisassumedwithrespecttotheuseoftheinformationcontainedhereinAlthougheveryprecautionhasbeentakeninthepreparationofthisbook,thepublisherandauthorassumenoresponsibilityforerrorsoromissionsNorisanyliabilityassumedfordamagesresultingfromtheuseoftheinformationcontainedhereinInternationalStandardBookNumber:LibraryofCongressCatalogCardNumber:PrintedintheUnitedStatesofAmericaFirstPrinting:NovemberTrademarksAlltermsmentionedinthisbookthatareknowntobetrademarksorservicemarkshavebeenappropriatelycapitalizedSamsPublishingcannotattesttotheaccuracyofthisinformationUseofaterminthisbookshouldnotberegardedasaffectingthevalidityofanytrademarkorservicemarkWarningandDisclaimerEveryefforthasbeenmadetomakethisbookascompleteandasaccurateaspossible,butnowarrantyorfitnessisimpliedTheinformationprovidedisonan“asis”basisTheauthorandthepublishershallhaveneitherliabilitynorresponsibilitytoanypersonorentitywithrespecttoanylossordamagesarisingfromtheinformationcontainedinthisbookBulkSalesSamsPublishingoffersexcellentdiscountsonthisbookwhenorderedinquantityforbulkpurchasesorspecialsalesFormoreinformation,pleasecontactUSCorporateandGovernmentSalescorpsalespearsontechgroupcomForsalesoutsideoftheUS,pleasecontactInternationalSalesinternationalpearsonedcomAssociatePublisherGregWiegandAcquisitionsEditorLorettaYatesDevelopmentEditorKevinHowardManagingEditorGinaKanouseProjectEditorChristyHackerdCopyEditorCheriClarkSeniorIndexerCherylLenserProofreaderKarenAGillTechnicalEditorDallasRelefordPublishingCoordinatorSharryLeeGregoryDesignerGaryAdairPageLayoutInteractiveCompositionCorporationiiiiiDedicationDrTomandKristaPickardaremorethandearfriendsTheyarelikefamilytoJayneandme,eventhoughwe’veonlyknownthemafewshortyearsOnerunsacrosspeoplesuchasthePickardfamilyrarelywe’resoblessedithappenedtousTomandKrista,weloveyoubothAcknowledgmentsLorettaYatesdeservesspecialthanksforputtingupwithmethroughoutthisbook’swritingShewasalwaystherewhenIneededsomethingAsaneditor,sheistopnotch,makingsureeverythingisin,allthet’sarecrossed,andthei’saredottedLoretta,Ihopewehavemanyprojectstogetherinthefuture!Speakingofbeingthere:KevinHoward,thisbook’sdevelopmenteditor,wasoutstanding!Thisisthefirsttimewe’veworkedtogetheronabookImustsay,thebookwentsmoothlyfromstarttofinish,andIthinkmuchofthatwasduetoKevinHewasalwaysontopofthingsandrespondedquicklywhenIasked,andIsureappreciatehimDallasRelefordhadtoworkthroughalltheglitches,technicalproblems,andoutrighterrorsthatIwroteintothisbook’sfirstdraftAnyproblemsthatmightbeleftareallmineDallas,I’malwaysthrilledwhenIlearnyou’remybook’stechnicaleditorIknowthatcaringeyesarereviewingeveryword,whileatthesametimeyougivemelotsoffreedomtosaywhatIwanttosayChristyHackerdkeptthefilesmovingsmoothlythroughthebook’sproductionChristyalwaysrespondedtomyemailsquickly,shemadethenormallyhorridauthorreviewprocessmucheasierforme,andIappreciateherChristy,youcanbemybooks’projecteditorfromnowonPerhapsthehardestworkingeditorwasCheriClarkgivenhowquicklyIhadtoturninwritingIhadfarlesstimetoproofreadmymanuscriptbeforeturningineachchapter,andI’mafraidthatCheriwastheonewhopaidthepriceIfeelit’smyjobtomaketheeditorsworkless,notmore,butinthiscaseIdidtheoppositeKudosforCheriformakingmysentencesreadableInaddition,theotherstaffandeditorsonthisprojectmadethisbookbetterthanitotherwisecouldbeFinally,IwanttoexpressmassivethankstoreaderswhokeepcomingbacktomytitlesTeachingyouhowtodosomethingisnothingbutapleasureformeIlovehearingfromyou,sofeelfreetowriteDependingonmyworkload,IalwaysdomybesttoanswerTravelanddeadlinessometimespushemaildowntoalowpriority,butwhenIcanrespond,IdoYoucancontactmeatOfficeBidMentorcom(TheBidMentorcomcomesfrommyeBaydomainIteachothershowtobesuccessfuloneBay)Ofcourse,intoday’sworld,somevalidemailsgetfilteredoutduetohighoctanespamfiltersthatfilterimproperlynevertheless,ingeneralmyemailsystemishighlyreliable,andIshouldgetwhatyousendGregPerryWeWanttoHearfromYou!Asthereaderofthisbook,youareourmostimportantcriticandcommentatorWevalueyouropinionandwanttoknowwhatwe’redoingright,whatwecoulddobetter,whatareasyou’dliketoseeuspublishin,andanyotherwordsofwisdomyou’rewillingtopassourwayAsanassociatepublisherforSamsPublishing,IwelcomeyourcommentsYoucanemailorwritemedirectlytoletmeknowwhatyoudidordidn’tlikeaboutthisbookaswellaswhatwecandotomakeourbooksbetterPleasenotethatIcannothelpyouwithtechnicalproblemsrelatedtothetopicofthisbookWedohaveaUserServicesgroup,however,whereIwillforwardspecifictechnicalquestionsrelatedtothebookWhenyouwrite,pleasebesuretoincludethisbook’stitleandauthoraswellasyourname,emailaddress,andphonenumberIwillcarefullyreviewyourcommentsandsharethemwiththeauthorandeditorswhoworkedonthebookEmail:feedbacksamspublishingcomMail:GregWiegandAssociatePublisherSamsPublishingEastthStreetIndianapolis,INUSAReaderServicesVisitourwebsiteandregisterthisbookatwwwsamspublishingcomregisterforconvenientaccesstoanyupdates,downloads,orerratathatmightbeavailableforthisbookivIntroductionMicrosoftCorporation’sOfficeproductshaveaninstalledbaseofmorethanmillionlicensedusersMorethanoftheFortunecompaniesuseMicrosoftOfficeMicrosoftcompletelyredesignedtheOfficeinterfacewhenitproducedOfficeMicrosoft’sgoalwastomaketheOfficeinterfaceeasierthanevertouse,aswellasmoreintegratedamongotherapplicationsandtheInternetByredesigningtheinterface,MicrosoftineffectdidawaywithmenusandtoolbarsandreplacedtheinterfacewithaneverchangingribbonacrossthetopoftheOfficeproductscreensTomanyOfficeoldtimers,theribbonwasaboldmoveMicrosoftdidawaywiththeinterfacewe’vebeenusingforwhatseemslikeforeverAtfirst,theribbonmightfrustrateyouYou’llfindyourselfwondering,“Where’sthatoptionIneed”Ifyoulookupattheribbon,you’llprobablyfindit!Theribbonchangesdependingonwhatyou’redoingatthetimeIfyouneedafeaturethatyouusedtohavetohuntthroughmenustolocate,you’llprobablyfinditontheribbonOfficeprosarehappilyfindingthatafterasessionortwowithOffice,theywonderhowtheyeverworkedefficientlywiththeclunkymenusandtoolbarsthatusedtobethereBrandnewOfficeusersmaynoteverknowhowwelltheyhaveitwiththenewinterfaceTheribbonmakesitfarsimplertomasterOfficethanthemenusystemdidInaddition,thegraphicalfeaturesofOffice,especiallywhenusedwithaWindowsVista–compatiblecomputerwithAerographicscapabilities,makelearningOfficeapleasureandaquickpleasureatthatYouprobablyareanxioustogetstartedwithOfficeTakejustafewpreliminarymomentstoacquaintyourselfwiththedesignofthisbook,asdescribedinthenextfewsectionsWhoShouldReadThisBookThisbookisforbothbeginningandadvancedOfficeusersReadersrarelybelievethatloftyclaim,forgoodreason,butthedesignofthisbookandthenatureofOfficemakeitpossibleforthisbooktoaddressthatwideofanaudienceThereasonissimple:ThebookyouholdinyourhandsapproachesOfficethewaythatmostusersapproachOfficeinthatataskneedstobedoneandthisbookshowsyouhowtodoitAllmajorandmostminorOfficefeaturesarenottaughtfromatheoreticalviewpointyoudon’treadparagraphafterparagraphofbackgroundbeforelearninghowsomethingworksInstead,youseehowsomethingworksinastepbysteplessonForexample,ifyouwanttocreateanExcelgraph,you’lljumptothetaskinthisbookthatwalksyouthroughthecreationofanExcelgraphWhybotherwithabackgroundofcolorpaletteswhenyouneedasimplepiechartReadersunfamiliarwithWindows–basedenvironmentswillfindplentyofintroductoryhelpherethatbringsthemquicklyuptospeedThisbookshowsyouhowtodoworkinOffice,aswellashowtomanagemanyoftheInternetbasedOfficeelementsthatyouneedinordertouseOfficeintoday’sonline,connectedworldIfyouarenewtotheInternet,thisbookhelpsyougetstartedandshowsyouhowtocombinetheInternetwithOfficetogainsynergyfrombothQuitesimply,thisbooktalkstonewcomerswithouttalkingdowntothemThisbookalsobringsthosewhopresentlyuseaMicrosoftOfficeproductuptospeedwithOfficeYoufaceamightydramaticinterfacechange,astheprecedingsectionexplainedWiththefundamentalOfficeunderstandingyoualreadyhave,youwillappreciatethenewfeaturesandaddedpowerofOffice,andyou’lllearnhowtomaximizeyouruseoftheOfficeribbontogetyourworkdonequicklyandeasilyWhatThisBookDoesforYouAlthoughthisbookisnotacomplicatedreferencebook,you’lllearnalmosteveryaspectofOfficefromataskbased,typicaluser’spointofviewOfficeincludesmanyadvancedtechnicaldetailsthatmostusersneverneed,andthisbookdoesnotwasteyourtimewiththoseYouwanttogetuptospeedwithOfficenow,andthisbookhelpsyoufulfillthatgoalThoseofyouwhoaretiredofthemassofquickfixcomputertitlesclutteringtoday’sshelveswillfindawelcomereprievehereThisbookpresentsboththeIntroductionviIntroductionviibackgroundanddescriptionsthatanewOfficeuserneedswithoutburdeningyouwithalotoftheoryThisbookispracticalandprovidesaplethoraofstepbysteptaskwalkthroughsthatyoucanfollowwhenyouneedafeaturethatataskdemonstrateswhileignoringthetasksyoudon’tneedatthetimeThisistrulyahandsonbookforanyOfficeuser,fromnovicetoproThesetasksguideyouthroughallthecommonOfficeactionsyouneedtoperformtomakeOfficeworkforyouConventionsUsedinThisBookGiventhatthisbookistaskbased,almosteverythingshowntoyouisperformedinastepbysteptaskWhenyoureadatask,you’lllearnaboutothertasksthatyoushouldunderstandfirstForexample,beforelearninghowtoaddtexttoaPowerPointslide,youneedtoknowhowtoinsertaslideintoanewPowerPointpresentationThecrossreferenceforthatpreliminarytaskisrightthereforyoutoreviewOthertasksformabasisorafoundationforsubsequenttasksinthebookForexample,whenyoufollowthetaskthatshowsyouhowtoformatExcelcells,thetaskalsolistsothertasksthatmightbebeneficialtoyouafteryoucompletethecellformattingtaskThesecrossreferencesamongthetasksformwebpage–likelinkstotheothertaskssothatyou’resuretogetaroundedwalkthroughofwhateveryouwanttodoMosthandsontasksincludea“BeforeYouBegin”and“SeeAlso”crossreferencesectionlikethisone:➜SEEALSO✔BEFOREYOUBEGINSetUpPageFormattingConditionallyFormatDataAboutExcelStyles,Themes,andTemplatesEnterDataintoaWorksheetInadditiontothestepbysteptasks,you’llfindseveral“About”tasksThesetasksgiveyounecessarybackgroundwhenthatbackgroundisrequiredtodosomethingelseForexample,beforelearninghowtoapplyathemetoanExcelworksheet,youneedtounderstandhowstyles,themes,andtemplatesgotogethertohelpreduceyourworktimeandincreaseyourproductivityTherefore,the“AboutExcelStyles,Themes,andTemplates”task(tasknumber)providesthebackg

用户评价(4)

关闭

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

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

提示

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

文档小程序码

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

1

打开微信

2

扫描小程序码

3

发布寻找信息

4

等待寻找结果

我知道了
评分:

/49

Office2007教程

仅供在线阅读

VIP

在线
客服

免费
邮箱

爱问共享资料服务号

扫描关注领取更多福利