Description

Microsoft Office software is used in education, as well as in virtually all business, technical, and professional jobs. It's a must for small business and entrepreneurs. Over two million Microsoft Office Specialist certificates have been issued, and Microsoft currently grants approximately 38,000 certificates per month.

This comprehensive, performance-based online training program will teach you to be proficient in Microsoft Office 2003: Word, Excel, Power Point, Outlook, and Access. Once you've finished the online program, you'll receive a certificate of completion from the college you enrolled with, and you'll be well prepared to take the Microsoft Office Specialist Certification Test.

How to Become MOS Certified
To earn the Microsoft Office Specialist (MOS) certification, you must pass one or more certification exams offered by Microsoft. For more information, see the FAQs for this program.

Standards and Alignment
The Microsoft Office Specialist (MOS) program is aligned with the following standards:

• MOS Microsoft Office Specialist Certification Requirements
• ISTE NETS Standards for Teachers, Administrators, and Students
• Michigan Grade Level Expectations and Benchmarks for 6th Grade Technology, Math, and Science

Note: You should have these Microsoft products already loaded on your computer in order to take this course: Word 2003, Excel 2003, Access 2003, Outlook 2003, and PowerPoint 2003. See the PC Requirements page for more technical requirements.

Upon registering, you're given an initial six months to complete the program. Should you need more time, you may request a six-month extension at no additional charge.

Outline

1. Beginning Windows
   1. Format Text and Use Commands
   2. Beginning Hardware Troubleshooting
   3. File Management and Administration Features and Procedures
2. Word
   1. Beginning
      1. Text Editing Functions
      2. Insert and Edit Images
      3. Format Fonts and Columns
   2. Intermediate
      1. Create and Format Tables
      2. Use Mail Merge
      3. Save as Web Page
   3. Advanced
      1. Create and Modify Forms
      2. Protect the Document
3. Excel
   1. Beginning
      1. Insert and Delete Rows and Columns
      2. Apply Number Format (Currency and Percent)
      3. Use Functions: Average and IF
   2. Intermediate
      1. Conduct Sorts
      2. Conditional Formatting
      3. Merge and Center Cells
   3. Advanced
      1. Use References (Relative and Absolute)
      2. Copy, Move, and Link Worksheets
      3. Create PivotTables
4. PowerPoint
   1. Beginning
      1. Create a Presentation From a Template or Wizard
      2. Work With Graphics and Text Boxes
      3. Animation Effects
   2. Advanced
      1. Sound Effects
      2. Import Slides From Other Programs
5. Access
   1. Beginning
      1. Create Queries
      2. Use and Design Tables and Forms
      3. Write and Test Update Queries
   2. Intermediate
      1. Create Forms With Subforms
      2. Use Criteria and Parameters
      3. Sorting and Grouping
   3. Advanced
      1. Automate Data Entry
      2. Create Mail Merge
      3. Optimize a Database for Multiple Users
6. Outlook
   1. Use Mail Features
   2. Work With Contacts
   3. Work With Attachments
   4. Archive Messages
   5. Handle Junk Mail

Demo

Additional Info

Languages

English

Course Length

120.00 hours

Duration of Access

All of our programs are self-paced and open enrollment, so you can start them when you want and finish them at your own pace. Most programs allow you 180 days after you register to complete them. If you need more time, extensions are available.

Instructor

Elizabeth Ann Nofs is co-founder and the creative director for Comma Project, LLC. Her research on how men and women approach computer learning provided the foundation for the Comma Method of training, as well as The Computer Mama Show, a pilot produced with WFUM/TV28 (PBS), Flint, Michigan.

Elizabeth is the designer and developer of the Complete Computer Guide series. The teaching methodology incorporated into the guide series is a breakthrough in producing gender-balanced training with outstanding student completion, retention, and mastery rates.

Elizabeth has been a network administrator for many businesses as well as a Microsoft course instructor. Elizabeth has taught several thousand men and women from government, manufacturing, small business, and education. She has developed Microsoft Office solutions and databases since 1993.

She's the author of several books, including: The Computer Mama Guide to Computers (2001), The Comma Method of Computer Training (2003), The Comma Teachers Edition (2003), and The Complete Computer Guide (2005).

Elizabeth received her B.A. degree in Biology from the University of Michigan, Ann Arbor.

Prerequisites/Audience

There are no specific prerequisites for this program other than an Internet connection and e-mail capabilities.

This program is for you if you want to learn how to effectively use the Microsoft Office 2003 suite of programs. This program will help prepare you to sit for the official Microsoft Office Specialist national certification exam.

Requirements/Materials Included

This program is compatible with the Windows Vista operating system.

Your tuition includes the following textbooks:

• Beginning Guide to Microsoft Word
• Intermediate Guide to Microsoft Word
• Advanced Guide to Microsoft Word
• Beginning Guide to Microsoft Excel
• Intermediate Guide to Microsoft Excel
• Advanced Guide to Microsoft Excel
• Beginning Guide to Microsoft Access
• Intermediate Guide to Microsoft Access
• Advanced Guide to Microsoft Access
• Complete Guide to Microsoft PowerPoint
• Complete Guide to Microsoft Outlook

Please have these Microsoft products already loaded on your computer in order to take this program: Word 2003, Excel 2003, Access 2003, Outlook 2003, and PowerPoint 2003.

Older versions of Microsoft Office or Microsoft Office XP may be used to take this program, but be aware there will be discrepancies between the textbook, online content, and your Microsoft Office software.

PC Requirements:

IBM-compatible (PC) computer running Windows 2000 or later or Windows XP

Adobe Flash Player and Adobe Acrobat Reader are required for this program.

Click here to download the Acrobat Reader.

Click here to download the Flash Player.

Internet connection: cable or DSL Internet access is preferred, but if your Internet service provider uses only dial-up, a minimum of 56K connection rate is recommended.

This program cannot be taken from a Mac computer.