Microsoft Office Specialist(MOS) Certification

Microsoft Office Specialist(MOS) Certification MOS Certification Exams
· Word 2003 Expert
· Excel 2003 Expert
· PowerPoint 2003
· Access 2003


Word 2003 Expert

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
Excel 2003 Expert
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
PowerPoint 2003
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
Access 2003
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