You are here : Home / Class Information / Special Programs / M.O.U.S. / Proficiency Requirements

M.O.U.S.

The table below lists the skill sets and proficiencies demonstrated by individuals identified as Microsoft Word Specialists.

Skill Sets	Skill Standards

Creating Content	Insert and edit text, symbols and special characters Insert frequently used and pre-defined text Navigate to specific content Insert, position and size graphics Create and modify diagrams and charts Locate, select and insert supporting information
Organizing Content	Insert and modify tables Create bulleted lists, numbered lists and outlines Insert and modify hyperlinks
Formatting Content	Format text Format paragraphs Apply and format columns Insert and modify content in headers and footers Modify document layout and page setup
Collaborating	Circulate documents for review Compare and merge documents Insert, view and edit comments Track, accept and reject proposed changes
Formatting and Managing Documents	Create new documents using templates Review and modify document properties Organize documents using file folders Save documents in appropriate formats for different users Print documents, envelopes and labels Preview documents and web pages Change and organize document views and windows

The table below lists the skill sets and proficiencies demonstrated by individuals identified as Microsoft Word Experts.

Skill Sets	Skill Standards

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

The table below lists the skill sets and proficiencies demonstrated by individuals identified as Microsoft Excel Specialists.

Skill Sets	Skill Standards

Creating Data and Content	Enter and edit cell content Navigate to specific cell content Locate, select and insert supporting information Insert, position and size graphics
Analyzing Data	Filter lists using Autofilter Sort lists Insert and modify formulas Use statistical, date and time, financial and logical functions Create, modify and position diagrams and charts based on worksheet data
Formatting Data and Content	Apply and modify cell formats Apply and modify cell styles Modify row and column formats Format worksheets
Collaborating	Insert, view and edit comments
Managing Workbooks	Create new workbooks from templates Insert, delete and move cells Create and modify hyperlinks Organize worksheets Preview data in other views Customize Window layout Setup pages for printing Print data Organize workbooks using file folders Save data in appropriate formats for different uses

The table below lists the skill sets and proficiencies demonstrated by individuals identified as Microsoft Excel Experts.

Skill Sets	Skill Standards

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

The table below lists the skill sets and proficiencies demonstrated by individuals identified as Microsoft Access Specialists.

Skill Sets	Skill Standards

Structuring Databases	Create Access databases Create and modify tables Define and modify field types Modify field properties Create and modify one-to-many relationships Enforce referential integrity Create and modify queries Create forms Add and modify form controls and properties Create reports Add and modify report control properties Create a data access page
Entering Data	Enter, edit and delete records Find and move among records Import data to Access
Organizing Data	Create and modify calculated fields and aggregate functions Modify form layout Modify report layout and page setup Format datasheets Sort records Filter records
Managing Databases	Identify object dependencies View objects and object data in other views Print database objects and data Export data from Access Back up a database Compact and repair databases

The table below lists the skill sets and proficiencies demonstrated by individuals identified as Microsoft PowerPoint Specialists.

Skill Sets	Skill Standards

Creating Content	Create new presentations from templates Insert and edit text-based content Insert tables, charts and diagrams Insert pictures, shapes and graphics Insert objects
Formatting Content	Format text-based content Format pictures, shapes and graphics Format slides Apply animation schemes Apply slide transitions Customize slide templates Work with masters
Collaborating	Track, accept and reject changes in a presentation Add, edit and delete comments in a presentation Compare and merge presentations
Managing and Delivering Presentations	Organize a presentation Set up slide shows for delivery Rehearse timing Deliver presentations Prepare presentations for remote delivery Save and publish presentations Print slides, outlines, handouts and speaker notes Export a presentation to another Microsoft Office program

The table below lists the skill sets and proficiencies demonstrated by individuals identified as Microsoft Outlook Specialists.

Skill Sets	Skill Standards

Messaging	Organizing Attach files to items Create and modify a personal signature for messages Modify e-mail message settings and delivery options Create and edit contacts Accept, decline and delegate tasks
Scheduling	Create and modify appointments, meetings and events Update, cancel and respond to meeting requests Customize calendar settings Create, modify and assign tasks
Organizing	Create and modify distribution lists Link contacts to other items Create and modify notes Organize items Organize items using folders Search for items Save items in different file formats Assign items to categories Preview and print items