Augusta State University
 
Continuing Education
  
Augusta State University : Continuing Education
  Home | Classes | Class Outline
9 Sep 2010
  
Microsoft Office User Specialist - Expert
MOS - Expert
Duration: 21 Hours
Offered at the following locations:
 
Augusta State University
The Microsoft Office Specialist program is committed to providing students and information workers with the opportunity to certify their Microsoft Office skills. Office Specialists enjoy increased competence and productivity with Microsoft Office programs as well as increased credibility with employers, coworkers and clients. In the MOUS Expert Track Certification, students must successfully complete one (1) required expert track and expert exam. Track: MOUS Expert Certification consist of one required track in Word or Excel: Audience Profile for MOUS Word 2003 Expert Certification: Microsoft Office Word 2003 Expert certification is intended for students and information workers whose responsibilities include the use of Microsoft Word at the expert-level to create, edit and format documents in organizations of every size. Skill Standards This exam measures your ability to productively use Microsoft Office Word 2003 Expert. Before taking the exam, you should be proficient in the following program skills: Formatting Content · Create custom styles for text, tables and lists · Control pagination · Format, position and resize graphics using advanced layout features · Insert and modify objects · Create and modify diagrams and charts using data from other sources Organizing Content · Sort content in lists and tables · Perform calculations in tables · Modify table formats · Summarize document content using automated tools · Use automated tools for document navigation · Merge letters with other data sources · Merge labels with other data sources · Structure documents using XML Formatting Documents · Create and modify forms · Create and modify document background · Create and modify document indexes and tables · Insert and modify endnotes, footnotes, captions, and cross-references · Create and manage master documents and subdocuments Collaborating · Modify track changes options · Publish and edit Web documents · Manage document versions · Protect and restrict forms and documents · Attach digital signatures to documents · Customize document properties Customizing Word · Create, edit, and run macros · Customize menus and toolbars · Modify Word default settings Audience Profile for MOUS Excel 2003 Expert Certification: Microsoft Office Excel 2003 Expert certification is intended for students and information workers whose responsibilities include the use of Microsoft Excel to create, modify, share, and revise workbooks using templates, automated procedures, and the Web, and retrieve, analyze, and summarize data in organizations of every size. Skill Standards This exam measures your ability to productively use Microsoft Office Excel 2003 at the expert level. Before taking the exam, you should be proficient in the following program skills: . Organizing and Analyzing Data . Use subtotals . Define and apply advanced filters . Group and outline data . Use data validation . Create and modify list ranges . Add, show, close, edit, merge, and summarize scenarios . Perform data analysis using automated tools . Create PivotTable and PivotChart reports . Use Lookup and Reference functions . Use Database functions . Trace formula precedents, dependents, and errors . Locate invalid data and formulas . Watch and evaluate formulas . Define, modify, and use named ranges . Structure workbooks using XML . Formatting Data and Content . Create and modify custom data formats . Use conditional formatting . Format and resize graphics . Format charts and diagrams . Collaborating . Protect cells, worksheets, and workbooks . Apply workbook security settings . Share workbooks . Merge workbooks . Track, accept, and reject changes to workbooks . Managing Data and Workbooks . Import data to Excel . Export data from Excel . Publish and edit Web worksheets and workbooks . Create and edit templates . Consolidate data . Define and modify workbook properties . Customizing Excel . Customize toolbars and menus . Create, edit, and run macros . Modify Excel default settings
 
Course Prerequisites:
Introduction to PC's
 
 
Next Steps:
MOUS - Master

This outline is subject to change and is used as a reference only.
 
© 2009 Augusta State University - All Rights Reserved