Microsoft Office XP Certification

Outcomes

• You will be able to apply this knowledge in the workplace
• You will have an appreciable understanding of the subject matter
• You will be trained in a systematic manner designed to get you up to speed on the subject matter in a short period of time

Assessment Testing as part of the course through exam simulation engines. Course Details Access XP

Access XP

Northwind Traders Database

Access XP

Database Use/Templates

Access XP

Setting Up a Database from Scratch

Access XP

Queries and Reports

Access XP

Creating Tables Manually

Access XP

Creating Forms Manually

Access XP

Creating Queries and Reports Manually

Access XP

Multiple Table Relationships

Access XP

Wrap-Up

Access XP

Introduction

Access XP

Records Navigation

Access XP

Sorting and Filtering

Access XP

Types of Relationships

Access XP

Building a Relationship from Scratch

Access XP

Relationships Continued

Access XP

Normalization

Access XP

Look-Up Wizard

Access XP

Wrap-Up

Access XP

Calculation Controls

Access XP

Developing Controls in a Query

Access XP

Developing Controls in a Report

Access XP

Controls in the Northwind Database

Access XP

Importing/Exporting Data

Access XP

Import Data

Access XP

Simple Data Access Pages

Access XP

Wrap-Up

? ? Excel XP

Excel XP

Program Setup

Excel XP

The Basics: Formulas

Excel XP

Formulas Continued

Excel XP

Setting Up a Spreadsheet

Excel XP

Templates

Excel XP

Printing

Excel XP

Advanced Formulas

Excel XP

Relative/Absolute Reference

Excel XP

Charts

Excel XP

Wrap-Up

Excel XP

Introduction

Excel XP

Fill/Trends

Excel XP

Cell Formatting

Excel XP

Formatting

Excel XP

Conditional Formatting

Excel XP

Importing/Exporting Data

Excel XP

Using Filters

Excel XP

Web Publishing

Excel XP

Work Space

Excel XP

Conditional/Sum Wizard

Excel XP

Validation Rules

Excel XP

Tracking Precedents

Excel XP

Goal Seek/Lotus 123 Help

Excel XP

If Statement

Excel XP

Wrap-Up

Excel XP

Introduction

Excel XP

Cell Referencing

Excel XP

Paste Special

Excel XP

Formula Construction

Excel XP

Named Ranges

Excel XP

Shared Workspace

Excel XP

Password Protect

Excel XP

Macros

Excel XP

Pivot Tables

Excel XP

Wrap-Up

? ? Frontpage XP

FrontPage XP

Navigation

FrontPage XP

Theme/Styles

FrontPage XP

HTML Code

FrontPage XP

Corporate Presence

FrontPage XP

Editing Text

FrontPage XP

Page Transitions

FrontPage XP

Publishing Tools

FrontPage XP

MS FrontPage Extensions

FrontPage XP

Delete Web Files

FrontPage XP

Wrap-Up

? ? Outlook XP

Outlook XP

New Account Setup

Outlook XP

Address Book/Contacts

Outlook XP

Message Management/Backup Archive

Outlook XP

Views

Outlook XP

File-Task-Signature

Outlook XP

Rules Wizard

Outlook XP

Printing

Outlook XP

Mail Formatting

Outlook XP

Certification Test

? ? PowerPoint XP

PowerPoint XP

Navigating Taskbars and Menus

PowerPoint XP

Design Template

PowerPoint XP

Save

PowerPoint XP

Navigation/Design Features

PowerPoint XP

Using Help/Transitions

PowerPoint XP

Timing/Speaker Notes

PowerPoint XP

Printing

PowerPoint XP

Save As Web

PowerPoint XP

Word Conversion

PowerPoint XP

Final Thoughts

PowerPoint XP

Introduction

PowerPoint XP

Task Pane

PowerPoint XP

AutoContent Wizard

PowerPoint XP

Master Slide

PowerPoint XP

Auto Recovery

PowerPoint XP

Text Box/Layout/Features

PowerPoint XP

Views

PowerPoint XP

Maximum # of Undos

PowerPoint XP

Drawing Toolbar

PowerPoint XP

Style Checker

PowerPoint XP

Hyperlinks/Pack and Go

PowerPoint XP

Headers/Footers

PowerPoint XP

Certification Test

? ? Publisher XP

Publisher XP

Layout/Templates

Publisher XP

Personal Information

Publisher XP

Create Business Cards

Publisher XP

Blank Folder Layout

Publisher XP

Web Sites/Web Pages

Publisher XP

Print/Pack and Go

Publisher XP

Wrap-Up

Contact Hours: 24