Microsoft Office Specialist Training

Microsoft Office Specialist 2003 Certification Boot Camp

The Microsoft Office Specialist program is the only comprehensive, performance-based certification program approved by Microsoft to validate desktop computer skills using the Microsoft Office programs.

• Microsoft Word 2003 - Intermediate
• Microsoft Word 2003 - Advanced
• Microsoft Excel 2003 - Introduction
• Microsoft Excel 2003 - Intermediate
• Microsoft Excel 2003 - Advanced
• Microsoft Access 2003 - Introduction
• Microsoft Access 2003 - Intermediate
• Microsoft Access 2003 - Advanced
• Microsoft PowerPoint 2003 - Introduction
• Microsoft PowerPoint 2003 - Advanced

The Office Specialist program provides computer program literacy, measures proficiency, and identifies opportunities for skills enhancement. Successful candidates receive an Office Specialist certificate that sets them apart from their peers in the competitive job market. The certificate is a valuable credential recognized worldwide as proof that an individual has the desktop computing skills needed to work more productively and efficiently.

By encouraging individuals to develop advanced skills with Microsoft business desktop software, the Office Specialist program is helping to fill the demand for qualified, knowledgeable people in the workplace. Office Specialist also helps satisfy an organization's need for a qualitative assessment of employee skills.

Microsoft Office Specialist Facts

• The Office Specialist program is available in more than 100 countries and in 17 different languages.
• More than 1 million Office Specialist certificates have been issued.
• Approximately 32,000 Office Specialist certificates are issued each month.
• Approximately 5,000 Office Specialist Master Instructors have been certified.

What sets Microsoft Office Specialist candidates apart from their peers?

Microsoft Office Specialist certification gives both job applicants and employees the advantage of proven productivity in a competitive market for jobs and advancement.

Who benefits from the Microsoft Office Specialist program?

Microsoft Office Specialist certification distinguishes users of Microsoft Office products as truly knowledgeable—a designation that attracts attention in the competitive job market. Microsoft Office Specialist certification also demonstrates employee competence, helping managers with job placement and advancement. Hiring or promoting candidates with Microsoft Office Specialist certification also reduces the amount of training needed to enable new employees to contribute to the overall level of organizational effectiveness. Find out more about what Microsoft Office Specialist certification provides for individuals and businesses on the Microsoft Office Specialist Certification Benefits page.

Microsoft Word 2003 - Intermediate

In the first course in this series you gained all the basic skills that you need to create a wide range of standardized business documents. If you use Microsoft® Office Word XP on a regular basis, then once you have mastered the basic skills, the next step is to improve your proficiency. To do so, you can customize and automate the way Microsoft® Word XP works for you, and you can improve the quality of your work by enhancing your documents with customized Microsoft® Word XP elements. In this course, you will increase the complexity of your Microsoft® Word XP documents by adding components such as customized lists, tables, charts, and graphics. You will also create personalized Microsoft® Word XP efficiency tools.

Course Objective: You will add complexity to Microsoft® Office Word XP documents and create personalized efficiency tools in Microsoft® Word XP.

Target Student: This course was designed for persons who can create and modify standard business documents in Microsoft® Word XP, and who need to learn how to use Microsoft® Word XP to create or modify complex business documents as well as customized Word efficiency tools. It will be helpful for persons preparing for the Microsoft Office Specialist exams for Microsoft® Word XP.

Prerequisites: Students should be able to use Microsoft® Word XP to create, edit, format, save, and print basic business documents that contain text, basic tables, and simple graphics.

Performance-Based Objectives

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

• manage data in lists.
• customize tables and charts.
• customize formatting.
• work with custom styles.
• modify pictures in a document.
• create customized graphic elements.
• control text flow.
• automate common tasks.
• automate document creation.
• perform mail merges.

Course Content

Lesson 1: Managing Lists

• Sort a List
• Restart a List
• Create an Outline Numbered List
• Customize List Appearance

Lesson 2: Customizing Tables and Charts

• Sort a Table
• Modify Table Structure
• Merge or Split Cells
• Position Text in a Table Cell
• Apply Borders and Shading
• Perform Calculations in a Table
• Create a Chart from a Word Table
• Modify a Chart

Lesson 3: Customizing Formatting

• Modify Character Spacing
• Add Text Effects
• Control Paragraph Flow

Lesson 4: Working with Custom Styles

• Create a Character or Paragraph Style
• Modify an Existing Style
• Create a List Style
• Create a Table Style

Lesson 5: Modifying Pictures

• Set Picture Contrast or Brightness
• Crop a Picture
• Wrap Text Around a Picture

Lesson 6: Creating Customized Graphic Elements

• Draw Shapes and Lines
• Insert WordArt
• Insert Text Boxes
• Create Diagrams

Lesson 7: Controlling Text Flow

• Insert Section Breaks
• Insert Columns
• Link Text Boxes

Lesson 8: Automating Common Tasks

• Run a Macro
• Create a Macro
• Modify a Macro
• Customize Toolbars and Buttons
• Add Menu Items

Lesson 9: Automating Document Creation

• Create a Document Based on a Template
• Create a Document by Using a Wizard
• Create or Modify a Template
• Change the Default Template Location
• Insert a MacroButton Field in a Template

Lesson 10: Performing Mail Merges

• The Mail Merge Process
• Perform a Merge on Existing Documents
• Merge Envelopes and Labels
• Use Word to Create a Data Source

[ back to top ]

Microsoft Word 2003 - Advanced

You know how to use Microsoft® Office Word XP to create and format typical business documents. But you need to work on more complex documents. In this course, you will learn how to use Word to create, manage, revise, and distribute long documents, forms, and Web pages.

Course Objective: You will create, manage, revise, and distribute long documents, forms, and Web pages.

Target Student: This course was designed for persons with a basic understanding of Microsoft Windows who can create and modify standard business documents in Microsoft® OfficeWord XP, and who need to learn how to use the more advanced features of Word XP to create, manage, revise, and distribute long documents, forms, and Web pages. This course is intended for persons interested in pursuing Microsoft Office Specialist certification in Microsoft® Word XP.

Prerequisites: Students should be able to use Microsoft® Office Word XP to create, edit, format, save, and print business documents that contain text, tables, and graphics. Students should also be able to use a Web browser and an email program. A basic understanding of XML would also be helpful. In order to understand how Word interacts with other applications in the Microsoft Office System, students should have a basic understanding of how worksheets and presentations work.

Performance-Based Objectives

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

• Use Word with other programs.
• Collaborate on documents.
• Add reference marks and notes to a document.
• Make long documents easier to use.
• Secure documents and document information.
• Create Web pages.
• Create a form.
• Use XML in Word.

Course Content

Lesson 1: Using Microsoft Office Word XP with Other Programs

• Link to a Microsoft® Office Excel XP Worksheet
• Link a Chart to Excel Data
• Send a Document Outline to PowerPoint
• Extract Text from a Fax
• Save a Document as a Different File Format
• Look Up Information Using Research Sites
• Send a Document as an Email Attachment

Lesson 2: Collaborating on Documents

• Modify User Information
• Create a New Version of a Document
• Delete Old Versions
• Send a Document for Review
• Use Comments
• Compare Document Changes
• Merge Document Changes
• Review a Document

Lesson 3: Adding Reference Marks and Notes

• Insert Bookmarks
• Insert Footnotes and Endnotes
• Add Captions
• Insert Cross-references

Lesson 4: Making Long Documents Easier to Use

• Mark Text for Indexing
• Insert an Index
• Insert a Table of Figures
• Mark Text for a Table of Authorities
• Insert a Table of Authorities
• Insert a Table of Contents
• Create a Master Document
• Automatically Summarize a Document

Lesson 5: Securing a Document

• Update a Document's Properties
• Save a Document without Personal Information
• Hide Text
• Limit Formatting Choices in a Document
• Select Regions of a Document that Can Be Modified
• Add a Digital Signature to a Document
• Require a Password to Open a Document

Lesson 6: Creating Web Pages

• Create a Web Page
• Insert Hyperlinks
• Insert a Movie Clip into a Web Page
• Apply a Theme to a Web Page
• Create a Framed Web Page
• Save a Web Page to a Web Server

Lesson 7: Creating Forms

• Add Form Fields to a Document
• Protect a Form
• Save 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 2003 - Introduction

In this course, you will use Microsoft® Office Excel 2003 to manage, edit, and print data.

Course Objective: You will create and edit basic Microsoft® Office Excel 2003 worksheets and workbooks.

Target Student: This course is designed for persons preparing for certification as a Microsoft® Office Specialist in Excel, who already have knowledge of the Microsoft® Office Windows 98 (or above) operating system, and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft® Excel 2003 worksheets.

Performance-Based Objectives

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

• create a basic worksheet.
• modify a worksheet.
• perform calculations.
• format a worksheet.
• develop a workbook.
• print the contents of a workbook.
• customize the layout of the Excel window.

Course Content

Lesson 1: Getting Started with Excel

• An Overview of Excel
• Navigate in Excel
• Select Data
• Enter Data
• Save a Workbook
• Obtain Help

Lesson 2: Modifying a Worksheet

• Move and Copy Data Between Cells
• Fill Cells with Series of Data
• Insert and Delete Cells, Columns, and Rows
• Find, Replace, and Go To Cell Data

Lesson 3: Performing Calculations

• Create Basic Formulas
• Calculate with Functions
• Copy Formulas and Functions
• Create an Absolute Reference

Lesson 4: Formatting a Worksheet

• Change Font Size and Type
• Add Borders and Color to Cells
• Change Column Width and Row Height
• Merge Cells
• Apply Number Formats
• Create a Custom Number Format
• Align Cell Contents
• Find and Replace Formats
• Apply an AutoFormat
• Apply Styles

Lesson 5: Developing a Workbook

• Format Worksheet Tabs
• Reposition Worksheets in a Workbook
• Insert and Delete Worksheets
• Copy and Paste Worksheets
• Copy a Workbook

Lesson 6: Printing Workbook Contents

• Set a Print Title
• Create a Header and a Footer
• Set Page Margins
• Change Page Orientation
• Insert and Remove Page Breaks
• Print a Range

Lesson 7: Customizing Layout

• Split a Worksheet
• Arrange Worksheets
• Freeze and Unfreeze Rows and Columns
• Hide and Unhide Worksheets

[ back to top ]

Microsoft Excel 2003 - Intermediate

In this course, you will use Microsoft® Excel 2003 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.

Course Objective: You will apply visual elements and advanced formulas to a worksheet to display data in various formats.

Target Student: The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the Web. In addition, this course helps prepare students who desire to prepare for the Microsoft Office Specialist exam in Excel or Module 2 and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets.

Prerequisites: To ensure your success, we recommend that you have experience with creating, editing, formatting, saving, and printing basic spreadsheets in Microsoft® Excel 2003.

Performance-Based Objectives

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

• create and apply templates.
• create and modify charts.
• work with graphic objects.
• calculate with advanced formulas.
• sort and filter data.
• use Excel with the Web.

Course Content

Lesson 1: Creating and Applying Templates

• Create a Workbook from a Template
• Create a Custom Template
• Working with Comments
• Create a Hyperlink
• Use Web-based Research Tools

Lesson 2: Creating and Modifying Charts

• Create a Chart
• Format Chart Items
• Change the Chart Type
• Create a Diagram

Lesson 3: Working with Graphic Objects

• Insert Graphics
• Create AutoShapes
• Format Graphic Objects
• Change the Order of Graphic Objects
• Group Graphic Objects
• Move, Copy, and Resize Graphic Objects

Lesson 4: Calculating with Advanced Formulas

• Create and Apply a Name for a Range of Cells
• Calculate Across Worksheets
• Calculate with Date and Time Functions
• Calculate with Financial Functions
• Calculate with Statistical Functions
• Calculate with Lookup and Reference Functions
• Calculate with Logical Functions

Lesson 5: Sorting and Filtering Data

• Sort Data Lists
• Filter Data Lists
• Create and Apply Advanced Filters
• Calculate with Database Functions
• Add Subtotals to a Worksheet

Lesson 6: Using Excel with the Web

• Export Excel Data
• Publish a Worksheet to the Web
• Import Data from the Web
• Create a Web Query

[ back to top ]

Microsoft Excel 2003 - Advanced

You have used Microsoft® Office Excel 2003 to perform tasks such as running calculations on data and sorting and filtering numeric data. You would now like to automate some common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.

Course Objective: You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.

Target Student: This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create PivotTables and PivotCharts, incorporate multiple data sources, and import and export data. In addition, the course is also for students desiring to prepare for the Microsoft Office Specialist exam in Excel 2003 and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

Performance-based Objectives

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

• Customize workbooks.
• Collaborate with others using workbooks.
• Audit worksheets.
• Analyze data.
• Work with multiple workbooks.
• Import and export data.
• Structure workbooks with XML.

Course Content

Lesson 1: Streamlining Workflow

• Create a Macro
• Edit a Macro
• Customize Access to Excel Commands
• 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

Lesson 3: Auditing Worksheets

• Trace Cell Precedents
• Trace Cell Dependents
• Locate Errors in Formulas
• Locate Invalid Data and Formulas
• Watch and Evaluate Formulas
• Group and Outline Data

Lesson 4: Analyzing Data

• Create a Trendline
• Create Scenarios
• Perform What-If Analysis
• Develop a PivotTable© Report
• Develop a PivotChart© Report
• 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 to Microsoft Word
• Import a Word Table
• Import Text Files

Lesson 7: Structuring XML Workbooks

• Develop XML Maps
• Import, Add, and Export XML Data
• Manage XML Workbooks
• Apply XML View Options

[ back to top ]

Microsoft Access 2003 - Introduction

Most organizations maintain and manage large amounts of information. One of the most efficient and powerful information management, computer based applications, is the relational database. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will be introduced to the concept of the relational database and the Microsoft® Office Access 2003 relational database application and its information management tools.

Course Objective: You will be introduced to the features of the Microsoft® Office Access 2003 application.

Target Student: This course is designed for students who wish to learn the basic operations of the Microsoft Access Database program to perform their day to day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes. This course is for the individual whose job responsibilities include working with tables to create and maintain records, locate records, and produce reports based on the information in the database. It also provides the fundamental knowledge and techniques needed to advance to more technical Access responsibilities, such as creating and maintaining new databases and using programming techniques that enhance Access applications.

Performance-Based Objectives

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

• examine the Microsoft® Office Access 2003 database application.
• manage the data in a database.
• examine existing table relationships.
• query the database.
• design simple forms.
• create and modify Access reports.

Course Content

Lesson 1: An Overview of Access 2003

• The Access Environment
• Examine an Access Table

Lesson 2: Managing Data

• Examine an Access Form
• Add and Delete Records
• Sort Records
• Display Record Sets
• Update Records
• Run a Report

Lesson 3: Establishing Table Relationships

• Identify Table Relationships
• Identify Primary and Foreign Keys in the Relationships Window
• Working with Subdatasheets

Lesson 4: Querying the Database

• The Select Query
• Add Criteria to a Query
• Add a Calculated Field to a Query
• Perform a Calculation on a Record Grouping

Lesson 5: Designing Forms

• Form Design Guidelines
• Create AutoForms
• Create a Form Using the Form Wizard
• Modify the Design of a Form

Lesson 6: Producing Reports

• Create an AutoReport
• Create a Report by Using the Wizard
• Examine a Report in Design View
• Add a Calculated Field to a Report
• Modify the Format Properties of a Control
• AutoFormat a Report
• Adjust the Width of a Report

[ back to top ]

Microsoft Access 2003 - Intermediate

As you begin this course, you should have the basic skills you need to work with a Microsoft® Office Access 2003 databases. This includes working with Access tables, relationships, queries, forms, and reports. But thus far you have been focusing on essential database user skills only. In this course you will consider how to design and create a new Access database, how to customize database components, and how to share Access data with other applications.

Course Objective: You will design and create a new Access database; improve queries, forms, and reports; and integrate Microsoft® Office Access 2003 with other applications.

Target Student: This course is designed for the student who wishes to learn intermediate-level operations of the Microsoft® Access program. It is for the individual whose job responsibilities include creating new databases, tables, and relationships, as well as working with and revising intermediate-level queries, forms, and reports. It also introduces the student to integrating Access data with other applications such as Microsoft® Word or Excel. This course is also designed for students pursuing the Microsoft Office Specialist Certification for Access 2003, and it is a prerequisite to taking more advanced courses in Access 2003.

Performance-Based Objectives

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

• follow the steps required to properly design a simple database.
• create a new database with related tables.
• control data entry by modifying the design of a table to streamline data entry and maintain data integrity.
• find and retrieve desired data by using filters and joins between tables and within a single table.
• create flexible queries to display specified records; allow for user-determined query criteria; and add, update, and delete data with queries.
• enhance the appearance, data entry, and data access capabilities of your forms.
• customize reports to better organize the displayed information and produce specific print layouts such as mailing labels.
• use Access data in other applications, including Microsoft Word and Excel.

Course Content

Lesson 1: Planning a Database

• Design a Relational Database
• Identify Database Purpose
• Review Existing Data
• Determine Fields
• Group Fields into Tables
• Normalize the Data
• Designate Primary and Foreign Keys

Lesson 2: Building the Structure of a Database

• Create a New Database
• Create a Table Using a Wizard
• Create Tables in Design View
• Create Relationships between Tables

Lesson 3: Controlling Data Entry

• Restrict Data Entry with Field Properties
• Create an Input Mask
• Create a Lookup Field

Lesson 4: Finding and Joining Data

• Find Data with Filters
• Create Query Joins
• Join Unrelated Tables
• Relate Data Within a Table

Lesson 5: Creating Flexible Queries

• Set Select Query Properties
• Create Parameter Queries
• Create Action Queries

Lesson 6: Improving Your Forms

• Enhance the Appearance of a Form
• Restrict Data Entry in Forms
• Add Command Buttons
• Create a Subform

Lesson 7: Customizing Your Reports

• Organize Report Information
• Set Report Control Properties
• Control Report Pagination
• Summarize Information
• Add a Subreport to an Existing Report
• Create Mailing Labels

Lesson 8: Expanding the Reach of Your Data

• Publish Access Data as a Word Document
• Analyze Access Data in Excel
• Export Data to a Text File
• Merge Access Data with a Word Document

[ back to top ]

Microsoft Access 2003 - Advanced

Your training in and use of Microsoft® Office Access 2003 has provided you with a solid foundation in the basic and intermediate skills for working in Microsoft® Office Access 2003. You're now ready to extend your knowledge into some of the more specialized and advanced capabilities.

Course Objective: You will create complex Access databases using forms, reports, and macros.

Target Student: This course is designed for the student who wishes to learn intermediate and advanced operations of the Microsoft® Office Access 2003 database program. This course is for the individual whose job responsibilities include working with heavily related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance. It is also designed as one in a series of courses for students pursuing the Microsoft® Office Specialist Certification for Microsoft® Office Access 2003, and it is a prerequisite to taking more advanced courses in Microsoft® Office Access 2003.

Performance-Based Objectives

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

• restructure an existing set of data to improve the design of a database.
• use a variety of techniques to summarize and present data with queries.
• create and revise basic Access macros.
• create macros that improve data entry efficiency and integrity.
• improve the effectiveness of data entry in forms.
• improve the effectiveness of data displayed in reports.
• maintain an Access database by using various utility tools.

Course Content

Lesson 1: Structuring Existing Data

• Import Data
• Analyze Tables
• Create a Junction Table
• Improve Table Structure

Lesson 2: Writing Advanced Queries

• Create Unmatched and Duplicates Queries
• Group and Summarize Records Using the Criteria Field
• Summarize Data with a Crosstab Query
• Create a PivotTable and a PivotChart
• Display a Graphical Summary on a Form

Lesson 3: Simplifying Tasks with Macros

• Create a Macro
• Attach a Macro to a Command Button
• Restrict Records Using a Where Condition

Lesson 4: Adding Interaction and Automation with Macros

• Require Data Entry with a Macro
• Display a Message Box with a Macro
• Automate Data Entry

Lesson 5: Making Forms More Effective

• Change the Display of Data Conditionally
• Display a Calendar on a Form
• Organize Information with Tab Pages

Lesson 6: Making Reports More Effective

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

Lesson 7: Maintaining an Access Database

• Link Tables to External Data Sources
• Back Up a Database
• Compact and Repair a Database

[ back to top ]

Microsoft PowerPoint 2003 - Introduction

In the past, you have used paper-based overhead systems to give presentations. Now, you want to upgrade those presentations to an electronic format. You can use Microsoft® Office PowerPoint® XP to give electronic presentations.

Course Objective: You will create effective basic Microsoft® Office PowerPoint® XP presentations for delivery in front of an audience.

Target Student: This course is designed for students who are interested in learning the fundamentals needed to create and modify basic Microsoft® PowerPoint® XP presentations. This course is also intended for students who wish to pursue their Microsoft Office Specialist certification in PowerPoint XP.

Performance-Based Objectives

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

• manipulate an existing PowerPoint presentation.
• begin creating a presentation.
• format text slides.
• add tables to a presentation.
• chart data in a presentation.
• modify objects on slides.
• add images to a presentation.
• prepare to deliver a presentation.

Course Content

Lesson 1: An Orientation to PowerPoint

• The PowerPoint Environment
• Orientation to Views
• Navigate Through a Presentation
• Edit Slide Text
• Save the Presentation
• Run a Slide Show

Lesson 2: Beginning a Presentation

• Create a New Presentation
• Change Background Color
• Add Slides to a Presentation
• Enter Text
• Create a Presentation from a Microsoft Word Outline

Lesson 3: Formatting Text Slides

• Apply Character Formats
• Align Text
• Change Line Spacing
• Change Indents

Lesson 4: Adding Tables to a Presentation

• Create a Table
• Format Tables
• Insert a Table from Microsoft Word

Lesson 5: Charting Data

• Create a Column Chart
• Edit Chart Data
• Change Chart Type
• Insert a Chart from Microsoft Excel

Lesson 6: Modifying Objects

• Resize Objects
• Copy and Duplicate Objects
• Move Objects
• Changing Object Orientation
• Format Objects
• Group and Ungroup Objects
• Change the Order of Objects

Lesson 7: Adding Images to a Presentation

• Add Clip Art
• Add a Picture from a File
• Draw Lines and Shapes
• Insert WordArt

Lesson 8: Preparing to Deliver a Presentation

• Spell Check
• Arrange Slides
• Add Transitions
• Create Speaker Notes
• Send a Presentation to Microsoft Word
• Print the Presentation
• Package a Presentation for CD

[ back to top ]

Microsoft PowerPoint 2003 - Advanced

As a Microsoft® Office PowerPoint® XP user familiar with the basics, you're able to convey information clearly without much glitz. That's okay, but you can do better-audiences expect more than the basics. In this course, you will enhance presentations with features that will transform basic presentations into those with a powerful means of communication.

Course Objective: You will use Microsoft® Office PowerPoint® XP features that draw, animate, and format presentations with professional-quality content such that they may be communicated to a wide variety of live, remote, and self-service audiences.

Target Student: This course is designed for students who desire to gain the skills necessary to work with design templates, organizational charts, special effects, Web presentations, collaboration functionality, and advanced presentation delivery, or students who desire to prepare for the Microsoft Office Specialist exam in Microsoft® PowerPoint® XP and who already have knowledge of the basics of Microsoft® PowerPoint® XP, including slide formatting, working with tables, images, and objects, charting data, and presentation preparation.

Performance-Based Objectives

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

• create a design template.
• create organization charts and diagrams.
• add special effects to a Microsoft® Office PowerPoint® XP slide.
• create a Web-based Microsoft® Office PowerPoint® XP presentation.
• use a Microsoft® Office PowerPoint® XP presentation for collaborative workgroup review.
• use functionality that will enable you to deliver live, self-service, and online presentations.

Course Content

Lesson 1: Creating a Custom Design Template

• Define Design Template Characteristics
• Create a Custom Color Scheme
• Set Up a Slide Master
• Format Custom Bullets
• Add a Footer
• Modify the Notes Master
• Save a Custom Design Template

Lesson 2: Adding Organization Charts and Diagrams

• Working with Organization Charts
• Update an Organization Chart
• Applying a Chart Layout
• Create a Diagram
• Draw a Flowchart

Lesson 3: Adding Special Effects

• Add Sound and Movies
• Add Animation
• Emphasize Objects
• Set a Motion Path
• Set the Order of Effects

Lesson 4: Creating Web Presentations

• Create a Group Home Page with the AutoContent Wizard
• Hyperlink to a Web Page
• Publish as a Web Page

Lesson 5: Collaborating in PowerPoint

• Set Password Protection
• Work with Comments
• Send a Presentation for Review
• Merge Revision Copies
• Apply Reviewer Changes

Lesson 6: Delivering a Presentation

• Hyperlink Within PowerPoint
• Add an Action Button
• Set Up a Custom Show
• Annotate a Presentation
• Working with Narrations and Slide Timings
• Set Up a Slide Show to Repeat Automatically

[ back to top ]

MCSEClasses.com is your best choice for Office 2003, Office 2003 training, Office 2003 certification, Office 2003 certification boot camp, Office 2003 boot camp, Office 2003 certification training, Office 2003 boot camp training, Office 2003 boot camp certification, Office 2003 certification course, Office 2003 course, training Office 2003, certification Office 2003, boot camp Office 2003, certification Office 2003 boot camp, certification Office 2003 training, boot camp Office 2003 training, certification Office 2003 course.

mcseclasses home | technical schedule | application schedule | class outlines | mcse, mcdba, mcsd training | microsoft .net | cisco certification | security training | ced solutions oracle® certification training | linux, unix, aix | comptia certification | webmaster training | pricing | locations | financing | instructors needed | e-mail us