Using the Office 2007 Environment  

General Environment :

• The Ribbon
• Tabs, Groups and Commands
• Dialog Box Launcher
• Quick Access Toolbar
• Microsoft Office Button
• Mini Toolbar
• Views & Zooming
• Keyboard Shortcuts

File Formats:

• File Formats
• PDF and XPS

Using the New Features of Word

New Formatting Features:

• Live Previews
• Quick Styles

New Content Features:

• Pre-formatted Content
• Quick Parts

New Proofing Features:

• Tri Pane Review Panel
• Word Count
• Contextual Spell Checking
• Read Mode
  
  

Using the New Features of Excel

New General Features:

• Increased Capacity
• More Templates
• File Types

New Formatting Features:

• Galleries
• Conditional Formatting
• Filtering and Sorting

New Formula Features:

• Resizable Formula Bar
• AutoComplete
• Name Manager

Using the New Features of PowerPoint

New General Features:

• Viewing Presentations
• Ribbon Tabs
• Contextual Tabs

New Formatting Features:

• Live Previews
• Custom Slide Layouts
• Graphics Effects
• Slide Libraries

New Content Features:

• SmartArt Graphics
• Convert bullet to SmartArt Graphic
  
  

Using the New Features of Outlook

 
New General Features:

• The Ribbon
• Navigation Pane
• To-do Bar
• Colour Categorise
• Instant Search

New Email Features:

• Creating Messages
• Signatures
• Calendar Snapshots
• Out of Office
• Flags

 
New Calendar Features:

• Enhanced Views
• Tasks Area
• Overlay Calendars

New Contact Features:

• Electronic Business Cards

Calculating Data with Advanced Formulas:

• Manage Cell and Range Names
• Calculate Data Across Worksheets
• Use Specialized Functions
• Analyze Data with Logical and Lookup Functions
  

Organizing Worksheet and Table Data:

• Create and Modify Tables
• Format Tables
• Sort or Filter Worksheet or Table Data
• Calculate Data in a Table or Worksheet
  
  

Presenting Data Using Charts:

• Create a Chart
• Modify Charts
• Format Charts
  
  

Analyzing Data Using PivotTables and PivotCharts:

• Create a PivotTable Report
• Analyze Data Using PivotCharts

Inserting Graphic Objects:

• Insert and Modify Pictures and ClipArt
• Draw and Modify Shapes
• Illustrate Workflow Using SmartArt Graphics
• Layer and Group Graphic Objects

Customizing and Enhancing Workbooks and the Excel Environment:

• Customize the Excel Environment
• Customize Workbooks
• Manage Themes
• Create and Use Templates

Streamlining Workflow:

• Create a Macro
• Edit a Macro
• Apply Conditional Formatting
• Add Data Validation Criteria
• Update a Workbook's Properties
• Modify Excel's Default Settings

Collaborating with Others:

• Protect Files
• Share a Workbook
• Set Revision Tracking
• Review Tracked Revisions
• Merge Workbooks
• Administer Digital Signatures
• Restrict Document Access

Auditing Worksheets:

• Trace Cells
• Troubleshoot Errors in Formulas
• Troubleshoot Invalid Data and Formulas
• Watch and Evaluate Formulas
• Create a Data List Outline
  
  

Analyzing Data:

• Create a Trendline
• Create Scenarios
• Perform What-If Analysis
• Perform Statistical Analysis with the Analysis ToolPak

Working with Multiple Workbooks:

• Create a Workspace
• Consolidate Data
• Link Cells in Different Workbooks
• Edit Links

Importing and Exporting Data:

• Export Excel Data
• Import a Delimited Text File

Exploring the Access Environment:

• Examine Database Concepts
• Explore the User Interface
• Explore the Ribbon
• Customize the Access Environment
• Obtain Help
• Use an Existing Access Database

Designing a Database:

• Describe the Relational Database Design Process
• Define Database Purpose
• Review Existing Data
• Determine Fields
• Group Fields into Tables
• Designate Primary and Foreign Keys
• Determine Table Relationships
  
  

Building a Database:

• Create a New Database
• Create a Table
• Manage Tables
• Create a Table Relationship

Managing Data in a Table:

• Modify Table Data
• Sort Records
• Work with Subdatasheets

Querying a Database:

• Filter Records
• Create a Query
• Add Criteria to a Query
• Add a Calculated Field to a Query
• Perform Calculations on a Record Grouping
  
  

Designing Forms:

• View Data Using an Access Form
• Create a Form
• Create a Form Using the Form Wizard
• Modify the Design of a Form

Generating Reports:

• View an Access Report
• Create a Report
• Create a Report Using the Report Wizard
• Add a Custom Calculated Field to a Report
• Format the Controls in a Report
• Apply an AutoFormat to a Report
• Prepare a Report for Print

Getting Started with Microsoft Project

• Explore the Microsoft Project 2007 Environment
• Display an Existing Project Plan in Different Views

Creating a Project Plan

• Create a New Project Plan
• Assign a Project Calendar
• Add Tasks to the Project Plan
• Enter the Task Duration Estimates
• Add Resources in the Project Plan
  
  

Managing Tasks in a Project Plan

• Outline Tasks
• Add a Recurring Task
• Link Dependant Tasks
• Set a Constraint to a Task
• Set a Task Deadline
• Add Notes to a Task
  
  

Managing Resources in a Project Plan

• Create a Resource Calendar
• Assign Resources to Tasks
• Assign Additional Resources to a Task
• Enter Costs for Resources
• Enter Values for Budget Resources
• Resolve Resource Conflicts

Finalizing the Project Plan

• Display the Critical Path
• Shorten the Project Duration
• Set a Baseline
• Print a Project Summary Report