Wiley Office 2003 Simplified
Contents
1. t3 DON serra pos deii dni ede bo dei Format the Worksheet Tab Color clle Find and Replace Dale xs acu mode doceo oa dede a doa de dde ded dca ob Rico A n SOIT De aus boon bene Boo oo wee eee ees ea oe ces hana Filter Data with AutoFilter cere RI e es Insert O COMME acus sx meg E E A CERA aedes modo TAS pe dg om ob Rep rre Track and Review Workbook Changes amp ur o nrw NE ies IO Working with Formulas and Functions Undertndino FORUMUIES saga di Eb 29 E q do ERED OED A eate OM a oko Sees ke ed A ARRE tee dane beets oa A DOING a Range Namie se aod eda ed heed ch tee E Oe eee ee ew dhe Reference Ranges in Formulas 000 eee ee eee eas Reference Cells from Other Worksheets 00 0 cee ee ees Apply Absolute and Relative Cell References o ooooooooooooo Uncerntnding FONCIONS assada dica 3 0 33 deeded eh wea dae S SADE O MO PONCHO PETIT Fee oe E rm Tolar Ces TIS AO SU seriado dey de dic Red a AE a p dea Audita Worksheet TOI ENOS psanttsdesisd PER PEE CEA SEDE SEE DA Formatting Worksheets E Fresh Fruit Ty SS Change Number Formal 644 6 00422 666 cot decidi d de Ro i de id de 162 E change ME FON AROS rss ke tree a 3 DE X OR i EC AOS 164 incercase or Decrease DECIAS sas quad ads ded ee ASAP eq or Sid e GR 166 Change Daid CO aca X scie 3 RAM REER EREE RP CR ARRE d 167 Adjust the Cell AQ 2 ii Geode dee a eRe x doe Jogo RR 168 COT up A RA a eee ee ee gd2. a eee ILE ee eb eee ba bee bad Sh ee abe ede ea ays 58 Create Bulleted or Numbered USS a aca ap ut po 303 de OC dI 3 4A ED ord de ES 60 SEL IH ee pea X QR Ra ISP RR Qd AI E EX ee eae X qup SCR AT Red 62 A DIA DESTAS ORAL aa 1 64 Format with Styles hs 8 Word d Format Tools Table Window Helo H C c it v E E RC amp ADE SR My Docume aditum ou can use Word s basic formatting ommands bold italic and underline o quickly add formatting to your text These three formatting styles are the mos ommon ways to change the appearance of the text 1 at w Table of Contents gt Working with Tables T Re paia RSI CATARATA eS EER a dd A Draw serra EEEE EE p 4 9 ES tres tee cach ek V udo L de d selled rel eT corpreriras cido rare ri AAA Adjust the Column Wiath or Row Height x 60 x 9 R NE s ke a x RR a AGO Coups and ROWS auieraraliredar cierra rra Delete Columns and ROWS ssa ead ee 3 oA C0 dh dnd e R R RC na MOTE IBIS ESE TTT AE R E R ews ee bees ABD Table yue ast TTT id DR Rr pad nae 0 0 KLE KALRA EA A A dd dd Resize a Table d eee a hbk es Sooo RHE CHEECH TESES 6 Adding Extra Touches Add Borders and SISMO 16 Text i ad od eed daw o d e KDE ede ERE EO ORES ment CSK 0 ni Create Columns 0 leere ZA please confirm Add Header oand FOOIE 3 a eos daret abs d dac dolce dad FENDA deo drerit di ia dd that everyone knows ES COI raid he ea
3. 170 Copy CSL TOMAN amp 6464 654 665s rekk Ek ESAERAN ESRI ERER 171 Add Borde recrearse dd dad did ee bee E a ee eee 172 Format Data with AutoFormat cess 174 12 Working with Charts Create a Chart with Chart Wizard Move and raa T ba og 933 49 oa UAE rr ad Change e Chart TYDE narrar eee ee eek Gs Ga SDS ee Om eae Change the ARES TIES qua a Ge hare eed RIAD OS EHR e Ce REDE OE Forma Na ODECE Sou 69 9279 daria esse ee ee bebe aa EA ic iege Add Chart ODECE a a E ee RP O LS ee ee ee ee Change Me Chart Dale eke R 201 6424 SA DS aK i in eee de Od oh deg Table of Contents Part IV PowerPoint I3 Presentation Basics Create a Presentation with the AutoContent Wizard Start a Presentation witha Design Template a casa pads Fra esr eee x E rm xs Build a Blank Presentation RR I ee es Chalice Per PO VONS econ 3 2 3 487 eh RLRE dE CARO SUCH e DOR bad oS l Creating Slides Understanding Slide Elements Pad and Ea MORRO ost ripar rd 4 o9 E IU EXE A39 ee OER bee Chance Me On ane DE 3 2 23 8 3 3 3442 239 1 3 4 2 2 1 Y 44e rre Change We TEXT CO 6 404356 60 eds Gb LEE TASTE CER od bon M ceu uA A c r Change the CAAM pesa rsrs LAS dE DEE E DATADO DA Sad SELIM SOS asados rar dra RR on dos Rd REOR GARD TR E Soda lcm s ese readers Gens RAE EE PEA bed be ES Oe fd Chande me Side ON tb T 29 9 0 344 229 1 30 2 EEE RAS yes Adda NEN us e corra descensos e le EST d SOS aaa pum Edi E Ap Did a E da s
4. Table of Contents Part Office Features Office Basics Start and Exit Office Applications Navigate the Program Windows Work with Task Panes 0 cc eee eee BAN Work with Menus and Toolbars 2 0000s AQ NV Dipayana Hide TOO __ dd Customize Toolbars ssse ro MAD e Find Help with OTMICE osuna een iris is de R R RES Ne E Yeh Rr EG Working with Files Start a New File casaria ds rea NM cr e EO OC CR dr Save a File 9 oid 4 See oS eroe gr E bd uode hee eee os Sees ee eee NM et RT RA LIS A DIO sicario o Pere eee a dE EX ee ee e CERO Eug S PUR 6 6 650cus edes dubai Debe bees oboe di eee eon PRA ee dodo ee ee ee or d Poe The fond aa tt granito 03 5122 131331 4 Cut Copy and Paste Data Ei ana EIS Ds rain Ave wR CR OS Se ww ae E oos d Assign a Password to a File Part Il Word 3 Adding Text Change WOO S VIEWS barcas ardid Rae AA 34 o a AMM 3 doc ded adhara 3obucack 4 AA Y 36 ad 2 acenee Oba aoe Sane ee eee RE Tia hohe ee re boas ae ee 38 MOUS CNG COO DO 246 ens op d dob FOE ER 1 9 0028 LEDERER ER EA 40 Se Te ID A IIA 42 rue ss PTT 44 4 Formatting Text nao DOME TOMAM tad 3 3 a esr ae sra dr doe Vo UE d he v doge dca qo 46 S s INE RO P 48 Eno INS P NES uus Sete shee E H RR ce oes ESSERE ugs xA 50 T mro PP PL T EE T E ee ee eee EE Co eaea TTT 53 PCE 5 fake aes Gee oe eS ee Ee ee ae oS Eda NA RED 54 lw sirenita ne Sees rrr 56 A podes eS
5. ae Ada Ra NO SIGS casos nero opa SEG EEE OSE Ea ea DA Ad POG BIAS es viral da Ba aa Kove CSCS e a TTT Rese e ODOC TTT Change the Slide Background Color Pog te NOS ripar aes Ases canbe a bORR eh et Epi ee es R sus ES ARRAY ESSE EERE AEE EEE OEE Eee Ed i5 Assembling a Slide Show insert and Delete SNES bes 444444 R dd 93 3 3 64 HOR 84H S44 Ed EE EE E heremo pr aaa drid Create a Summary SJE x ose ehh Ga died hd CR SERE ACE doe E Ge io dos die s Define Slide TENSIONS a4 oo amp 4 4 goa woe rio ed ae R R DEAE ei EORR E Add Animation Ecos ussacksas3 sag sca o x uhr 3X rg xa acc iia we d oA Animate Individual Slide Elements 16 Presenting a Slide Show Rehearse a Presentation ees Run a Slide SHOW 24200524 Ra R RUR LR Re cx om RUE Ree x boe EDS bo mom eate Speaker TIDO Chua dpud Paca dodici R AT R X EO GERE eee eriep Package Your Presentation on a CD Table of Contents Part V Access 17 Database Basics Understanding Database Basics o o ooooooooroo RRR Create a Blank Database Create a Database Based on a Template IS Adding Data Using Tables Create a Table eee ee ete eee enna Create a Table WI Wield au acu deca oic E a irera ded oe RO CRY oe ee Change Table MENS sir rt p EE d EA E OY Oe SOS OEE ES P E A Aae E A A DE SD SA Delete a Field Hide a Field Move a Field Add a Record Delete a Recordad I9 Adding Data Using Forms Create a Form distr a NA i
6. and Graphics 25 Using the Office Internet Tools EA wef bead ae TS A Pieview a Hass WEN Pate 6 60042 a R zb tss a d RES ea EGE aes Set Alternative Text for an Object ee ees PE DP A bh ae ae ITE WES DR sareret eed PAG POR e ewe eek Cee bam ene OE 26 Using the Office Graphics Tools Diaw Uer oe kw e he eee ERA eh KR RO ia EA lc AE sudan errar doe bas Gee beans te hd rhe E ee ees oes eee View Cho Art wit the Cho Organizer posa dca kk ey og hod eC RC eo dd Download Clip Art from the Web ccccccccccccc e eee ae le oc det T eda wee band TTD SCA sis ONO i ee ee ee ee a Move and Resize an ODJECE s bce e a dor eee 0 S eee we ht Qe AAA Bone BE USE E assa babies a een ee hee peta do ER PU E d d i ass KP Formal GW OU eee ES
7. e ae nde ee heen A RdA OT the date cha Insert Footnotes and Endnotes 000 cece eee ee rna v hke Insert Page Numbers and Page Breaks 7 Previewing and Printing Documents Bite ek ols EXT a ee ae ee ee dd a dd ee ee ee ee ee E Check PAIN and GINO aee uacua vs awe Pose E dad db dee een v o Hi Bill Can you sent me a Copy Work with AUtOLOITeCE concurs bb eG SEER EERO CREE REET EOE E A of the quarderly sales report four your divison Track and Review Document CHANGES sex manda bi ead Eo Aida Pas Eia a DOCUMEN 9 Z Erd Z E E A Z 6 e EA LA R A LA T LLE CC ET eh oe eo da PEGADA Eta hk h DA ey Pintan ENVELOPE 64 42 od dd de hh ad GASH dA DES Part Ill Excel 8 Building Spreadsheets Ear A O E ge eh T Sle GIy TTT Faster Data Entry With Paol oa cai ob bbe KG SSR SEEGERS A Add Columns and ROWS a oaa doo is aa Delete Columns and ROWS 24 hued a ono OR ACCRUE RC Reno ORO EDR ORES Resize Columns and Rows e R a R R R R R R rr rns Tum On TER Aese UT Center Data Across COMME acus acrior polo R d REOR Rn EROR OR baiia Freeze Column or ROW sauces era cR deo eR RE eC Remove Data or Cells RR RR RR RR Res Table of Contents 9 Worksheet Basics Assign Worksheet Names amp 4 442080 00 keds ee howe ea ee ob E Roe XR Delete a Worksheet cv xad e e OCCUR OCC a OO a oda Add a Worksheet a a a4 wage x SAD de o I ER e CE ROO EO AAA Move a Worksheet eee RR rns
8. ua dene daa Ry4Reae R beR RAO DIA RICE E LAG OS s e oM TTC Te PeO 4 23 3 26 RA ox qx P0 ed oe deu dE XAR ROTE R LAR wR Delete a RECO 4 caer he eee ee RU PISA DPS DE DESDE DITA LEDS SA COS FORO VISUS akan padded FI RES DMA Ee Ree bea a a Oe SSG gawk ba be POPA CEARA FE PRICE T0125 23 EEES d v ed DEIS Fed p94 ce eek be eehGd Reba de hd G4 OES ICSI DELLA ERES DES OIG coronaria AEREA e ded Ju du de DE 20 Finding and Querying Data zo c0 44 624 h54b4 Akane 6 oo he ee O U i ais v PUPPI PERO acsuHple QUER 4 0 d KR acd deo Ear de A Pee RDO rpm Table of Contents Part VI Outlook 21 Organizing with Outlook view OgUODE COMPONENTS erre ended eo eee R E 4X 9 309 R09 9 Schedule an Appointment segura aaa eh eee wed RA E dE Schedule a Recurring Appointment COCO bec at eee A Pen GIGS rcr LIEME A o A O E ES AA PIO I ee lG Ww o es ot ow ee he KR ee A aed oe E de eee ewe RACE SARA RIE Outlook MES sessa gid Rede 304 Sacer dran d dep eRe yb E 22 E mailing with Outlook Compose and Sena a MESSAGE cacasadda quee dort BR Ed a E EDS E Ra ura Rod OS 316 keadan TOT o is 6 ANN RR A 39 408 ee 318 Turn OI the Reading PRE bak Gee pon 3 a7 Ena RE t E a 319 Rep to GT Forward a Mesage aa adco REPE dE doc Rd m b erp ard dad 320 Add a Sender to Your Address BOOK vos p46 Wee A oe eR Po EX ER ORTH 322 Delte MESS 313 243 9 3 94 3393 darian hae ok RR S 902 4 9 dd 323 Atach a file toa Mesage 640440504564 Ei dure R
9. x GE qur E RP EE Rad Ru ds 324 SOS SON O WERE TOT TT a T TTL de See L 326 Create a Message BUE 1 acd dex raiz ssh CGA Ii DE N R EE C RE 328 Ld MA ask about the 12 String sale in the paper lam is kind Of guitar writing YOU a ou have 10 ar YO tad in th Part Vil Publisher 23 Publisher Basics Create a Publication ee eee RR aes Create a Blank PUONCAUON css acea dug eu doe dr a eod eG Suede awed od xe Zoom Nand OU as eee de dedos 44 ee ERE EKA Re OE OER EE RO RE MTS E eevee eee DEEE TEATE 225 4 43 9 439 8500 62 2 42 AAA PO r Teat TEX BOE ove Z ue d ud x aus dues GGG Ree VE ap ER deor qr RER una Add a Picture to Publication iii sacs sa ee de a Ree Add CHE All 19 9 PHDDCOBMOD 4245 tee 6 oe booed pa R AR RACE n o 24 Fine Tuning a Publication Chance te Tex Pon Si ke eee weed Hh ra ERA oe ee radeon Change Text AMOS sacana econ eed ceed me on hx edo ee He ewe eos Seg LOI uas ERE PCI E a ee ee 43 929 899 13 1 E dO ee Tre um MT T E pis er ada ira E td T E de e Add a Border e X RRR aviador ds a pa ER dene eed Move a Publication ODJECU 6 acceda dodo 33e 399 do4 rerit priar esce ga IUT VB Lu santa gor aca deg cue eee de ddr ed KH ES dida 30e 3974 CUA IE DRE pee edcass ec Enar e Enee EANES eeesne teens RE Egit the Pas o FAQS si chic etre aee cane den 48 9 30929 3E 0CACRC 929 938 0093 Table of Contents Part VIII Internet
Download Pdf Manuals
Related Search