The Complete Idiot's Guide to Microsoft Office 2000 (1998)

Introduction. I. MICROSOFT OFFICE OVER EASY. 1. 10-Minute Guide to Office 2000 Professional. Running Your Office Applications. Scooting Up to the Shortcut Bar. Saving, Naming, and Opening the Files You Create. Working with the Smart New Office Interface. Not-So-Basic Mouse Moves. 2. When in Doubt, Ask for Help. Meeting Your Office Assistant. Finding Help Topics in the Table of Contents. Getting Help from the Answer Wizard. Searching the Index for Specific Help. II. WHIPPING UP WORD DOCUMENTS. 3. Making and Editing Word Documents. Starting with the Boilerplate Special. Inserting, Typing Over, and Deleting Text. What's with the Red Pen? Typing Text Has Never Been Easier! Scroll, Scroll, Scroll Your Document. Changing Views. 10 Ways to Select Text. Dragging, Cutting, and Copying Text. Juggling Two or More Documents. The Ol' Find and Replace Trick. On Second Thought: Undoing Changes. 4. Giving Your Text a Makeover. Fast and Easy Formatting with the Toolbar. Two More Formatting Tricks. Visiting the Font Smorgasbord. Paragraph Formatting: Line Spacing and Indents. Ruling Your Indented Servants. Keeping Tabs on Your Tabs. The Painted Word: Using Text As Art. Baby, You've Got Style(s). 5. Aligning Your Text with Columns and Tables. Creating Your Own Newspaper Columns. Avoiding Gridlock with Tables. Moving Around Inside Your Table. Performing Reconstructive Surgery on Your Table. 6. Spicing It Up with Graphics, Sound, and Video. Inserting Pictures, Sounds, and Video Clips from the Gallery. Inserting Scanned Images On-the-Fly. Importing Graphics Files. Moving Pictures Around on a Page. Resizing and Reshaping Your Pictures. Touching Up a Picture with the Picture Toolbar. Sketching Custom Illustrations. 7. Checking Your Spelling and Grammar. Looking for Mis Spellings. Making Word Automatically Correct Your Typos. Word's Helpful, Useful, Beneficial Thesaurus. 8. Creating Mailing Labels and Form Letters. Addressing an Envelope or Mailing Label. Merging Your Address List with a Form Letter. 9. Everything You've Always Wanted to Know About Printing Documents. Setting Up Your Pages for Printing. Chopping Your Text into Pages. Head-Banging Headers and Foot-Stomping Footers. Previewing Pages Before Printing Them. Ready, Set, Go to the Printer. III. CRUNCHING NUMBERS WITH EXCEL SPREADSHEETS. 10. Spreadsheet Orientation Day. Taking Excel on the Open Road. All Data Entries Are Not Created Equal. Entering Data. Secrets of the Data Entry Masters. Life in the Cell Block: Selecting Cells. Roaming the Range. Working with Worksheets. All This and a Database, Too? 11. Doing Math with Formulas. Understanding Formulas and Concocting Your Own. Going Turbo with Functions. Controlling Cell Addresses When You Copy or Move Formulas. Playing If...? with Scenarios. 12. Giving Your Worksheet a Professional Look. Tweaking Row Heights and Column Widths. Fission and Fusion: Merging and Splitting Cells. Add a Few Rows, Toss in Some Columns. Nuking Rows, Columns, and Cells. Making It Look Great in 10 Minutes or Less. Hanging a Few Graphical Ornaments. 13. Graphing Data for Fun and Profit. Charting Your Data. So Now You Want to Print It? Changing Your Chart with Toolbars, Menus, and Right-Clicks. Bar Charts, Pie Charts, and Other Chart Types. Formatting the Elements That Make Up a Chart. Adding Text, Arrows, and Other Objects. 14. Printing Wide Worksheets on Narrow Pages. Preprinting: Laying the Groundwork. When It Just Won't Fit. Finally! Printing Your Worksheets. IV. SNAPPING SLIDE SHOWS IN POWERPOINT. 15. Slapping Together a Basic Slide Show. Start from Scratch? Nah! Changing Views to Edit and Sort Your Slides. Inserting and Deleting Slides. Changing the Background, Color Scheme, and Layout. Taking Control with the Master Slide. 16. Adding Text, Graphics, and Sounds to a Slide. As If You Didn't Have Enough Text. Jazzing Up Your Slides with Clip Art and Other Pictures. Backing Up Your Claims with Charts (Graphs). Adding Sounds to Your Slides. Going Multimedia with Video Clips. 17. Shuffling and Presenting Your Slide Show. Rearranging Your Slides. Adding Special Effects. It's Show Time! V. MASTERING THE INFORMATION AGE WITH ACCESS. 18. Making Your First Database. What Is a Database, Anyway? Database Lingo You Can't Live Without. Cranking Out a Database with the Database Wizard. Creating and Customizing Tables. Creating and Customizing Data Entry Forms. 19. Entering Data: For the Record. How Forms, Tables, and Datasheets Differ. Filling Out Forms. Entering Data in a Table. What Are These Drop-Down Lists For? 20. Finding, Sorting, and Selecting Records. Sorting Your Records by Number, Name, or Date. Filtering Records to Lighten the Load. Using Queries to Sort, Select, and Calculate. 21. Giving Data Meaning with Reports. The Report You Need May Already Exist! Making Reports with the Report Wizard. Customizing the Appearance and Content of Your Report. Saving and Printing Reports. VI. LOOKING AFTER YOUR LIFE WITH OUTLOOK. 22. Keeping Track of Dates, Mates, and Things To Do. Getting Started with Outlook. Keeping Appointments with the Calendar. Keeping Track of Birthdays, Anniversaries, and Other Big Events. There's a Rolodex on Your Screen! What Do You Have to Do Today? 23. Managing Your Email. Nickel Tour of the Inbox. Adding Email Accounts. Creating a New Email Message. Retrieving and Reading Incoming Messages. Organizing Messages in Folders. Sending Faxes. VII. GETTING PRODUCTIVE WITH OFFICE 2000. 24. Sharing Data Between Applications. Dynamic Data Sharing with OLE. Transforming Word Documents into Presentations and Vice Versa. Publishing Access Reports in Word. Analyzing Your Access Database in Excel. 25. Creating and Publishing Your Own Web Pages. Creating Web Pages in Word. Creating an Online Presentation in PowerPoint. Placing Your Pages on the Web. Managing Your Web Site with FrontPage. 26. Macros for Mere Mortals. Roll 'em: Recording a Macro. Playing Back a Recorded Macro. Assigning Shortcut Keys for Quick Playback. Making Buttons for Your Macros. Saving Your Macros. 27. No-Brainer Publications with Microsoft Publisher. Conjuring Up Quick Publications with PageWizards. Basic Stuff You Ought to Know. Customizing a Prefab Publication. Page Layout Tools You Can't Live Without. Printing Professional-Looking Publications. Printing to a File for Outside Printing. Glossary. Index.