Microsoft® Office 2010 Simplified® -- Table of Contents -- Part I: Office Features -- Chapter 1: Office Basics -- Start and Exit Office Applications -- Navigate the Program Windows -- Work with the Ribbon -- Customize the Quick Access Toolbar -- Find Help with Office -- Chapter 2: Working with Files -- Create a New File -- Save a File -- Open a File -- Print a File -- Select Data -- Cut, Copy, and Paste Data -- View Multiple Files -- Chapter 3: Office Graphic Tools -- Insert Clip Art -- Insert a Picture -- Resize and Move Objects -- Rotate and Flip Objects -- Crop a Picture -- Add a Picture Effect -- Make Image Corrections -- Make Color Adjustments -- Apply Artistic Effects -- Create a WordArt Object -- Add SmartArt -- Chapter 4: Working with Office Files Online -- Create a New Workspace -- Upload a File to Office Live Workspace -- Create a New File in Office Live Workspace -- Edit a File in Office Live Workspace -- Share a Workspace -- View Shared Workspaces -- Delete a File from Office Live Workspace -- Part II: Word -- Chapter 5: Adding Text -- Change Word's Views -- Type and Edit Text -- Insert Quick Parts -- Insert Symbols -- Create a Blog Post -- Chapter 6: Formatting Text -- Change the Font, Size, and Color -- Align Text -- Set Line Spacing -- Indent Text -- Set Tabs -- Set Margins -- Create Lists -- Copy Formatting -- Clear Formatting -- Format with Styles -- Apply a Template -- Chapter 7: Adding Extra Touches -- Assign a Theme -- Add Borders -- Create Columns -- Insert a Table -- Apply Table Styles -- Insert an Excel Spreadsheet -- Add Headers and Footers -- Insert Footnotes and Endnotes -- Insert Page Numbers and Page Breaks -- Mark Index Entries -- Generate an Index -- Generate a Table of Contents -- Create a Bibliography -- Chapter 8: Reviewing Documents -- Find and Replace Text -- Scan Document Content -- Check Spelling and Grammar.

Work with AutoCorrect -- Use Word's Thesaurus and Dictionary -- Translate Text -- Track and Review Document Changes -- Compare Documents -- Insert Comments -- Part III: Excel -- Chapter 9: Building Spreadsheets -- Enter Cell Data -- Select Cells -- Faster Data Entry with AutoFill -- Turn On Text Wrapping -- Center Data Across Columns -- Adjust Cell Alignment -- Change the Font and Size -- Change Number Formats -- Increase or Decrease Decimals -- Add Borders -- Format Data with Styles -- Apply Conditional Formatting -- Add Columns and Rows -- Resize Columns and Rows -- Freeze a Column or Row -- Name a Range -- Delete Data or Cells -- Chapter 10: Worksheet Basics -- Add a Worksheet -- Name a Worksheet -- Change Page Setup Options -- Move and Copy Worksheets -- Delete a Worksheet -- Find and Replace Data -- Sort Data -- Filter Data -- Track and Review Worksheet Changes -- Insert a Comment -- Chapter 11: Working with Formulas and Functions -- Understanding Formulas -- Create a Formula -- Apply Absolute and Relative Cell References -- Understanding Functions -- Apply a Function -- Total Cells with AutoSum -- Audit a Worksheet for Errors -- Add a Watch Window -- Chapter 12: Working with Charts -- Create a Chart -- Move and Resize Charts -- Change the Chart Type -- Change the Chart Style -- Change the Chart Layout -- Add Axis Titles -- Format Chart Objects -- Add Gridlines -- Change the Chart Data -- Use Sparklines to View Data Trends -- Part IV: PowerPoint -- Chapter 13: Creating a Presentation -- Create a Photo Album Presentation -- Create a Presentation with a Template -- Build a Blank Presentation -- Change PowerPoint Views -- Insert Slides -- Change the Slide Layout -- Create a Custom Layout -- Chapter 14: Populating Presentation Slides -- Add and Edit Slide Text -- Change the Font, Size, and Color -- Apply a Theme -- Set Line Spacing -- Align Text.

Add a Text Box to a Slide -- Add a Table to a Slide -- Add a Chart to a Slide -- Add a Picture to a Slide -- Add a Video Clip to a Slide -- Move a Slide Object -- Resize a Slide Object -- Chapter 15: Assembling and Presenting a Slide Show -- Reorganize Slides -- Reuse a Slide -- Define Slide Transitions -- Add Animation Effects -- Create a Custom Animation -- Record Narration -- Set Up a Slide Show -- Create Speaker Notes -- Rehearse a Slide Show -- Run a Slide Show -- Package Your Presentation on a CD -- Part V: Access -- Chapter 16: Database Basics -- Understanding Database Basics -- Create a Database Based on a Template -- Create a Blank Database -- Create a New Table -- Change Table Views -- Add a Field to a Table -- Delete a Field from a Table -- Hide a Field in a Table -- Move a Field in a Table -- Create a Form -- Change Form Views -- Move a Field in a Form -- Delete a Field in a Form -- Apply a Database Theme -- Chapter 17: Adding, Finding, and Querying Data -- Add a Record to a Table -- Add a Record to a Form -- Navigate Records in a Form -- Search for a Record in a Form -- Delete a Record from a Table -- Delete a Record from a Form -- Sort Records -- Filter Records -- Apply Conditional Formatting -- Perform a Simple Query -- Create a Report -- Part VI: Outlook -- Chapter 18: Organizing with Outlook -- View Outlook Components -- Schedule an Appointment -- Schedule a Recurring Appointment -- Schedule an Event -- Create a New Contact -- Create a New Task -- Add a Note -- Organize Outlook Items -- Perform an Instant Search -- Customize the To-Do Bar -- Chapter 19: E-mailing with Outlook -- Compose and Send a Message -- Send a File Attachment -- Read an Incoming Message -- Reply To or Forward a Message -- Add a Sender to Your Outlook Contacts -- Delete a Message -- View Conversations -- Clean Up a Conversation -- Ignore a Conversation.

Screen Junk E-mail -- Create a Message Rule -- Part VII: Publisher -- Chapter 20: Publisher Basics -- Create a Publication -- Create a Blank Publication -- Zoom In and Out -- Add Text -- Add a New Text Box -- Add a Picture to a Publication -- Chapter 21: Fine-Tuning a Publication -- Change the Font, Size, and Color -- Apply a Text Effect -- Change Text Alignment -- Add a Border -- Control Text Wrap -- Link Text Boxes -- Move and Resize Publication Objects -- Edit the Background -- Add a Building Block Object -- Create a Building Block Object -- Part VIII: OneNote -- Chapter 22: Taking Notes with OneNote -- Navigate OneNote -- Type and Draw Notes -- Paste a Picture into OneNote -- Attach Files to Notes -- Insert a Screen Clipping -- Record an Audio Note -- Chapter 23: Organizing and Sharing Notes -- Create a New Notebook -- Create a New Section -- Create a New Page -- Rename Sections and Pages -- Group Sections -- Search Notes -- E-mail a Note Page -- Convert Notes to PDF or XPS Format -- Index.