You are previewing Microsoft® Office 2010 Plain & Simple.
O'Reilly logo
Microsoft® Office 2010 Plain & Simple

Book Description

Get the fast facts that make learning Office 2010 plain and simple! This colorful, no-nonsense guide uses easy-to-follow steps and screenshots, and clear, concise language to show the simplest ways to get things done with Microsoft Word, Excel, Outlook, PowerPoint, Access, Publisher, and OneNote.

Here's WHAT You'll Learn

  • Create documents, Web pages, and other publications

  • Organize your e-mail, calendar, contacts and tasks

  • Build spreadsheets to analyze and visualize data

  • Set up a simple database

  • Capture notes with ink, voice or text



  • Here's HOW You'll Learn It

  • Jump in wherever you need answers

  • Easy-to-follow STEPS and SCREENSHOTS show exactly what to do

  • Handy TIPS teach new techniques and shortcuts

  • Quick TRY THIS! Exercises help you apply what you learn right away

  • Table of Contents

    1. Microsoft® Office 2010 Plain & Simple
    2. Acknowledgments
    3. 1. About This Book
      1. No Computerspeak!
        1. Useful Tasks …
        2. … And the Easiest Way to Do Them
      2. A Quick Overview
      3. What's New in Office 2010?
      4. A Few Assumptions
      5. A Final Word (or Two)
    4. 2. Working in Office 2010
      1. What's What in Office 2010?
        1. Microsoft Office 2010 Programs
      2. Using the Ribbon
        1. Explore the Ribbon
        2. Set the Ribbon Display
      3. Using Galleries and Lists
        1. Explore the Galleries
        2. Display Lists and Choose Commands
        3. Use the Tools
      4. Using Shortcut Menus and Dialog Boxes
        1. Use the Shortcut Menus
        2. Working with Dialog Boxes
      5. Using Only the Keyboard
        1. Browse the Ribbon with Your Keyboard
        2. Use Keyboard Shortcuts
      6. Moving and Copying Content
        1. Cut or Copy Information
        2. Paste Information Using Paste with Live Preview
        3. Copy and Paste Multiple Items
      7. Working with Backstage View
        1. Finding File and Program Information
        2. Printing a File
      8. Getting Help
        1. Browse for Help
        2. Search for Help
      9. Saving Your Work
        1. Save the File
      10. Office's File Formats
        1. Other File Formats for Office Programs
    5. 3. Common Tasks in Office
      1. Working with Old Documents
        1. Convert the Document
      2. Inserting Pictures
        1. Insert a Picture
        2. Display a Specific File Type
      3. Changing the Size of a Picture
        1. Crop It
        2. Size It
      4. Editing a Picture
        1. Apply Artistic Effects
        2. Change Contrast and Color
        3. Rotate It
      5. Enhancing Your Pictures
        1. Add Picture Styles and Effects
      6. Making Your Pictures Pop
        1. Remove the Picture Background
      7. Adding Clip Art
        1. Find and Insert Clip Art
      8. Inserting Screenshots
        1. Add a Screenshot
      9. Adding Shapes
        1. Draw a Shape
      10. Formatting a Shape
        1. Format the Shape
      11. Inserting the Date and Time
        1. Insert the Date and/or Time
      12. Creating Stylized Text
        1. Create a WordArt Object
        2. Fine-Tune the Result
      13. Inserting a SmartArt Diagram
        1. Create a Diagram
        2. Modify the Diagram
      14. Translating Your Text
        1. Choose a Translation Language
        2. Use the Mini Translator
      15. Researching a Subject
        1. Do Some Research
    6. 4. Viewing and Editing Text in Word
      1. What's Where in Word 2010?
      2. Creating a New Document
        1. Start Word and Enter Some Text
      3. Composing Different Types of Documents
        1. Start the Document
      4. Word's Views
        1. Print Layout View
        2. Full Screen Reading View
        3. Web Layout View
        4. Outline View
        5. Draft View
        6. Print Preview
      5. Reading a Document
        1. Read
      6. Editing Text
        1. Select and Modify Text
      7. Discovering the Many Ways to Work with Text
      8. Navigating Your Document
        1. Using the Navigation Pane
        2. Search and Find Objects
      9. Replacing Text
        1. Replace Text
      10. Correcting Your Spelling and Grammar
        1. Correct a Spelling Error
        2. Correct a Contextual Spelling Error
        3. Correct the Grammar
        4. Automatically Correct Your Misspellings
      11. Correcting Text Automatically
        1. Add Entries
      12. Adding Page Numbers
        1. Insert Page Numbers
      13. Co-Authoring in Word 2010
        1. Co-Authoring a Document
        2. Connecting with a Co-Author
      14. Marking and Reviewing Changes in a Document
        1. Review a Document
        2. Review Changes
      15. Comparing Documents Side by Side
        1. View the Documents
    7. 5. Formatting in Word
      1. Controlling the Look: Themes, Styles, and Fonts
      2. Choosing a Theme for Your Document
        1. Choose a Theme
      3. Formatting Text with Styles
        1. Apply a Quick Paragraph Style
        2. Apply Character Formatting Styles
      4. Choosing Styles from the Styles Window
        1. View Your Styles
      5. Changing Character Fonts
        1. Change the Font
        2. Change the Font Size
        3. Applying Stylistic Sets
      6. Setting Paragraph Alignment
        1. Set the Alignment
      7. Adjusting Paragraph Line Spacing
        1. Set the Line Spacing Within a Paragraph
      8. Setting Spacing Between Paragraphs
        1. Set the Line Spacing Between Paragraphs
      9. Indenting a Paragraph
        1. Indent the Paragraph
      10. Formatting with Tabs
        1. Set Your Tabs
      11. Adding Emphasis and Special Formatting
        1. Format the Text
      12. Copying Your Formatting
        1. Copy the Formatting
      13. Creating a Bulleted or Numbered List
        1. Create the List
      14. Formatting a List
        1. Change the Format
      15. Creating a Table from Scratch
        1. Create the Table
      16. Using a Predesigned Table
        1. Choose a Table
      17. Creating a Table from Text
        1. Convert the Text
      18. Adding or Deleting Rows and Columns
        1. Add a Row or Column to the Table
        2. Delete a Row or Column from the Table
      19. Formatting a Table
        1. Format the Table
      20. Improving the Layout with Hyphenation
        1. Set Automatic Hyphenation
      21. Laying Out the Page
        1. Set Up a Standard Page
      22. Creating Special Page Setups
        1. Set Up a Two-Sided Document
        2. Set Up a Bound Document
      23. Creating Headers and Footers
        1. Create a Header and a Footer
      24. Changing Page Orientation Within a Document
        1. Create a New Section
        2. Change the Page Orientation
      25. Flowing Text into Columns
        1. Change the Number of Columns
      26. Creating Sections
        1. Start a New Section
        2. Change the Header and Footer
      27. Wrapping Text Around a Graphic
        1. Control Text Wrapping
      28. Sorting Your Information
        1. Sort a Table
        2. Sort a List
      29. Reorganizing a Document
        1. View a Document's Outline
    8. 6. Working with Special Content in Word
      1. Numbering Headings and Lines
        1. Number the Headings
        2. Number the Lines
      2. Inserting a Cover Page
        1. Insert the Cover Page
      3. Inserting Information with Additional Actions
        1. Contact a Colleague
      4. Inserting an Equation
        1. Insert the Equation
      5. Adding a Sidebar or a Pull Quote
        1. Insert a Predesigned Text Box
      6. Inserting a Watermark
        1. Create the Watermark
      7. Creating Footnotes and Endnotes
        1. Insert the Footnote or Endnote
        2. Change the Reference Mark
      8. Inserting a Citation
        1. Add Existing Citations
        2. Insert a Citation
      9. Creating a Table of Contents
        1. Set the Outline Text
      10. Printing an Envelope
        1. Add the Address
      11. Printing a Mailing Label
        1. Print the Label
      12. Mail Merge: The Power and the Pain
        1. It's More than Letters
        2. Setting Conditional Content
      13. Creating a Form Letter
        1. Set Up Your Letter
        2. Specify the Data to Be Merged
      14. Finalizing Your Document
        1. Prepare Your Document
    9. 7. Working in Excel
      1. What's Where in Excel?
      2. Excel 2010 Basics
      3. Using a Predefined Workbook
        1. Open and Use a Template
      4. Choosing a Theme for Your Worksheet
        1. Apply a Theme
      5. Entering the Data
        1. Enter Your Data
      6. Editing the Data
        1. Replace the Data
        2. Edit the Existing Data
      7. Formatting Cells
        1. Format Some Cells
        2. Selecting Cells in the Worksheet
      8. Formatting Numbers
        1. Format Some Numbers
      9. Moving, Copying, and Pasting Data
        1. Move Data
        2. Copy or Cut Data
        3. Copy and Paste Data to Adjacent Cells
      10. Adding and Deleting Columns and Rows
        1. Add a Column
        2. Add a Row
        3. Delete a Column or a Row
        4. Delete Some or All Content of Cells
      11. Hiding Columns and Rows
        1. Hide Columns or Rows
        2. Reveal Hidden Columns or Rows
      12. Creating a Data Series
        1. Create a Series
      13. Formatting Cell Dimensions
        1. Set the Column Width
        2. Set the Row Height
        3. Adjust the Height or Width to Fit the Content
      14. Organizing Your Worksheets
        1. Name Your Worksheets
        2. Change Their Order
        3. Insert a Worksheet
        4. Delete a Worksheet
      15. Preparing for Printing
        1. Set Page Dimensions
        2. Set the Header and Footer
      16. Printing a Worksheet
        1. Specify the Print Area
        2. Repeat Row and Column Titles
        3. Check the Layout and Print the Worksheet
      17. Adding and Viewing Comments
        1. Create a Comment
        2. Review the Comments
      18. Working with the Excel Web App
        1. Use the Excel Web App
    10. 8. Analyzing and Presenting Data in Excel
      1. Applying Conditional Formatting to Cells
        1. Highlight Specific Cells
        2. Add Data Bars
        3. Apply Icon Sets
      2. Customizing Conditional Formatting
        1. Create a Rule
      3. Cell References, Formulas, and Functions
        1. A Little More About Cell References
      4. Adding Sparklines
        1. Create Sparklines
        2. Edit Sparklines
      5. Introducing Formulas
        1. Understanding Functions
      6. Doing the Math
        1. Calculate a Value
        2. Calculate the Value of Cells
      7. Summing the Data
        1. Sum the Numbers
      8. Making Calculations with Functions
        1. Find a Function
        2. Add Arguments
      9. Creating a Series of Calculations
        1. Create the Series
      10. Troubleshooting Formulas
        1. Check for Formula Errors
      11. Creating a Table
        1. Create a Table
        2. Use the Table
      12. Sorting the Data
        1. Conduct an Alphabetic or a Numeric Sort
      13. Filtering the Data
        1. Filter the Data
      14. Separating Data into Columns
        1. Separate the Data
      15. Creating Subtotals
        1. Create the Subtotals
      16. Summarizing the Data with a PivotTable
        1. Create the PivotTable
        2. Use the PivotTable
      17. Adding Slicers
        1. Create a Slicer
      18. Reviewing the Data
        1. Freeze the Columns and/or Rows
        2. View Multiple Sections
      19. The Anatomy of a Chart
      20. Charting Your Data
        1. Create a Chart
        2. Complete the Layout
      21. Formatting a Chart
        1. Change the Chart Style
        2. Change the Theme
        3. Format an Element
      22. Customizing a Chart
        1. Change a Data-Series Chart
    11. 9. Creating a PowerPoint Presentation
      1. What's Where in PowerPoint?
        1. Ways to View Your Presentation
      2. Creating a Presentation
        1. Choose a Template
        2. Set Up the Presentation
      3. Set the Page Background
        1. Format the Background
      4. Entering Content
        1. Add Your Content
      5. Formatting a Slide
        1. Format the Content
      6. Editing a Presentation
        1. Change the Content of the Slides
        2. Change the Order of the Slides
      7. Adding Headers and Footers
        1. Add the Footer
      8. Reusing Slides
        1. Reuse a Slide
      9. Modifying the Default Layout
        1. Modify the Layout
        2. Create a New Layout
      10. Inserting a Table
        1. Create the Table
      11. Turning Text into SmartArt
        1. Create the Graphic
      12. Applying WordArt Styles to Text
        1. Convert the Text
      13. Animating Items on a Slide
        1. Animate a Slide Element
        2. Use the Animation Painter
        3. Set the Animation Trigger
      14. Customizing Your Animation
        1. Customize the Animation
      15. Adding an Action to a Slide
        1. Assign an Action
      16. Adding and Editing Video
        1. Insert a Video from a File
        2. Edit Video Clips in PowerPoint
        3. Apply Video Styles
      17. Adding Sound to Your Slides
        1. Insert a Sound
      18. Setting Slide Transitions
        1. Set the Transitions
      19. Creating a Photo Album
        1. Create the Album
    12. 10. Presenting a PowerPoint Slide Show
      1. Exploring Your Presentation Options
        1. Preparing for the Perils of Presentation
      2. Recording a Narration
        1. Narrate Your Presentation
      3. Timing a Presentation
        1. Time the Presentation
      4. Adding Speaker Notes
        1. Create the Notes
        2. Set Up and Print the Notes
      5. Customizing the Presentation
        1. Set Up the Show
      6. Reviewing a Presentation
        1. Review the Presentation
      7. Creating Different Versions of a Slide Show
        1. Create a Custom Slide Show
      8. Printing Handouts
        1. Create the Handouts
      9. Running a Slide Show
        1. Run the Presentation
        2. Using Ink While You Present
      10. Sharing a Presentation
        1. Save the Show to SharePoint
      11. Publishing Your Slides
        1. Add Slides to a Slide Library
      12. Packaging Your Presentation
        1. Package Your Presentation
      13. Creating Pictures of Your Slides
        1. Create the Pictures
      14. Saving Your Presentation as a Video
        1. Create a Video
      15. Broadcasting Your Presentation
        1. Broadcast a Presentation
      16. Changing Slide-Show Settings
        1. Change the Settings
    13. 11. Working with Messages in Outlook
      1. What's Where in Outlook Messages?
        1. A Look at the New Message Window
        2. Overview of the Message Window Insert Tab
      2. Sending E-mail
        1. Address an E-mail Message
        2. Type Your Message Subject and Text
      3. Receiving and Reading E-mail
        1. Locate New Messages
        2. Open Messages
      4. Replying to and Forwarding a Message
        1. Reply to an E-mail Message
        2. Forward an E-mail Message
      5. Staying in Touch with Outlook Social Connector
        1. Adding a Site to Outlook Social Connector
        2. Viewing Social Contacts
      6. Sending or Receiving a File
        1. Attach a File
        2. Open an Attachment
      7. Formatting E-mail Messages
        1. Use a Rich Text or HTML Message Format
        2. Add Formatting to a Message
      8. Managing Messages with Quick Steps
        1. Use a Quick Step to Reply to and Delete a Message
        2. Create a New Quick Step
        3. Move Messages Between Folders
      9. Signing Your E-mail
        1. Create a Signature
      10. Reading RSS Items
        1. Add an RSS Feed
        2. Read RSS Feeds
      11. Setting Up E-mail Accounts
        1. Add an E-mail Account
    14. 12. Organizing with Outlook
      1. A Quick Look at Outlook's Organizing Abilities
        1. Calendar
        2. Contacts
      2. Setting an Appointment
        1. Add an Appointment to the Calendar
        2. Add Appointment Detail
      3. Keeping Track of Your Schedule
        1. Use the Calendar View
        2. Use Schedule View
        3. Use the To-Do Bar
      4. Sharing Calendars
        1. Share Your Calendar
        2. Share Your Available Times
      5. Viewing Your Group's Schedule
        1. Create a New Group
        2. View and Manage a Group Schedule
      6. Scheduling a Meeting
        1. Create a Meeting in a Block of Time
        2. Specify a Meeting Date and Time Manually
      7. Managing Your Contacts
        1. Use E-mail Message Information
        2. Use the Contact Window
      8. Keeping Track of Your Tasks
        1. Create a Task Quickly
        2. Set the Task Name and Due Date
        3. Open the Task Item Window
      9. Assigning Tasks
        1. Assign a Task
      10. Tacking Up Notes
        1. Add a Note
      11. Creating and E-mailing Contact Business Cards
        1. Create a Contact Business Card
        2. E-mail a Contact Business Card
    15. 13. Creating a Publication in Publisher
      1. Exploring the New Look of Publisher 2010
        1. Understanding Publisher Objects
      2. Starting with a Template
        1. Use a Template
      3. Creating a Publication from Scratch
        1. Start the Publication
        2. Set Up the Look of the Publication
      4. Adding Text
        1. Add Text
      5. Flowing Text Among Text Boxes
        1. Flow the Text
      6. Tweaking Your Text
        1. Improve the Look of the Text
        2. Add Text Effects
        3. Choose a Ligature Style and a Stylistic Set
      7. Inserting and Modifying a Picture
        1. Insert a Picture
        2. Modify the Picture
      8. Adding a Table
        1. Insert the Table
      9. Repeating Objects on Every Page
        1. Add the Repeating Objects
      10. Adding Building Blocks
        1. Insert a Building Block
      11. Arranging Objects on the Page
        1. Set Up Your Guides
        2. Position an Object at an Exact Location
      12. Stacking and Grouping Objects
        1. Arrange and Group the Objects
      13. Flowing Text Around an Object
        1. Set the Text Wrapping
      14. Reusing Content
        1. Create Your Own Page Part
      15. Inserting Your Contact Information
        1. Add Your Business Information
      16. Checking Your Publication
        1. Check the Design
      17. Sending a Publication as E-mail
        1. E-mail Your Publication
      18. Printing Your Publication
        1. The Final Step: Print It!
    16. 14. Organize and Share Information in OneNote 2010
      1. What's Where in OneNote?
        1. Exploring the OneNote Window
      2. OneNote Basics: Gathering Your Thoughts
      3. Creating a OneNote Notebook
        1. Create a New Notebook
      4. Adding and Working with Sections
        1. Start a New Section
        2. Create a Section Group
      5. Inserting and Working with Notes Pages
        1. Create a Page Based on a Template
        2. Set a Default Template
        3. Create a Blank Page
      6. Inking in OneNote
        1. Using Ink and Draw Tool
        2. Adding a Shape
      7. Adding Audio Notes
        1. Record Audio
        2. Playing Your Audio Note
      8. Grabbing Web Clippings
        1. Clip Web Content
      9. Sharing Notes in Word and PowerPoint
        1. Use Linked Notes in Word
        2. Work with Linked Notes in PowerPoint
      10. Saving Outlook Data to OneNote
        1. Share a Message with OneNote
      11. Working with Side Notes and Unfiled Notes
        1. Create a Side Note
        2. View and Merge Unfiled Notes
    17. 15. Working in Access
      1. What's Where in Access?
        1. Exploring the Access Window
        2. Taking a Look at Datasheet View
        3. Reviewing Report View
      2. Databases: A Simple Approach
        1. Ways to Store Data
        2. Basic Database Concepts
        3. Access 2010 and Relational Tables
      3. Creating a Database from a Template
        1. Create a Database from a Template
        2. Working with a Template
      4. Using an Existing Database
        1. Open a Recently Used Database File
        2. Open an Existing Database File
      5. Adding a Data Table
        1. Create a New Table
      6. Adding and Changing Fields and Records
        1. Rename Fields
        2. Set the Data Type and Format
        3. Add and Remove Fields and Records
      7. Adding Data to a Table
        1. Select Data
        2. Delete Data
        3. Undoing Operations
        4. Copy and Paste Data
      8. Importing Data
        1. Copy a Table from Another Database
      9. Exporting Data
        1. Export Table Data
      10. Defining Table Relationships
        1. Define a Relationship
      11. Creating a Form
        1. Create a Simple Form
        2. Create a Navigation Form
      12. Creating a Report from the Data
        1. Step Through the Report Wizard
      13. Formatting Reports
        1. Format a Report Using Themes
        2. Add Conditional Formatting to a Report
      14. Querying Information from Your Data Tables
        1. Create a Detailed Query
      15. Analyzing Data with a PivotChart
        1. Step Through the PivotChart Wizard
        2. Change a PivotChart Chart Type
    18. 16. Customizing and Securing Office
      1. Customizing the Ribbon
        1. Create and Rename a New Tab
        2. Rename and Add Tools to the Group
      2. Customizing the Quick Access Toolbar
        1. Add or Remove Items Common to the Quick Access Toolbar
        2. Control the Customization
      3. Customizing the Work Area
        1. Show or Hide Items on the Status Bar
        2. Change the Window's Color Scheme
        3. Change What's Shown
      4. Customizing Your Editing
        1. Adjust Program Options
      5. Changing Your User Information
        1. Change Your Name and Address
      6. Customizing the Spelling and Grammar Checkers
        1. Specify What's to Be Checked
      7. Customizing Your Spelling Dictionaries
        1. Add a Dictionary
      8. Changing the Location and Type of Saved Files
        1. Change the File Locations and Formats
      9. Understanding Security in Office 2010
        1. Working with the Trust Center
      10. Changing File Validation
        1. Set File Types
      11. Choosing What's Displayed in Protected View
        1. Set Protected View Settings
      12. Password Protecting a File
        1. Add a Password
      13. Limiting File Changes
        1. Set File Permissions
      14. Recovering Unsaved Versions of a File
        1. Recover Unsaved Files
      15. Setting AutoRecover Options
        1. Choose AutoRecover Options
      16. Signing a Document or Workbook with a Digital Signature
        1. Set Up the Signature
        2. Sign the Document
      17. Setting Macros, Add-Ins, and ActiveX Controls
        1. Modify the Settings
      18. Checking File Compatibility
        1. Run the Check
    19. Index
    20. About the Author
    21. Copyright