Microsoft Office 2010: Home

Microsoft Office 2010 is a productivity suite comprised of the following included in this training guide:

• MS Word: Word processing
• MS Excel: Calculations speadsheet application
• MS PowerPoint: Presentation software
• MS Access: Relational database management tool
• MS Publisher: Desktop publishing

TRY A FREE DOWNLOAD OF MS OFFICE 2010 - DOWNLOAD FROM THE MICROSOFT WEB SITE (60-day trial)

Table of Contents

         Microsoft Word

• Working With Documents
  • Navigate the MS Word 2010 Ribbon
    
  • Open and Save Documents
    
  • Edit Documents
  • Format Documents
    
• Formatting Text
  • Edit and Proofread
    
  • Format Text
    
  • Apply a Style
• Working in Paragraphs
  • Align Paragraphs
    
  • Format Paragraphs
  • Copy Paragraph Format
• Arranging & Printing Documents
  • Create a Template-Based Document
    
  • Add Effects and Style
    
  • Print Layout and Preview
    
  • Page Breaks, Numbers, Headers, & Footers
    
• Working With Tables
  • Create a Table
    
  • Insert Text
  • Sort Table Data
    
• Document Review & Collaboration
  • Track Changes
  • Accept or Reject Changes
  • Add Comments
  • Merge Changes from Multiple Authors
  
  

Microsoft Excel

• Working With Data
  • Enter and Edit Cell Data
    
  • Sort and Filter Data
  • Format Data
    
  • Format Numbers
• Working With Cells
  • Edit Column Width and Height
    
  • Change Cell Design
    
  • Insert and Delete Rows and Columns
  • Merge and Center
    
• Functions & Formulas
  • About Functions
    
  • About Formulas
    
  • The Quick & Easy AutoSum
    
• Charts
  • Create & Format Charts
    
  • Change Chart Type
  • Format Data Labels
  • Update Chart Data
    
• Managing Worksheets & Workbooks
  • Rename Worksheets
    
  • Change Worksheet Design
    
  • Add Worksheets to Workbook

• Print Set-Up
  • Change Print Orientation & Preview
  • Add Header/Footer
  • Print with Gridlines
    

• Smart Art
  • Create Diagrams & Relationships
    

         Microsoft PowerPoint

• Working in PowerPoint
  • Navigate the PowerPoint 2010 Ribbon
    
• Creating Presentations
  • Open a Presentation
    
  • Work with Templates
    
  • Edit a Presentation
  • Change Slide Layout
    
• Working With Images
  • Insert Photos from Files
    
  • Insert Clip Art
    
  • Animate Clip Art or Photos
    
• Illustrations & Charts
  • Create a Chart
  • Insert an Excel Chart
    
• Preparing Presentations for Slideshow & Print
  • Add a Transition
    
  • Insert a Media Clip or YouTube Video
    
  • Finalize Presentations
  • Print Presentations
    

         Microsoft Access

• Working With Access
  • Get Started
    
  • "Must-Know" Definitions
    
• Building Tables
  • Create a Blank Database
    
• Designing Tables
  • Design & Layout View
    
  • Build Fields in a Table
    
• Working With Tables
  • Create a New Table
    
  • Create Relationships
    
• Generating Reports
  • Design a Report
    
  • Print a Report
    

         Microsoft Publisher

• Working With Publisher
  • About the Desktop Publishing Software
    
  • Publisher Objects
    
• Pre-Designed Templates
  • Browse Styles
    
  • Edit Design & Color Schemes
    
  • Edit & Pop Text
    
• Working With Objects
  • Add Text Boxes & Text
    
  • Insert Images
  • Format Images Inside Text Boxes