Wiley Microsoft Office 2007 Simplified
Contents
1. ach doce RN a oar Faster Data Entry With AUtoFill esencia ES ad 13 EE aes Add Columns and ROWS atico aa cM dba bb ybi eR ME ds RAE dde E Delete Columns and ROWS 4er dadas EErEE dod doe dob dudes de Resize Columns and ROWS 4 0 riadas sa idad ea iaa Turn On Text Wrapping vc ra ds A Center Data Across Columns oooocoococococo ee Freeze a Column OF ROW evita a WE aa Remove Data or Cells see sl lO Worksheet Basics Assign Worksheet Nares uisa pa Ie qr PE dodo Est oe DLE Delete a Worksheet o oooooocooorrr nnn Add a WOPKSDIeBL ostra Move a Worksheet esca grrr e aida Rab debet ala ib Copy a Worksheet usaras ri es de A s de A Format the Worksheet Tab Color 1 2 0 ccc eee eee Fing and Replace Data sch dce shen doy 9r rbd Ae HE Shh garded Eo Ha SOn Data osa es ns ay o edipi deg Filter Data with AUCOFIE avisador AR aaa a Inserte COMMEN ca go 15 329 doeed g Guy pa aa a Track and Review Workbook Changes Change Page Setup Options isses ere a de doe dos Working with Formulas and Functions Understanding Formulas iii n soe eet ea da E Rer aed d RR a CREOLE UPONMCUAS urea ii dap eren siete ie det deer di id G Deme a Range NAME vu d race d ai d Oe aed Lond a Reference Ranges in Forrn las e emisario c ken c SP a Ro Cw Reference Cells from Other Worksheets vrai dee notae ede Apply Absolute and Relative Cell References llli Understanding FUNCIONS coronas derrita A ODI a FUNCION andrad2. apad qu pbi pha behead ep p der dT id Change the Font and SIZE ansa kandi ane thee daa oe Rees Change TNE Iext Colof 4e Oe eR Re dea de Ob HE e R09 96 06 e S Change the TEXESYIE ari dato ie pee ARA Change the Text ANGQnmMent aria ee nad ke xp ege x pr ee A aes Set LME SPACING ohsaG 0de bdo tete ed ane ERE ondas AOS RUSE Robes ASSION A THEME ades dee gad debo db a a Change the Slide Layout uaa side Wie Rec ee don tie ego Eon Meee Add a New TEXCODJECE sarama he b Seem odo nb mann obe pb Ded Add Clip Art to a Slide uud iud gem det hehe dies Mow aie es Add a Chait toa Slide iio aida io eR ded aioe gic Rr i e See TN TRUE Adda Table toa Slide 12 sud meh ar bid er Move a Slide OBJET parice nier ne db RR RI PERRA ganna d RR E Resize a Slide ODJECE criar Hoge dep AA CR ad Meg SUR b RR Ra o 16 Assembling a Slide Show Insert and Delete Slides 2 0 cee eee Reorganize SlIdES PEE Define Slide Transitions o o o oooooooorrrr nh Add Animation Effects iusso ge beo me dae ene dre eae aoe ee He Insenta Media Cl cceearaedtieoeeeaeegpedaivhetecca ne gedwhde ga Record Nanaon ciar dox cse id ideada Set Up a Slide SHOW icucecuettd de bau deber e ERR a Rea pd dadas Table of Contents 17 Presenting a Slide Show MY Presentation Y Reliearse a Slide SHOW ssec dither aside bade ae hada edad ead Run a Slide Show Create Speaker Notes Package Your Presentation on a CD Part V Access Database Basics Understanding Databa
3. ANON xu Atos MOORE erite edat IE IP PUR a 374 B Dessert Menu 0 ce a OK 25 Fine Tune a Publication Change the Text Font and Size Change the NERC SS ataca npe e dea tended PEN te Change Text AUGTIIeDE usas xad xxx er iR a P dope gars Change Text Cole air ride dpa edendo pd orn Text UE GER 2010 ta sq e nee mo dob e teclea oe arbor Adde BOER aua bac AS A e d Move a Publication Object ses ea geo te mede qr p a CR e pe RR p nta 382 rey a uh Resize a Publication Object veis reeds Pp ER 383 tm sti Fonbs T BORES renada dra rra rider 384 immu oai Edit the Background Page sss ases RR REY edad red etad dan dad 386 Adda Design Gallery Object ee 24a rare a rette enaa boten gods 388 Usesthe Content HOAN aruis sce ug apse XH ser up n n Rel RA CIS aad adores 390
4. Saadeh ase waked aaah aa Delete Columns OF RONS ina cedi ak GO ea daa Aa Brem INCIP Split Table Cells asocia raid ea IP bibi a de a Apply Table Styles acc00icds 4 mirai da e ekle Robe sb ee ahead Change Cell Alignment Repositionia Table uasa 00 eue Re dES C PEERS C ERG EARS E EE Resize a Table cx cesta Sot ee do dois dete Ando soa bd dede pd dede bad 7 Adding Extra Touches ASSIGN MEME asas Gade arate aces A gt hole GAS Pease Saw eS AGG BOWES ds ee beeen boe dade needs bd Create COUME segador a aa bay de ICA ed Add Headers and Footers 152a add eR RR radiador Hd Insert Comments 22 4e aa eR eed dob eda e x da eid insert Footnotes and Endnetes ss ssepe eee bere aep dor peers Insert Page Numbers and Page Breaks Reviewing and Printing Documents Fired Replace TEKE orbe paras DMM red 122 Check Spelling and Grammar soccer TP E Rid esque 124 Work with AutoCorrect sessiles e 126 lan you sent me ew Use the Thesaurus culos do edet borea Gow o e acido 128 ifthe guarderly sales RP Check Your Document for Hidden or Personal Data asana aaaea 129 E Track and Review Document Changes 0 ccoo 130 fm E Malla DOCUMENT cor aa dad P Pollio d e a e ode ecd 152 Change Paper Size dubites ci stors cobos daran aros 133 Print an EnveloDe visitara rra 134 Table of Contents Part Ill Excel 9 Building Spreadsheets Enter CelData Allroad oli a ead Select Cells ee d oa tasse Samet sven FR PUR dd
5. Table of Contents Part Office Features Office Basics Start and Exit Office Applications Navigate the Program Windows sese ee o Pom Work with the Ribbon cao so koe deo ceo Ze eene Customize the Quick Access Toolbar Final Customizing ODUeis vea cara daras NN t e y mes Turn Off Live Preview usa epo dora e RR e eR et Find Help with Office oooocoooommommomrr RM Diagnose Offfee Programs a cusa auc S ea AN c eem eds 2 Working with Files Statt a INeWRIIG soria a took c dern dedo aca db de n ede dut cc SAVERS re hd gk Rid read dob ER d dedo dede lod Open an Existe deron a tn ii GB De o ue D ilg acs dy eee a idad lada MaR ada dedii Tha IR abb dedo Ra Red ee Cut Copy and Paste Data MEW Multiple BES 3 2 9 9 mtm Dao arem ei ate aa te Boedo 3 Office Internet and Graphics Tools Create an FOME Ple scan a os di a dd Add Spese 3er tina dba d fb hk tee hea ais Diaw AtutoShapes ante dew a d OR RS Sa Ce RR pp xS ia ada a WSS CUDA osa dcin CER a od od diete d olde iet ected View Clip Art with the Clip Organizer edicere dai amii aa aua a a aa Seta PCG Coss AA A ad Inserta Word Art ODJECE esa rra e da Move aid Resize an Object sumisa ratas Fe Rotate and FIP ODJECE iut acted ia ty 6b rh qoos Top aca deo doe Copa PIQUE PETTY Arange Obes 2 229 pac n 19 9 9 taunted raid ar Control Text Wid RING 25 xs aate eyed ara a a dt Recolor APIC er ari dere A ohana ee nies de Adel SANAR copada arado Ee orte d D eddie
6. da da ds S a Plana Meeting criminal Re aa he Be Created NEW CONOCE es prriss dp e epa A HESS Dp e ede tos Create a New Taslc ias ar a ber d cod Cdi ti o ela dcs Adda Note ues open x eo ii RW eec A C eg e gs Organize Outlook MEMS a u renta cierra prada A Be Perform an Instant Search Customize the ToDo Bar aiia de tod poh ER GRE UP ERSTENEEE Ej 23 E mailing with Outlook Compose and Senda Message x sd s sed tk soo he Rhode aol ne RR Rec Read an Incoming MESSAGE erario btc dde EE egre Control the Reading Pane uua deed e ese 9 ARA Reply to or Forward a Message 0 000 cece eee eee Add a Sender to Your Address Book Delete a Message sidad pue doe Re X ed od ut Cae EO OR REC PUPPES gei Attach a File toa Message isse hh hace OR RR RR RR RR Clean Up the MAllbox sepsis RH E Pared dH ee Screen GN EmMa sa dd gae eaa yer Create a Message R le gt iue suse bee dde Bd da a RRR D about tne 12 Sting iting you to ask 2 Lam Lam witing Ta for sale in the paper quitar you n2 7 wie kind of guitar Part Vil Publisher 24 Publisher Basics Great a PUblicatiOUi iaa qp quie ROCK Redde dad READ 364 Create a Blank Publication arrasa rara ra 366 Zoom Man OU risann doa Seca Rer a Po oe ic a ax Pe a aaa 368 Bd eX 2 444 456 55 55 6048 hdd bone Ea Sed q5 AE Sd quat dde ES 370 Adds New Text BeX Losada tarda rata oon ara Upon dri dip at 371 Add a Picture to a Publication us acce em dex eoe ree a i ados 372 Ada ClipArt toa PUBNC
7. deus Part Il Word 4 Adding Text Change Word s Views Type and Edit Text A E Nr EE E EE N E AET Move and Copy Text Mert Quick Rans rc e aa paneda Eea gd APP a Template i ooo i e pias dar oda isett SUIDOIS 245 pro ida piba dos ad Table of Contents 5 Formatting Text Add Basic Formatting 2005 id ca a doe A Usesthe Mint Toobar corrida doi tons owe Change the Font pecar rra rar trode ea qM qe See CHANGE the EONESIZE us xsara deo de Peace ande PA e de dos Add Golot t9 Text 223 curs biie elo S Allg Text axscgae o vue TI nEPYqqet quer pee Reqeedgnqeq esee tuqefque Set Dine SPACING iu uec dence orae race RO oar adeste Peu de Eur a end dede Ser Character Spacing 2d doy aa sp ted acr aio aa Apply Color Shading 33 3 19 533 4 9 0 99 90 Each aq e Va qu 4 Rd ove o anew ete pe domed E ae a doe 8 Copy FOM esos uet eben teres aged e abd eed S DUE edes oad Clear Forma tN cue a qx qe qe na ox qos quatn Roe Aqu qi pautiem qe Gr jtm OE A A E N A E ay Create Bulleted or Numbered Lists rra ra AR e p Set MARGINS 12 a rs Soak dox des A Seed eee Ai Format with Styles corner adi ad dp 6 Working with Tables Insert a Table 45 2uu opa SACER OPE A AREE RUE dr d HERR e nera QUIE Table a5 3 921 1 3E PIS Hh eto 5 ets hang Drawa fable curada abres arrieros id Insert an Excel Spreadsheet issues Rh caue a a Selectable Cells arios eee eek eee es incas a psi Adjust the Column Width or Row Height Add Columns and ROWS 114 da neue
8. e a rc di deb aded facic rel Total Cele With AUTOSUM aue exa em ex p E RE RE ewe RR S Audita Worksheet for EWOIS iu eese ee eroe oho Ak od eget Rond d Mw 12 Formatting Worksheets Change Number Formats ue src mace nme seh Gee eee Renae Change the Font and Size siii a a hee dicke be wy Rr been Increase or Decrease Decimals Change Data Color suere e ee ate TUB PER Go E aS 4 Adjust the Cell ANGREM a vd dinate ayy dod eda phe heh ee Control Data Orlentatlont soci Aer VOR Ic ae oo meee on wots Copy Cell Formatting ese qoe v temen eRe REESE DRE Seo Add BOIdels suse erre yg is Oa Mea pre Format Data with StyIes sexos BEd eaten Ede VOR ed p RC PH eS 4 Assign Conditional Formatting Table of Contents I3 Working with Charts Create Ghart esce ddd ginian Y Gh d ea rbd ARA Moveand Resize Charis 22 520 2 dep od e er e edi ai Change the Chart Type rio a a he ee al RR pL ae e Change the Chart Style susce su rd sanii eee eee A Change the Chart Layout es as years de de urea aided Add Axis TES rca dtp rs Seb REOR E de d A B dol oa edad as Format Chart Objects a 2s sesto eus dor den d AR O o or p ORC A OR qo a dla 8 diced 3 o t ibn Change the Chart Data iss chad eeepc ER diner dne aw de EORR UR a Part IV PowerPoint l4 Presentation Basics Create a Presentation with a Template Build a Blank Presentation llli Change PowerPoint VIEWS i a taa hehe CREER ee i5 Creating Slides Add and Edit Slide Text efaa
9. se Basics Create a Blank Database Create a Database Based on a Template I9 Adding Data Using Tables Create a New Table su ege deeem e ead id eee Create a Table with a Table Template Change Table Views Add a Field Delete a Field Hide a Field MOV a Held pardas rro aora heen Adda Record ase steer e uteretur tr Cu IR a e oo ra te a ar d e Delete Record erebre rra deeem i se PRR 20 Adding Data Using Forms Create a Form Usmo a Wizard asa pe pepebeeba bep deie rr HP Ganda EP God 6 PANI Create a Quick Form rl gA Adda Record sicarios read Navigate RECONGS 2500 broca dre oder a SY Delete Record sis Gode e be odio EE RR RE debeas N e Change Form VIeWS 63 ae eed ia eva dae nde ho m Move ar Bela stop eb eras Eo Delete a Fieldi 22 poda d RES oia Adda Feld 45 32 0 03 dara Ge Showa Rhee SoH hee Fuld db doe rd Change the Field Formatting c2tcacicecrtadabagnadacedabetaua digas Apply a Quek Format 2 555 Makes cd 24e nb debs dede pdt 21 Finding and Querying Data SOM ReCOTdS 2 5 ah ci oe aer debe EA eb nidi Ro d oH Filter ReCOFGS corre Pee pedi degentes od Gab God dede Perform a Simple Query lseseeeeee n Ceea REDOM ua oran PROPERE ag dae dead Shea n iod UR dd be Table of Contents Part Vl Outlook 22 Organizing with Outlook View Outlook Components o ooooooorrr nne Schedule an Appointment ias iaaa doo pa a a nn Schedule a Recurring Appointment Schedule an Event asocia Siekia
Download Pdf Manuals
Related Search