Ivy Tech Community College, Southeast Indiana
Microsoft Office Computer Training
The Microsoft Office Specialist (MOS) program provides computer program literacy, measures proficiency and identifies opportunities for skills enhancement. The MOS Certificate is a valuable credential recognized by employers as proof that you have the desktop computing skills needed to work more productively and efficiently. Classes will be tailored to the specific needs of class participants (12 contact hours). *Text from Introduction courses will be used for Intermediate courses.

Microsoft Word
Microsoft Excel
Microsoft Access
Microsoft PowerPoint
Microsoft Outlook

Microsoft Word
Introduction
Create, edit, save and print a simple document. Change the appearance of a document by applying various character and paragraph formats. Manipulate the layout of text by creating columns and adding a table. You will also learn to use Word's templates and wizards, proofing tools and special characters to more efficiently do your work.
Intermediate Create and modify tables, charts, custom templates and styles. Insert graphic images and create a newsletter using columns. Use the Mail Merge Wizard to merge form letters with a list of addresses, complete with mailing labels. Include comments in a document and compare and merge documents.

Microsoft Excel
Introduction Create, edit, format, and print basic worksheets and charts using Excel. Work with cells and cell data by using a variety of moving and copying techniques. Perform calculations on data by using functions and formulas and change the appearance of worksheet data by using a variety of formatting techniques. You will also learn to manipulate multiple worksheets in a workbook.
Intermediate Discover techniques to use Excel and user-defined templates to create templates and workbooks, sort and filter data, and reuse and share data by importing and exporting. Use various functions and auditing features to create advanced formulas and audit worksheets. Use pivot table reports, pivot chart reports and tools to analyze data. Explore Web features to collaborate with others.  

Microsoft Access
Introduction Create tables to hold data and then establish table relationships. Modify the design of tables, select queries, organize and print forms and reported. Use table relationships and referential integrity, integrate data with other applications, and modify a table design to streamline data entry. Implement data filters and parameter and action queries. Create data access pages and joins between tables.
Intermediate Learn to analyze data by creating complex queries, producing more efficient forms, normalizing databases, using functions and speeding-up repetitive tasks by creating macros. Control; object properties to enhance form design and learn about cross-tab queries and action queries to update data. Join tables and work with join properties, create sub forms to include multiple table information on one form.  

Microsoft PowerPoint
Deliver your message with an effective PowerPoint presentation. You will learn to add notes to a slide, create and enhance graphs, incorporate Clip Art and Word Art, change design and use the Slide Master. Discover how to advance slides automatically, add sound, narration, movies and animation effects.  

Microsoft Outlook
Microsoft Outlook is a powerful tool that can help you better organize your life and increase your productivity by utilizing the e-mail, calendar and task functionality built into the software

MOS Certification - Benefits to you:

  • Improve your employment / advancement opportunities and earning potential by improving and validating your skills with this globally recognized credential
  • Enhance your professional credibility.
  • Earn college credit which can be applied towards your associate degree.

MOS Certification - Benefits to Employers:

  • Simplification of the employee screening and selection process.
  • Greater employee knowledge and improved productivity.
Did You Know... About 95% of all business standardize on Microsoft Office platform. The average user only understands 20% of the functionality available in the Microsoft Office productivity system.