MS Office 2007

Course Overview

Microsoft Office 2007 offers a family of office suites and productivity software for Windows. This version has introduced new features and programs that you will learn about in this course including Sharepoint, InfoPath, Groove and much more.

Course Outline

Access 2007 Basic – 1 hr, 14 mins   

  •  The Access Environment
  •  Building a Database from Scratch
  •  Working with Tables
  •  Queries
  •  Forms
  •  Reports

Access 2007 Intermediate – 55 mins             

  •  Restricting Data Entry
  •  Joining Tables
  •  Writing Advanced Queries
  •  Charting
  •  Pivot Tables & Pivot Charts
  •  Importing & Exporting
  •  Macros

Access 2007 Advanced – 48 mins                  

  •  Maintaining an Access Database
  •  Distributing and Securing a Database
  •  Making Tasks Simple with Macros
  •  Adding User Interaction with Macros
  •  Automating Reports
  •  Automating with VBA
  •  Creating a Switchboard & Defining Startup Options

Business Contact Manager – 1 hr, 7 mins

  •  Overview
  •  Configuration
  •  Working with Business Contact Manager
  •  Additional Tasks
  •  Managing Projects and Marketing Campaigns

Excel 2007 Basic – 1 hr, 19 mins     

  •  Creating a Basic Worksheet
  •  Performing Calculations
  •  Modifying a Worksheet
  •  Formatting a Worksheet
  •  Printing Workbook Contents
  •  Managing Large Workbooks

Excel 2007 Intermediate – 1 hr, 15 mins               

  •  Calculating Data with Advanced Formulas
  •  Organizing Worksheet and Table Data
  •  Presenting Data Using Charts
  •  Analyzing Data Using PivotTables and PivotCharts
  •  Inserting Graphic Objects
  •  Customizing and Enhancing Workbooks and the Excel Environment

Excel 2007 Advanced – 1 hr, 9 mins                                  

  •  Streamlining Workflow
  •  Collaborating with Others
  •  Auditing Worksheets
  •  Analyzing Data
  •  Working with Multiple Workbooks
  •  Importing and Exporting Data

Groove 2007 – 1hr, 3 mins

  •  Overview
  •  Managing Groove
  •  Collaboration
  •  Advanced Techniques

Infopath 2007 Basic – 1 hr, 17 mins

  •  Working with InfoPath
  •  Examining InfoPath Forms
  •  Adding Controls to an InfoPath Form
  •  Importing and Exporting Form Data
  •  Customizing From Layout
  •  Managing Views

Infopath 2007 Intermediate – 1 hr, 18 mins                     

  •  Programming Forms
  •  Working with the Data Source Library
  •  Publishing Form Templates
  •  Working with a Database
  •  Applying Security to Forms

Infopath 2007 Advanced – 59 mins               

  •  SharePoint Integration
  •  InfoPath Browser Capable Forms
  •  Enabling Email Forms and Lists

OneNote 2007 – 1 hr, 5 mins

  •  Overview
  •  Working with OneNote
  •  Transforming Items
  •  Additional Tasks
  •  Printing and Setup

Outlook 2007 Basic – 58 mins

  •  Getting Started
  •  Working with Email
  •  Contact Management
  •  Calendaring
  •  Tasks

Outlook 2007 Intermediate – 1 hr, 35 mins                      

  •  Email Management
  •  Contact Management
  •  Calendaring
  •  Notes and Journaling

Outlook 2007 Advanced – 1 hr, 22 mins                

  •  Email Management
  •  Customizing Outlook
  •  Advanced Calendaring and Task Management
  •  Working with Public Folders

PowerPoint 2007 Basic – 1 hr, 17 mins

  •  The PowerPoint Environment
  •  How to Navigate Presentations
  •  Creating and Formatting Slides
  •  Adding Graphics and Drawing Objects to Your Presentations
  •  Modifying Objects
  •  Adding Tables and Charts
  •  Modifying Presentations
  •  Proofing and Delivering Presentations

PowerPoint 2007 Advanced – 31 mins                     

  •  Customizing Presentations
  •  Working with Graphics and Multimedia Content
  •  Working with Action Buttons and Customizing Your Slide Shows
  •  Finalizing the Presentation
  •  Integration with Other Microsoft Office programs

Project 2007 Basic – 1 hr, 3 mins

  •  Reviewing the Workspace
  •  Getting Started
  •  Adding Project Details
  •  Editing Text
  •  Editing Tasks
  •  Reviewing the Project
  •  Reporting

Project 2007 Intermediate – 1 hr, 12 mins           

  •  Managing Multiple Projects
  •  Formatting Page Layout
  •  Saving Files
  •  Using Templates
  •  Managing Data
  •  Managing Resources
  •  Setting Project Parameters
  •  Resource Conflicts & Leveling
  •  Reporting

Project 2007 Advanced – 1 hr, 14 mins                 

  •  Managing Resources
  •  Tracking Resources
  •  Managing Tasks
  •  Linking Tasks
  •  Editing Tasks
  •  Reporting
  •  Customizing the Workspace
  •  Closing a Project

Publisher 2007 – 1 hr, 16 mins

  •  Basic Publications
  •  Creating a Multi-Page Document
  •  Text Editing and Formatting
  •  Publication Formatting
  •  Working with Graphics
  •  Distributing Publications

SharePoint Designer 2007 Basic – 1 hr, 59 mins

  •  Introduction to SharePoint Designer
  •  Web Design Concepts
  •  Navigate in SharePoint Designer
  •  Create a Site using SharePoint Designer
  •  Create a Page on Your Site
  •  Insert Text to a Page
  •  Modify Text
  •  Text Formats
  •  Paragraph Formats

SharePoint Designer 2007 Intermediate – 1 hr, 10 mins            

  •  File Management
  •  Dynamic Web Templates
  •  Importing and Exporting a Site
  •  Working with Code View
  •  Applying Basic Tags
  •  Using the Tag Properties Window
  •  Adding and Modifying Images
  •  Format Images using the Pictures Toolbar
  •  Publish a Site

SharePoint Designer 2007 Advanced – 1 hr, 25 mins                  

  •  Text Styles
  •  Style Sheets
  •  Working with Tables
  •  Interactive Buttons
  •  Top Links Bar
  •  Quick Launch Bar
  •  Master Pages
  •  Web Components
  •  SharePoint Components

Visio 2007 – 1 hr, 11 mins

  •  Visio Introduction
  •  Working with Shapes
  •  Working with Text
  •  Working with Pages
  •  Enhancing Shapes
  •  Enhancing Drawings
  •  Working with Visio Files

Word 2007 Basic – 1 hr, 2 mins    

  •  Getting Started with Word 2007
  •  Creating a Word Document
  •  Formatting the Contents of a Document
  •  Page Layout
  •  Proofing and Printing your Word Documents
  •  Graphics
  •  Tables

Word 2007 Intermediate – 43 mins              

  •  Working with Styles
  •  Sections and Columns
  •  Formatting Tables
  •  Labels and Envelopes
  •  Templates and Building Blocks
  •  Graphics
  •  Document Revision Management
  •  Web Features of MS Word

Word 2007 Advanced – 49 mins                    

  •  Mail Merge
  •  Forms
  •  Sharing and Securing Your Documents
  •  Macros
  •  Toolbar and Keyboard Customization
  •  Working with Long Documents
  •  XML Features
  •  Using Word 2007 with Other Programs