Microsoft Office Specialist 2003

Word 2003

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 comment
• 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 uses
• Print documents, envelopes and labels
• Preview documents and Web pages
• Change and organize document views and windows

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
• Insert objects

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 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

Outlook 2003

Messaging

• Originate and respond to e-mail and instant messages
• 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

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 formattin
• 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

Microsoft Master

• Word 2003 Expert
• Excel® 2003 Expert
• PowerPoint® 2003
• Outlook® 2003
  OR
  Access® 2003