You are previewing Microsoft® Office Professional 2010 Step by Step.
O'Reilly logo
Microsoft® Office Professional 2010 Step by Step

Book Description

Teach yourself exactly what you need to know about using Office Professional 2010-one step at a time! With STEP BY STEP, you build and practice new skills hands-on, at your own pace. Covering Microsoft Word, PowerPoint, Outlook, Excel, Access, Publisher, and OneNote, this book will help you learn the core features and capabilities needed to:

  • Create attractive documents, publications, and spreadsheets

  • Manage your e-mail, calendar, meetings, and communications

  • Put your business data to work

  • Develop and deliver great presentations

  • Organize your ideas and notes in one place

  • Connect, share, and accomplish more when working together"

  • Table of Contents

    1. Microsoft® Office Professional 2010 Step by Step
    2. A Note Regarding Supplemental Files
    3. Introducing Microsoft Office Professional 2010
      1. Certification
      2. For More Information
        1. Microsoft Word 2010 Step by Step
        2. Microsoft Excel 2010 Step by Step
        3. Microsoft PowerPoint 2010 Step by Step
        4. Microsoft Outlook 2010 Step by Step
        5. Microsoft Access 2010 Step by Step
      3. Let’s Get Started!
    4. Modifying the Display of the Ribbon
      1. Dynamic Ribbon Elements
      2. Changing the Width of the Ribbon
      3. Adapting Exercise Steps
    5. Features and Conventions of This Book
    6. Using the Practice Files
    7. Getting Help
      1. Getting Help with This Book
      2. Getting Help with Office 2010
      3. More Information
    8. 1. Microsoft Office Professional 2010
      1. 1. Explore Office 2010
        1. Working in the Program Environment
        2. Changing Program Settings
        3. Customizing the Ribbon
        4. Customizing the Quick Access Toolbar
        5. Key Points
      2. 2. Work with Files
        1. Creating and Saving Files
        2. Opening, Moving Around in, and Closing Files
        3. Viewing Files in Different Ways
        4. Key Points
    9. 2. Microsoft Word 2010
      1. 3. Edit and Proofread Text
        1. Making Text Changes
        2. Finding and Replacing Text
        3. Fine-Tuning Text
        4. Correcting Spelling and Grammatical Errors
        5. Inserting Saved Text
        6. Key Points
      2. 4. Change the Look of Text
        1. Quickly Formatting Text
        2. Changing a Document’s Theme
        3. Manually Changing the Look of Characters
        4. Manually Changing the Look of Paragraphs
        5. Creating and Modifying Lists
        6. Key Points
      3. 5. Organize Information in Columns and Tables
        1. Presenting Information in Columns
        2. Creating Tabbed Lists
        3. Presenting Information in Tables
        4. Formatting Tables
        5. Key Points
      4. 6. Add Simple Graphic Elements
        1. Inserting and Modifying Pictures
        2. Changing a Document’s Background
        3. Inserting Building Blocks
        4. Adding WordArt Text
        5. Key Points
      5. 7. Preview, Print, and Distribute Documents
        1. Previewing and Adjusting Page Layout
        2. Controlling What Appears on Each Page
        3. Printing Documents
        4. Preparing Documents for Electronic Distribution
        5. Key Points
    10. 3. Microsoft Excel 2010
      1. 8. Set Up a Workbook
        1. Creating Workbooks
        2. Modifying Workbooks
        3. Modifying Worksheets
        4. Customizing the Excel 2010 Program Window
          1. Zooming In on a Worksheet
          2. Arranging Multiple Workbook Windows
          3. Adding Buttons to the Quick Access Toolbar
          4. Customizing the Ribbon
          5. Maximizing Usable Space in the Program Window
        5. Key Points
      2. 9. Work with Data and Excel Tables
        1. Entering and Revising Data
        2. Moving Data Within a Workbook
        3. Finding and Replacing Data
        4. Correcting and Expanding Upon Worksheet Data
        5. Defining Excel Tables
        6. Key Points
      3. 10. Perform Calculations on Data
        1. Naming Groups of Data
        2. Creating Formulas to Calculate Values
        3. Summarizing Data That Meets Specific Conditions
        4. Finding and Correcting Errors in Calculations
        5. Key Points
      4. 11. Change Workbook Appearance
        1. Formatting Cells
        2. Defining Styles
        3. Applying Workbook Themes and Excel Table Styles
        4. Making Numbers Easier to Read
        5. Changing the Appearance of Data Based on Its Value
        6. Adding Images to Worksheets
        7. Key Points
      5. 12. Focus on Specific Data by Using Filters
        1. Limiting Data That Appears on Your Screen
        2. Manipulating Worksheet Data
          1. Selecting List Rows at Random
          2. Summarizing Worksheets with Hidden and Filtered Rows
          3. Finding Unique Values Within a Data Set
        3. Defining Valid Sets of Values for Ranges of Cells
        4. Key Points
    11. 4. Microsoft PowerPoint 2010
      1. 13. Work with Slides
        1. Adding and Deleting Slides
        2. Adding Slides with Ready-Made Content
        3. Dividing Presentations into Sections
        4. Rearranging Slides and Sections
        5. Key Points
      2. 14. Work with Slide Text
        1. Entering Text in Placeholders
        2. Adding Text Boxes
        3. Editing Text
        4. Correcting and Sizing Text While Typing
        5. Checking Spelling and Choosing the Best Words
        6. Finding and Replacing Text and Fonts
        7. Key Points
      3. 15. Format Slides
        1. Applying Themes
        2. Using Different Color and Font Schemes
        3. Changing the Slide Background
        4. Changing the Look of Placeholders
        5. Changing the Alignment, Spacing, Size, and Look of Text
        6. Key Points
      4. 16. Add Simple Visual Enhancements
        1. Inserting Pictures and Clip Art Images
        2. Inserting Diagrams
        3. Inserting Charts
        4. Drawing Shapes
        5. Adding Transitions
        6. Key Points
      5. 17. Review and Deliver Presentations
        1. Setting Up Presentations for Delivery
        2. Previewing and Printing Presentations
        3. Preparing Speaker Notes and Handouts
        4. Finalizing Presentations
        5. Delivering Presentations
        6. Key Points
    12. 5. Microsoft OneNote 2010
      1. 18. Explore OneNote 2010
        1. Navigating in the OneNote Program Window
        2. Working in the OneNote Program Window
          1. Working from the Ribbon and Quick Access Toolbar
          2. Working in the Backstage View
        3. Exploring OneNote in the Default Notebook
        4. Customizing OneNote
        5. Key Points
      2. 19. Create and Configure Notebooks
        1. Creating a Notebook for Use by One Person
        2. Creating a Notebook for Use by Multiple People
          1. Sharing a New or Existing Notebook
          2. Managing a Shared Notebook
        3. Creating Sections and Pages
          1. Creating Pages and Subpages
          2. Naming Sections and Pages
          3. Creating Sections and Section Groups
        4. Key Points
      3. 20. Create and Organize Notes
        1. Working with Note Containers
        2. Entering Content Directly onto a Page
          1. Referencing External Files
          2. Creating Handwritten Notes
          3. Inserting Images
          4. Formatting Notes, Pages, and Sections
            1. Paragraph Formatting
            2. Outline Levels
            3. Page and Section Backgrounds
        3. Sending Content to OneNote
          1. Collecting Screen Clippings
          2. Collecting Web Notes
        4. Capturing Audio and Video Notes
        5. Taking Notes on the Side
        6. Key Points
    13. 6. Microsoft Outlook 2010
      1. 21. Send and Receive E-Mail Messages
        1. Creating and Sending Messages
          1. Addressing Messages
          2. Troubleshooting Message Addressing
            1. Troubleshooting the AutoComplete Address List
            2. Troubleshooting Multiple Recipients
            3. Troubleshooting the Address Book
          3. Entering Content
          4. Saving and Sending Messages
        2. Attaching Files to Messages
        3. Viewing Messages and Message Attachments
        4. Configuring Reading Pane Behavior
          1. Viewing Reading Pane Content
          2. Marking Messages as Read
          3. Single Key Reading
        5. Viewing Message Participant Information
          1. Presence Icons
          2. Contact Cards
          3. The People Pane
        6. Responding to Messages
        7. Key Points
      2. 22. Store and Access Contact Information
        1. Saving and Updating Contact Information
          1. Creating Contact Records
          2. Address Books
            1. Contacts and Suggested Contacts Address Books
            2. Custom Address Books
            3. Global Address Lists
        2. Communicating with Contacts
          1. Initiating Communication from Contact Records
          2. Selecting Message Recipients from Address Books
        3. Displaying Different Views of Contact Records
        4. Printing Contact Records
        5. Key Points
      3. 23. Manage Scheduling
        1. Scheduling and Changing Appointments
        2. Scheduling and Changing Events
        3. Scheduling Meetings
        4. Responding to Meeting Requests
        5. Displaying Different Views of a Calendar
          1. Views
          2. Arrangements
          3. Using the Date Navigator
        6. Key Points
      4. 24. Track Tasks
        1. Creating Tasks
          1. Creating Tasks from Scratch
          2. Task Options
          3. Creating Tasks from Outlook Items
        2. Updating Tasks
        3. Removing Tasks and Items from Task Lists
        4. Managing Task Assignments
          1. Tasks You Assign to Others
          2. Tasks Other People Assign to You
        5. Displaying Different Views of Tasks
        6. Key Points
    14. 7. Microsoft Access 2010
      1. 25. Explore an Access 2010 Database
        1. Working in Access 2010
        2. Understanding Database Concepts
        3. Exploring Tables
        4. Exploring Forms
        5. Exploring Queries
        6. Exploring Reports
        7. Previewing and Printing Access Objects
        8. Key Points
      2. 26. Create Databases and Simple Tables
        1. Creating Databases from Templates
        2. Creating Databases and Tables Manually
        3. Manipulating Table Columns and Rows
        4. Refining Table Structure
        5. Creating Relationships Between Tables
        6. Key Points
      3. 27. Create Simple Forms
        1. Creating Forms by Using the Form Tool
        2. Changing the Look of Forms
        3. Changing the Arrangement of Forms
        4. Key Points
      4. 28. Display Data
        1. Sorting Information in Tables
        2. Filtering Information in Tables
        3. Filtering Information by Using Forms
        4. Locating Information That Matches Multiple Criteria
        5. Key Points
    15. 8. Microsoft Publisher 2010
      1. 29. Get Started with Publisher 2010
        1. Starting New Publications
          1. Using Templates
          2. Importing Word Documents
        2. Storing Personal and Company Information
        3. Previewing and Printing Publications
          1. Checking Publications
          2. Working with Advanced Printer Settings
        4. Key Points
      2. 30. Create Visual Interest
        1. Working with Text Boxes
          1. Manipulating Text Boxes
          2. Formatting Text for Visual Impact
        2. Working with WordArt
        3. Working with Graphics
        4. Working with Shapes
          1. Manipulating Shapes
          2. Connecting and Grouping Shapes
        5. Working with Ready-Made Visual Elements
        6. Key Points
      3. 31. Create Colorful Cards and Calendars
        1. Creating Folded Cards
          1. Choosing a Design or Layout
          2. Changing the Color Scheme
          3. Using Non–Color-Scheme Colors
          4. Choosing Text
        2. Creating Postcards
          1. Using Mail Merge
          2. Using Catalog Merge
        3. Creating Calendars
          1. Adding Captions, Credits, and Copyrights
          2. Changing Page Backgrounds
          3. Working with Master Pages
        4. Key Points
    16. Index
    17. About the Authors
    18. Copyright