MCSEClasses Certification Training Boot Camp

MCSE MCSD MCDBA Cisco CIW Linux Oracle Java Security

MOS 2007 Specialist Certification Training

MOS - Microsoft Office Specialist 2007 Certification Boot Camp

Course Length:	12 days
Certifications:	MOS
Number of Exams:	4

Class Schedule

Call for Class Schedule

Includes roundtrip airfare and lodging (for boot camps held in Georgia and Florida only)
Hands-on instruction by a certified instructor
Includes all course materials and practice exams
Includes all certification exams
Onsite Testing
Breakfast and Lunch provided each day

Microsoft Office Specialists (MOS) are a part of a global community of distinguished achievers. This Microsoft certification credential tells the world you have demonstrated proficiency in the newest standard of the world's foremost desktop computing applications. Microsoft certifications (based on globally recognized standards) demonstrate your computing skills and help advance your career prospects in a competitive job market.

Microsoft Office Specialist certifications are primarily for office workers who use Microsoft Office programs as a vital part of their job functions. This 12 day boot camp covers certification for Word 2007, PowerPoint 2007, Excel 2007, and Access 2007. The course begins with Word training, exam prep, and the certification exam. It is followed by Excel 2007, Access 2007, and PowerPoint 2007.

Microsoft Word 2007 - Intermediate
Microsoft Word 2007 - Advanced
Microsoft Excel 2007 - Introduction
Microsoft Excel 2007 - Intermediate
Microsoft Excel 2007 - Advanced
Microsoft Access 2007 - Introduction
Microsoft Access 2007 - Intermediate
Microsoft Access 2007 - Advanced
Microsoft PowerPoint 2007 - Introduction
Microsoft PowerPoint 2007 - Advanced

The MOS credential validates the skills that individuals and organizations depend on. Candidates who successfully complete the program by passing a certification exam prove they meet globally recognized performance standards and are able to work productively and efficiently.

In addition, organizations that use the MOS credential as a tool for quantitative skills measurement to facilitate identifying, hiring, promoting, and retaining qualified individuals can benefit from a streamlined recruitment process, greater individual productivity, and increased employee satisfaction.

Microsoft Word 2007 - Intermediate

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

manage lists.
customize tables and charts.
present a professional appearance to your documents by customizing formatting.
customize styles for document elements.
modify pictures in a document.
create customized graphic elements.
structure content using Quick Parts.
control text flow.
automate common tasks and automate document creation
perform mail merges.

Course Content

Lesson 1: Managing Lists

Sort, Renumber, Customize a List
Structure a List on Multiple Levels

Lesson 2: Customizing Tables and Charts

Modify Cell Structure
Position Text in a Cell
Apply Borders and Shading
Sort Table Data
Perform Calculations in a Table

Lesson 3: Customizing Character and Paragraph Formats

Control Character Appearance and Paragraph Flow

Lesson 4: Customizing Styles for Document Elements

Create a Text Style and Modify an Existing Style
Create a Custom List Style
Create a Table Style

Lesson 5: Modifying Pictures

Resize a Picture
Set Picture Prominence
Wrap Text Around a Picture

Lesson 6: Creating Customized Graphic Elements

Draw Shapes
Add Special Effects to Text
Display Text as Graphic Using Text Boxes

Lesson 7: Structuring Content Using Quick Parts

Create, Insert, Modify Building Blocks
Insert Fields Using Quick Parts

Lesson 8: Controlling Text Flow

Insert Section Breaks
Add a Header and Footer for a Document Section
Create a Newsletter Style Layout
Control Text Flow Between Text Boxes

Lesson 9: Automating Tasks

Perform a Task Automatically Using a Macro
Create a Macro
Modify a Macro

Lesson 10: Automating Document Creation

Create a Document Using a Template Wizard
Create a Document Based on a Template
Create a Template
Change the Default Template Location
Automate Standard Text Replacement in a Template
Apply And Customize Document Themes
Create Custom Themes

Lesson 11: Automating Mail Merges

Perform a Mail Merge
Mail Merge Envelopes and Labels
Use Word to Create a Data Source

[ back to top ]

Microsoft Word 2007 - Advanced

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

use Microsoft Office Word 2007 with other programs.
collaborate on documents.
manage document versions.
add reference marks and notes.
make long documents easier to use.
secure a document.
create forms.
use XML in Word.

Course Content

Lesson 1: Using Microsoft® Office Word 2007 with Other Programs

Link to a Microsoft® Office Excel® 2007 Worksheet
Link a Chart to Excel Data
Send a Document Outline to PowerPoint
Extract Text from a Fax
Send a Document as an Email Message

Lesson 2: Collaborating on Documents

Modify User Information
Send a Document for Review
Review a Document
Compare Document Changes
Merge Document Changes
Review Track Changes and Comments

Lesson 3: Managing Document Versions

Create a New Version of a Document
Compare Document Versions
Merge Document Versions

Lesson 4: Adding Reference Marks and Notes

Insert Bookmarks
Insert Footnotes and Endnotes
Add Captions
Add Hyperlinks
Add Cross-References
Add Citations and a Bibliography

Lesson 5: Making Long Documents Easier to Use

Insert Blank and Cover Pages
Insert an Index
Insert Table of Figures
Insert Table of Authorities
Insert Table of Contents
Create a Master Document
Automatically Summarize a Document

Lesson 6: Securing a Document

Update a Document's Properties
Hide Text
Remove Personal Information from a Document
Set Formatting and Editing Restrictions
Add a Digital Signature to a Document
Set a Password for a Document
Restrict Document Access

Lesson 7: Creating Forms

Add Form Fields to a Document
Protect a Form
Save a Form Data as Plain Text
Automate a Form

Lesson 8: Using XML in Word

Tag an Existing Document
Save a Document as XML
Transform an XML Document

[ back to top ]

Microsoft Excel 2007 - Introduction

Upon successful completion of this course, students will be able to:

explore the Microsoft® Office Excel® 2007 environment and create a basic worksheet.
perform calculations.
modify a worksheet.
format a worksheet.
print workbook contents.
manage large workbooks.

Course Content

Lesson 1: Creating a Basic Worksheet

Explore the User Interface and the Ribbon
Navigate and Select in Excel
Obtain Help
Enter Data and Save a Workbook
Customize the Quick Access Toolbar

Lesson 2: Performing Calculations

Create Basic Formulas
Calculate with Functions
Copy Formulas and Functions

Lesson 3: Modifying a Worksheet

Manipulate Data
Insert and Delete Cells, Columns, and Rows
Search for Data in a Worksheet
Spell Check a Worksheet

Lesson 4: Formatting a Worksheet

Modify Fonts
Add Borders and Color to Cells
Change Column Width and Row Height
Apply Number Formats
Position Cell Contents
Apply Cell Styles

Lesson 5: Printing Workbook Contents

Print Workbook Contents Using Default Print Options
Set Print Options
Set Page Breaks

Lesson 6: Managing Large Workbooks

Format Worksheet Tabs
Manage Worksheets in a Workbook
Manage the View of Large Worksheets

[ back to top ]

Microsoft Excel 2007 - Intermediate

Upon successful completion of this course, students will be able to:

calculate with advanced formulas.
organize worksheet and table data using various techniques.
create and modify charts.
format charts.
analyze data using PivotTables and PivotCharts.
insert graphic objects.
Layer and group graphic objects.
customize and enhance workbooks.
create and use templates.

Course Content

Lesson 1: Calculating Data with Advanced Formulas

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

Lesson 2: 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

Lesson 3: Presenting Data Using Charts

Create a Chart
Modify Charts
Format Charts

Lesson 4: Analyzing Data Using PivotTables and PivotCharts

Create a PivotTable Report
Analyze Data Using PivotCharts

Lesson 5: Inserting Graphic Objects

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

Lesson 6: Customizing and Enhancing Workbooks and the Excel Environment

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

[ back to top ]

Microsoft Excel 2007 - Advanced

Upon successful completion of this course, students will be able to:

increase productivity and improve efficiency by streamlining your workflow.
collaborate with others using workbooks.
audit worksheets.
analyze data.
work with multiple workbooks.
import and export data.
use Excel with the web.
structure workbooks with XML.

Course Content

Lesson 1: 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

Lesson 2: Collaborating with Others

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

Lesson 3: Auditing Worksheets

Trace Cell Precedents
Trace Cell Dependents
Troubleshoot Errors in Formulas
Troubleshoot Invalid Data and Formulas
Watch and Evaluate Formulas
Create a Data List Outline

Lesson 4: Analyzing Data

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

Lesson 5: Working with Multiple Workbooks

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

Lesson 6: Importing and Exporting Data

Export Excel Data
Import a Word Table
Import a Delimited Text File

Lesson 7: Using Excel with the Web

Publish a Worksheet to the Web
Import Data from the Web
Create a Web Query

Lesson 8: Structuring Workbooks with XML

Develop XML Maps
Import and Export XML Data
Manage XML Workbooks

[ back to top ]

Microsoft Access 2007 - Introduction

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

design a simple database.
build a new database with related tables.
manage the data in a table.
query a database using different methods.
design forms
generate reports.

Course Content

Lesson 1: Exploring the Access Environment

Examine Database Concepts
Customize the Access Environment
Use an Existing Access Database

Lesson 2: Designing a Database

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

Lesson 3: Building a Database

Create a New Database
Create and Manage a Table
Create a Table Relationship

Lesson 4: Managing Data in a Table

Modify Table Data
Sort Records
Work with Subdatasheets

Lesson 5: 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

Lesson 6: Designing Forms

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

Lesson 7: Generating Reports

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

[ back to top ]

Microsoft Access 2007 - Intermediate

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

modify the design and field properties of a table to streamline data entry.
retrieve data from tables using joins.
create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries.
enhance the capabilities of a form.
customize reports to organize the displayed information and produce specific print layouts.
share Access data across other applications.

Course Content

Lesson 1: Controlling Data Entry

Restrict Data Entry Using Field Properties
Establish a Pattern for Entering Field Values
Create a List of Values for a Field

Lesson 2: Joining Tables

Create Query Joins
Join Unrelated Tables
Relate Data Within a Table

Lesson 3: Creating Flexible Queries

Set Select Query Properties
Create Parameter Queries
Create Action Queries

Lesson 4: Improving Forms

Design a Form Layout
Enhance the Appearance of a Form
Restrict Data Entry in Forms
Add a Command Button to a Form
Create a Subform

Lesson 5: Customizing Reports

Organize Report Information
Format the Report
Set Report Control Properties
Control Report Pagination
Summarize Report Information
Add a Subreport to an Existing Report
Create a Mailing Label Report

Lesson 6: Sharing Data Across Applications

Import Data into Access
Export Data
Analyze Access Data in Excel
Export Data to a Text File
Merge Access Data with a Word Document

[ back to top ]

Microsoft Access 2007 - Advanced

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

restructure the data into appropriate tables to ensure data dependency and minimize redundancy.
write advanced queries to analyze and summarize data.
create and revise Access macros.
display data more effectively in a form.
customize reports by using various Access features, thus making them more effective.
maintain your database using tools provided by Access.

Course Content

Lesson 1: Structuring Existing Data

Analyze Tables
Create a Junction Table
Improve Table Structure

Lesson 2: Writing Advanced Queries

Create Subqueries
Create Unmatched and Duplicate Queries
Group and Summarize Records Using Criteria
Summarize Data Using a Crosstab Query
Create a PivotTable and a PivotChart

Lesson 3: Simplifying Tasks with Macros

Create a Macro
Attach a Macro
Restrict Records Using a Condition
Validate Data Using a Macro
Automate Data Entry Using a Macro

Lesson 4: Making Effective Use of Forms

Display a Calendar on a Form
Organize Information with Tab Pages
Display a Summary of Data in a Form

Lesson 5: Making Reports More Effective

Include a Chart in a Report
Print Data in Columns
Cancel Printing of a Blank Report
Create a Report Snapshot

Lesson 6: Maintaining an Access Database

Link Tables to External Data Sources
Manage a Database
Determine Object Dependency
Document a Database
Analyze the Performance of a Database

[ back to top ]

Microsoft PowerPoint 2007 - Introduction

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

create a presentation. You will also add text and themes to a presentation.
format text on slides.
add graphical objects to a presentation.
modify objects on slides.
add tables and charts to a presentation.
prepare to deliver a presentation.

Course Content

Lesson 1: Exploring the PowerPoint Environment

Explore the User Interface and the Ribbon
Customize the Quick Access Toolbar

Lesson 2: Creating a Presentation

Create and Save a Presentation
Add Slides to a Presentation
Use the PowerPoint Galleries
Work with Themes
Enter and Edit Text
Use the Various Presentation Views

Lesson 3: Formatting Text on Slides

Apply Character and Paragraph Formats
Format Text Placeholders

Lesson 4: Adding Graphical Objects to a Presentation

Insert Clip Art and Pictures
Draw Shapes and Insert WordArt

Lesson 5: Modifying Objects

Change Object Orientation
Format Objects
Group, Ungroup, and Arrange Objects

Lesson 6: Adding Tables to a Presentation

Create and Format Tables
Insert a Table from Microsoft Word

Lesson 7: Inserting Charts in a Presentation

Create a Chart
Edit and Modify a Data
Paste a Chart from Microsoft Excel

Lesson 8: Preparing to Deliver a Presentation

Spell Check
Arrange Slides and Add Transitions
Apply an Animation Effect
Create Speaker Notes
Print a Presentation
Package a Presentation

[ back to top ]

Microsoft PowerPoint 2007 - Advanced

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

customize the PowerPoint environment.
customize a design template.
add diagrams to your presentation.
add special effects to a PowerPoint presentation.
use the various options to customize slide shows.
use PowerPoint to publish slides to a slide library and secure your presentations.
finalize a presentation.

Course Content

Lesson 1: Customizing the PowerPoint Environment

Personalize the PowerPoint Interface
Customize Save Options
Apply Advanced Customization Options

Lesson 2: Customizing a Design Template

Set Up a Slide Master
Customize Slide Layouts
Create Custom Themes
Customize Bullets
Add Common Slide Information
Modify the Notes Master
Modify the Handout Master

Lesson 3: Adding Diagrams to a Presentation

Create a Diagram
Modify Diagrams

Lesson 4: Adding Special Effects to Presentations

Add Multimedia Elements
Customize Slide Component Animation

Lesson 5: Customizing a Slide Show Presentation

Set Up a Custom Show
Annotate a Presentation
Create a Presenter-Independent Slide Show
Set Up a Slide Show to Repeat Automatically

Lesson 6: Collaborating on a Presentation

Publish Slides to a Slide Library
Share a Presentation

Lesson 7: Finalizing a Presentation

Review a Presentation
Secure Presentations
Publish a Presentation as a Web Page

[ back to top ]

MCSEClasses.com is your best choice for MOS 2007, MOS 2007 training, MOS 2007 certification, MOS 2007 certification boot camp, MOS 2007 boot camp, MOS 2007 certification training, MOS 2007 boot camp training, MOS 2007 boot camp certification, MOS 2007 certification course, MOS 2007 course, training MOS 2007, certification MOS 2007, boot camp MOS 2007, certification MOS 2007 boot camp, certification MOS 2007 training, boot camp MOS 2007 training, certification MOS 2007 course.