Microsoft Office User Specialist (MOUS 2000)

A Microsoft® Office User Specialist is an individual who has certified his or her skills in one or more of the Microsoft Office desktop applications of Microsoft Word, Microsoft Excel, Microsoft PowerPoint®, Microsoft Outlook®, Microsoft Access, or in Microsoft Project. MOUS Certification validates individual skill sets so that users can get the full range of possibilities out of the software. Supporting both core/proficient and expert levels, the program ensures that companies can get the most out of their employees and reduce help-desk and other employee support costs.

You can take MOUS exam after you completed the training course and get certified by Microsoft.
　

Course Title: MS Office 2000-- Using Word 2000

Course Description: Taking MS Office 2000--Using Word 2000 teaches you how to use

Word for creating, formatting, and organizing documents for your official and personal needs.

Course Objectives: After completing this course, you will be able to: Create a simple

Word document; Organize information in a document; Proof a document using the proofing

tools; Insert headers and footers in a document; Create and format a table; Create and

enhance drawing objects; Use wizards to create a letter and a fax; Create and apply

templates; Create Web pages.

Course Outline: Creating a Document: Introducing Word, Performing Basic Word

Operations; Managing a Document: Organizing Information, Editing a Document; Enhancing

a Document: Using Headers and Footers, Using Tables, Using Drawing Objects; Creating

Special Documents: Creating Mail, Using Templates, Using the Web.

Intended Learning Audience: The target audience for this course is individuals who

need to use an electronic word processor to create, update, format, and organize documents.

This course is also meant for those appearing for Microsoft Word 2000 - Proficient User Exam,

under the Certified Microsoft Office User program.

Course Title: MS Office 2000-- Mastering Word 2000

Course Description: Taking MS Office 2000: Mastering Word teaches you how to use

Word for automating tasks, procuring data, managing documents collectively, and getting

documents reviewed on-line.

Course Objectives: After completing this course, you will be able to: Create and apply a

macro; Create printed and on-line forms; Format a document using different views; Work with

master document and sub-documents; Create pointers to data in a document; Protect data

from unauthorized access; Route data over a network; Apply the mail merge facility; Create

and modify OLE objects.

Course Outline: Advanced Features of Word: Automating Tasks, Using Forms,

Organizing Documents; Managing Long Documents: Formatting Documents, Working with

__

Long Documents, Creating Pointers to Data; Sharing Data: Sharing Data between Users,

Using Mail Merge; Using OLE with Word: Understanding OLE Techniques, Formatting OLE

Objects.

Intended Learning Audience: The target audience for this course is individuals who

need to use the advanced features of an electronic word processor for their extensive

documentation needs. This course is also meant for those appearing for Microsoft Word 2000 -

Expert User Exam, under the Certified Microsoft Office User program.

Course Title: MS Office 2000-- Using Excel 2000

Course Description: The course MS Office 2000: Using Excel teaches you how to use

Excel for performing numeric data analysis, maintaining data, and generating charts and

reports.

Course Objectives: After completing this course, you will be able to: Enter and edit data

on a worksheet; Customize print settings and print a worksheet; Use formulas and functions

effectively to calculate data; Summarize large amounts of data; Sort data on a worksheet;

Analyze data using a Pivot Table; Create and modify charts; Embed objects onto a

worksheet.

Course Outline: Getting Started with Excel 2000: Getting an overview of Excel, Navigating

in an Excel Workbook, Accessing Help in Excel; Managing an Excel Workbook: Working in

an Excel Workbook, Customizing Data, Printing a Worksheet, Saving and Closing a

Workbook; Calculating Data: Working with Formulas and Functions, Using References and

Ranges; Analyzing Data: Sorting Data, Screening Data, Summarizing Data; Incorporating

Visual Effects: Creating and Modifying Charts, Embedding Charts.

Intended Learning Audience: This course is targeted at corporate managers who

need to analyze and maintain large amounts of numeric data. This course is also meant for

those appearing for Microsoft Excel 2000 - Proficient User Exam, under the Certified Microsoft

Office User program.

__

Course Title: MS Office 2000-- Mastering Excel 2000

Course Description: The course MS Office 2000: Mastering Excel teaches you how to

use Excel for customizing workbooks, managing data lists, interpreting data, and working with

external data.

Course Objectives: After completing this course, you will be able to: Automate tasks

using macros; Sort lists on one and multiple columns; Summarize lists using AutoCalculate;

Query a list using AutoFilter, and Advanced Filter; Analyze data using data tables and

scenarios; Create data maps to display data geographically; Use OLE to insert external data

in a worksheet; Use Microsoft Query for extracting data from external databases.

Course Outline: Customizing Workbooks: Applying Advanced Formatting, Working with

Templates, Customizing Print Settings, Using Macros for Automating Tasks; Sifting through

Data Lists: Sorting and Summarizing Lists, Filtering Lists, Managing Calculations; Interpreting

Data: Performing What-If Analysis, Working with Pivot Tables, Using Data Maps; Extending

Excel’s Functionality: Linking and Embedding Data, Importing and Exporting Files, Using

External Databases, Sharing Workbooks.

Intended Learning Audience: This course is targeted at corporate managers who

need to use the advanced features of Excel for organizing and interpreting data. This course

is also meant for those appearing for Microsoft Excel 2000 - Expert User Exam, under the

Certified Microsoft Office User program.

Course Title: MS Office 2000-- Powerpoint 2000

Course Description: The course MS Office 2000: Mastering PowerPoint teaches you how

to use PowerPoint for creating professional presentations using charts, cliparts, drawings,

and data from other Office applications.

Course Objectives: After completing this course, you will be able to: Create a

PowerPoint presentation on any topic; Edit and organize the presentation to obtain the

desired sequence and layout; Embed and link data from other Office applications into the

presentation; Fine tune the presentation to enable it to run automatically with desired effects;

Run and control the presentation and capture the minutes appropriately.

__

Course Outline: Learning PowerPoint Basics: Using the PowerPoint dialog Box,

Introducing the PowerPoint Interface; Creating a Presentation: Starting a Presentation, Fine

Tuning Text in the Outline View, Arranging a Presentation, Creating Speaker`s Notes,

Viewing the Slide Show View; Adding Visual Impact to a Presentation: Modifying Slides with

the Slide Master, Incorporating a Clip Art Image, Incorporating Pictures, Incorporating Audio

and Video, Drawing and Customizing AutoShapes; Preparing for a Presentation: Adding a

Footer and a Color Scheme, Incorporating Information by using OLE, Fine Tuning a

Presentation, Hard Copying and Packaging a Show.

Intended Learning Audience: This course is targeted at corporate executives who

need to make professional presentations. This course is also meant for those appearing for

Microsoft PowerPoint 2000 - Expert User Exam, under the Certified Microsoft Office User

program.

Course Title: MS Office 2000-- Using Outlook 2000

Course Description: The course MS Office 2000: Using Outlook teaches you how to use

Outlook for scheduling and managing your day to day activities.

Course Objectives: After completing this course, you will be able to: Use the Outlook

Bar to organize information in Outlook; Use folders to manage different items in Outlook;

Perform scheduling operations using the Calendar components of Outlook; Coordinate

activities scheduled in one time zone with the activities scheduled in another time zone; Keep

track of the scheduled activities and events; Organize items in Outlook; Create and maintain

the Contact List; Work with a Journal; Use Notes in Outlook; Send E-mail messages;

Organize E-mail messages; Use enhanced E-mail features; Schedule meetings.

.

Course Outline: Getting Started with Outlook: Overview to Outlook, Using the Outlook

Bar, Working with Folders, Viewing Items in Outlook; Managing Schedule in Outlook:

Keeping Track of Appointments, Setting Time Zones, Organizing Tasks, Managing Events;

Managing Information in Outlook; Organizing Items in Outlook: Working with a Contact List,

Working with a Journal, Working with Notes; Managing Outlook on a Network: Working with

E-mail, Managing E-mail, Using Enhanced E-mail Features, Scheduling Meetings.

Intended Learning Audience: This course is targeted at corporate managers who

need to schedule their time effectively. This course is also meant for those appearing for

Microsoft Outlook 2000 - Expert User Exam, under the Certified Microsoft Office User program.

__

Course Title: MS Office 2000-- Mastering Outlook 2000

Course Description: The course MS Office 2000: Mastering Outlook teaches you how to

use Outlook for managing and sharing personal and business information with a group.

Course Objectives: After completing this course, you will be able to: Schedule meetings

with a contact; Assign tasks to a contact; Assign a Web URL to a contact; Create an Outlook

form from an item; Edit and update an Outlook form; Create a dynamic view to view data in a

specified format; Create a filter to view data based on a criterion; Create new categories;

Locate and filter items based on a category; Create shared items; Set access rights to an

Outlook item; Create a task and an appointment from an e-mail message; Create a note from

any Outlook item; Archive and print items in Outlook.

Prerequisites: To derive maximum benefits from this course, you should be familiar with

the basic features of Outlook 2000. You can gain the relevant concepts and skills from the MS

Office 2000: Using Outlook course in this curriculum.

Course Outline: Handling Tasks and Activities: Course Overview, Delegating Tasks,

Tracking Task Requests, Recording Activities in Journal; Managing Mail Messages: Handling

Mail Messages, Using Enhanced Mail Features, Working with Remote Mail; Managing

Contacts: Dialing Contacts, Interacting with Contacts, Working with Contacts; Customizing

Information: Working with Forms, Working with Views, Working with Categories; Managing

Outlook Items: Sharing Outlook Items, Integrating Outlook Items, Archiving and Printing.

Intended Learning Audience: This course is targeted at corporate mangers and

executives who need to manage personal and official information, besides communicating

this information within a group and on the Internet. This course is also meant for those

appearing for Microsoft Outlook 2000 - Expert User Exam, under the Certified Microsoft Office

User program.