You are previewing Sams Teach Yourself Microsoft® Office 2003 in 24 Hours.
O'Reilly logo
Sams Teach Yourself Microsoft® Office 2003 in 24 Hours

Book Description

For readers who are new to Office 11 and want to get up and running quickly, Sams Teach Yourself Microsoft Office 2003 in 24 Hours will do the trick. This book includes shortcuts and ways to accomplish the most common tasks in Office. Readers can work at their own pace through the easily digestible, one-hour lessons. After completing the lessons, the reader will have a solid foundation of the basics and know the most efficient way to utilize the new version of Office.

Table of Contents

  1. Copyright
    1. Dedication
  2. About the Author
  3. Acknowledgments
  4. We Want to Hear from You!
  5. Introduction
    1. Who Should Read This Book?
    2. What This Book Does for You
    3. Can This Book Really Teach Office 2003 in 24 Hours?
    4. Conventions Used in This Book
    5. Start Your 24-Hour Clock
  6. I. Working with Office 2003
    1. 1. Getting Acquainted with Office 2003
      1. What's in Office 2003?
        1. Office Is Fully Integrated
        2. Introducing Word
        3. Introducing Excel
        4. Introducing PowerPoint
        5. Introducing Outlook
        6. Introducing Access
        7. Introducing Publisher
      2. Starting Microsoft Office
      3. The Office Assistant
        1. Customizing the Office Assistant
      4. Typing Your Question
      5. Making Office Easier to Use
      6. Get Ready for the Internet and Office
        1. The Web Toolbar
      7. Summary
      8. Q&A
  7. II. Processing with Word 2003
    1. 2. Welcome to Word 2003
      1. Beginning Words About Word
      2. Documents and Disks
      3. Entering and Editing Text
        1. Entering Text
        2. Navigating Word Documents
        3. Selecting Text
        4. Deleting Text
        5. Copying, Cutting, and Pasting
        6. To Do: Find and Modify Text
        7. To Do: Find and Replace Text
        8. Advanced Find and Replace
        9. AutoCorrecting and AutoFormatting
        10. To Do: Use the AutoCorrect Feature
      4. Correcting Mistakes
      5. Initial Spelling and Grammar Correction
      6. Summary
      7. Q&A
    2. 3. Formatting with Word 2003
      1. Simple Character Formatting
        1. Applying Fonts
        2. Applying Color
      2. To Do: Insert Numbers and Bullets
      3. Paragraph Formatting
        1. Justifying Text
        2. Setting Margins and More
        3. Using Tab Settings
        4. Setting Indentation and Spacing
        5. Making the Ruler Work for You
        6. Inserting Line and Page Breaks
        7. Viewing Your Document's Formatting
      4. Formatting with Styles
      5. Format Painter
        1. To Do: Use the Format Painter to Copy Formatting
      6. Preview for Printing
      7. Controlling View Size
      8. A Word About Word's Wizards
      9. Word Themes
      10. Summary
      11. Q&A
    3. 4. Managing Documents and Customizing Word 2003
      1. Understanding Document Properties
      2. Using Word's Advanced Proofreaders
        1. Using the Spell-Checker
        2. Using the Grammar Checker
        3. Using Automatic Hyphenation
        4. Using the Thesaurus
      3. Simple Translation
      4. Customizing Word to Work for You
        1. Using the Customize Features
        2. Using the Options Settings
      5. Summary
      6. Q&A
    4. 5. Advanced Word 2003
      1. Using Special Characters
      2. Inserting Dates and Page Numbers
      3. Inserting Pictures, Video Clips, and Sounds
        1. To Do: Add Clip Art
      4. Inserting Scanned and Digital Camera Images
      5. To Do: Create and Use AutoText Entries
      6. Adding Tables to Your Documents
        1. To Do: Create a New Table
        2. Traversing the Table
        3. Inserting New Columns and Rows
        4. Drawing Tables Freehand
      7. Creating Multiple Columns
      8. Creating Headers and Footers
        1. To Do: Add a Header and Footer
      9. Adding Footnotes and Endnotes
        1. To Do: Insert a Footnote
      10. Introducing Mail Merge
        1. Preparing for Mail Merge
        2. To Do: Step Through the Mail-Merge Process
      11. Summary
      12. Q&A
  8. III. Computing with Excel 2003
    1. 6. Understanding Excel 2003 Workbooks
      1. Starting Excel
      2. Understanding Worksheets and Workbooks
      3. Entering Worksheet Data
        1. Entering Text
        2. Entering Numbers and Formulas
        3. Entering Dates and Times
      4. Navigating in Excel
      5. To Do: Create Your First Worksheet
      6. To Do: Format the Worksheet
        1. To Do: Complete the Worksheet's Format
      7. Summary
      8. Q&A
    2. 7. Restructuring and Editing Excel 2003 Worksheets
      1. Worksheet Editing
        1. Selecting Cells
        2. Editing Cell Contents
        3. To Do: Correct Cell-Entry Mistakes
      2. Inserting and Deleting
        1. Inserting Entire Cells
        2. To Do: Insert a Cell into a Worksheet
        3. To Do: Insert Rows and Columns
        4. To Do: Delete Rows and Columns
      3. Working with Worksheet Ranges
        1. To Do: Name a Range
      4. Using Formulas
        1. Excel's Primary Math Operators
        2. Using Range Names in Formulas
        3. Relative Versus Absolute Cell Referencing
        4. Copying Formulas
      5. Recalculating Worksheets
      6. Working with Functions
        1. To Do: Use AutoSum for Efficiency
        2. Common Functions
        3. Advanced Functions
      7. Introduction to Worksheet Formatting
        1. Justification
        2. Row and Column Height and Width
        3. Font Changes
      8. Making Format Changes
      9. Summary
      10. Q&A
    3. 8. Using Excel 2003
      1. AutoCorrect Worksheets
        1. Finding and Replacing Data
      2. Reviewing Cut, Copy, and Paste in Excel
      3. Clearing Data
      4. Speed Data Entry
        1. To Do: Use Data Fills
      5. Smarter Fills with AutoFill
      6. Designing Your Own Fills
        1. To Do: Create a Custom List
        2. To Do: Enter Large Amounts of Series Data
      7. A Word About Printing
      8. Adding Comments
      9. Summary
      10. Q&A
    4. 9. Formatting Worksheets to Look Great
      1. AutoFormatting Worksheets
      2. Modifying Styles
        1. To Do: Modify the Default Style
      3. Additional Formatting Options
        1. Special Alignment
        2. Special Cell Borders
        3. Special Cell Shades
      4. Conditional Formatting
      5. Separating Worksheets with Tab Colors
      6. Summary
      7. Q&A
    5. 10. Charting with Excel 2003
      1. Creating Custom Graphs
        1. Choosing the Chart Type
        2. Selecting Data for Your Graph
        3. Modifying the Graph
      2. A Quick Chart
        1. To Do: Create a Quick Chart
      3. Making Your Chart Fancy
        1. To Do: Add a Background Picture to Your Chart
      4. Summary
      5. Q&A
  9. IV. Presenting with Flair
    1. 11. PowerPoint 2003 Presentations
      1. Presenting PowerPoint
      2. Understanding Presentations and Slides
      3. Creating a New Presentation
        1. The AutoContent Wizard and Presentation Design
        2. To Do: Use the AutoContent Wizard
        3. Creating Presentations Using Design Templates
        4. Presenting Your Work
      4. Summary
      5. Q&A
    2. 12. Editing and Arranging Your Presentations
      1. Getting Acquainted with PowerPoint's Views
      2. Using the Outline
        1. Adding and Importing New Items
        2. Promoting and Demoting Elements
      3. Working on the Slide
        1. To Do: Edit a Slide's Text
        2. Using the Slide Sorter View
        3. Using the Notes Page View
      4. Saving and Printing Your Work
      5. Summary
      6. Q&A
    3. 13. PowerPoint 2003 Advanced Features
      1. Changing Your Entire Presentation's Design
        1. To Do: Modify a Design Template
      2. Changing a Single Slide's Design
      3. Editing Individual Slides
        1. Putting Comments in Your Presentations
        2. To Do: Add Text and Text Boxes
      4. Adding Art
      5. Ordering Presentations “To Go”
      6. Summary
      7. Q&A
    4. 14. Animating Your Presentations
      1. Using PowerPoint's Slide Show
        1. To Do: Time Transitions
        2. Transition Effects
        3. Setting Up Shows
        4. Rehearsing Your Slide Show
      2. Voice Narration
      3. To Do: Use Action Buttons
      4. Introducing Animation Schemes
      5. Summary
      6. Q&A
  10. V. Organizing with Outlook 2003
    1. 15. Communicating with Outlook 2003
      1. An Outlook Overview
      2. Outlook Is Not Outlook Express
      3. Understanding the Outlook Screen
      4. Outlook's Folders
      5. Viewing Non-Outlook Data
      6. Mastering Outlook Mail
        1. Organizing Messages
        2. To Do: Set Up an Email Account
        3. To Do: Create and Send Messages
        4. Checking Mail
      7. Keeping Contacts
        1. To Do: Record Contacts
        2. Selecting Contacts
      8. Summary
      9. Q&A
    2. 16. Planning and Scheduling with Outlook 2003
      1. Using the Calendar in Outlook
        1. Navigating Times and Dates
        2. To Do: Set Appointments
        3. Scheduling Meetings
        4. To Do: Schedule a Meeting
        5. To Do: Schedule an Event
        6. Managing a Task List
        7. To Do: Create a Task
      2. Writing Yourself Notes
      3. Expanding the Outlook Bar
      4. Keeping a Journal
        1. Setting Automatic Journal Entry
        2. Adding Journal Entries Manually
        3. To Do: Record a Manual Journal Entry
      5. Smart Tags
      6. Summary
      7. Q&A
  11. VI. Tracking with Access 2003
    1. 17. Access 2003 Basics
      1. Database Basics
        1. Database Tables
        2. Records and Fields
        3. Using a Key Field
      2. Looking at Access
      3. Creating a Database
        1. Understanding Database Objects
        2. To Do: Create a Table
        3. Setting Field Properties
        4. Setting the Key and Saving the Table
        5. Modifying Table Structures
          1. Adding Fields
          2. Deleting Fields
          3. Resizing and Rearranging Fields
        6. Viewing Table Design and Entering Simple Data
      4. Summary
      5. Q&A
    2. 18. Entering and Displaying Access 2003 Data
      1. Entering Table Data
        1. Using the Datasheet View
          1. Entering Data
          2. Formatting Your Data
          3. Editing Data
          4. Navigating Large Tables
          5. Simple Printing
        2. Using Forms to Enter and Edit Data
          1. To Do: Use the Form Wizard to Generate Forms
          2. Navigating Forms
          3. Editing Form Data
          4. Printing Forms
      2. Summary
      3. Q&A
    3. 19. Retrieving Your Data
      1. Using Data Filters
        1. Filter by Selection
        2. To Do: Perform a Filter by Form
      2. Using Queries
        1. Creating a Query with the Query Wizard
        2. To Do: Build a Query with the Simple Query Wizard
        3. Using the Query Design View
          1. To Do: Create a Query from Scratch
          2. To Do: Work with Complex Queries
      3. Summary
      4. Q&A
    4. 20. Reporting with Access 2003
      1. Introducing Access Reports
        1. Generating Simple Reports Using AutoReports
        2. To Do: Produce Quick Reports
        3. Generating Reports Using the Report Wizards
        4. To Do: Use the Report Wizard
          1. Grouping Report Summaries
          2. The Report's Sort and Summary Order
          3. Choosing a Report Layout and Style
      2. Summary
      3. Q&A
  12. VII. Combining Office 2003 and the Internet
    1. 21. Office 2003 and the Internet
      1. How Office Products Combine with the Web
        1. To Do: View Web Pages from Within Office Programs
        2. Viewing Documents in Internet Explorer
        3. Creating Links in Office
      2. Keeping Current
      3. Word Sends Email
        1. To Do: Send Email from Word
      4. To Do: Send Office Documents as Email
      5. Summary
      6. Q&A
    2. 22. Creating Web Content with Word, Excel, Access, and PowerPoint
      1. Preparing to Publish Web Pages
      2. Office and the Web
        1. Word and Web Pages
          1. Saving Word Documents as Web Pages
          2. Using a Word Template to Create a Web Page
        2. Excel and Web Pages
        3. Access and Web Pages
        4. PowerPoint and Web Pages
      3. Summary
      4. Q&A
  13. VIII. Publishing Eye-Catching Documents
    1. 23. Publishing with Flair Using Publisher 2003
      1. All Kinds of Publications
      2. Why Publisher and Not Just Word?
      3. Getting Acquainted with Publisher
      4. To Do: Create Your First Publication
      5. Microsoft Gives Some Online Training
      6. Filling in the Details
      7. Adding Text
      8. Importing Text into Your Documents
      9. Using Text Boxes
      10. Summary
      11. Q&A
    2. 24. Adding Art to Your Publications
      1. Your Publication's Art
      2. Extra Shapes
      3. Designing with the Design Gallery
        1. To Do: Explore the Design Gallery
      4. Getting Help with the Design Checker
      5. Putting Borders Around Your Publications
        1. To Do: Add a Frame
      6. Summary
      7. Q&A
  14. IX. Appendixes
    1. A. Sharing Information Between Office 2003 Programs
      1. Sharing Data Between Applications
        1. To Do: Drag and Drop
        2. Creating Links
        3. To Do: Link to a Worksheet
        4. Creating Shortcuts
        5. To Do: Insert Shortcuts
        6. Inserting Hyperlinks
        7. To Do: Convert Hyperlinks to Text
        8. Turning a Word Document into a Presentation
        9. Using Word and Access
        10. To Do: Use an Access Table in Word
      2. Outlook Letters
        1. To Do: Write a Letter from Outlook
      3. Summary
    2. B. Business Contact Manager and Office Extras
      1. New Office Programs
        1. Microsoft Office InfoPath 2003
        2. Microsoft Office OneNote 2003
        3. Microsoft SharePoint Portal Server
        4. Microsoft Office Outlook 2003 with Business Contact Manager
      2. The Flavors of Microsoft Office 2003
      3. What Is XML?
      4. Introduction to XML
      5. XML and Its Impact
      6. Office and XML
  15. X. Bonus Hours
    1. 25. Using FrontPage 2003 for Web Page Design and Creation
      1. Introduction to FrontPage 2003
        1. To Do: Work in FrontPage
        2. Preparing for Web-Page Publishing
      2. Working with FrontPage 2003
      3. To Do: Create Your First Web Page
      4. Adding a Title to Your Web Page
      5. Web Pages Can Hold Many Kinds of Elements
      6. To Do: Finish Your First Simple Web Page
      7. Different Views
      8. Adding a Background
      9. Summary
      10. Q&A
    2. 26. Managing Your Web with FrontPage
      1. Hyperlinking to Other Web Pages
        1. To Do: Add a Link to a Web Page
      2. To Do: Use a FrontPage Wizard to Create a Web Page
      3. Publishing Your Web Page
      4. Introduction to XML
      5. XML and Its Impact
      6. Office and XML
      7. Summary
      8. Q&A