Microsoft Office Courses
The Microsoft Office Specialist certification program provides computer program literacy, measures proficiency, and identifies opportunities for enhancement of skills. Successful candidates receive a Microsoft Office Specialist certification credential that sets them apart from their peers in the competitive job market.
The certificate is a valuable credential that is recognized worldwide as proof that an individual has the desktop computing skills needed to work productively and efficiently.
By encouraging individuals to develop advanced skills with Microsoft business desktop software programs, the Microsoft Office Specialist certification program is helping to fill the demand for qualified, knowledgeable people in the workplace. Microsoft Office Specialist certification also helps satisfy an organization's need for a qualitative assessment of employee skills.
Microsoft Word 2003
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 tracked 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 Microsoft Word |
| • |
Create, edit, and run macros |
| • |
Customize menus and toolbars |
| • |
Modify Word default settings |
|
Microsoft Excel 2003
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 |
|
Microsoft 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 |
|
Microsoft Access 2003
Structuring Databases |
| • |
Create Microsoft 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 |
|
Microsoft 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 |
|
|
 |
|
