Administrative Professional with Microsoft Office Specialist 2007 Training GES 801 » 480 hours

Upon successful completion of the Administrative Professional with Microsoft Office Specialist 2007 Training Program, you should be able to:

• Determine major business challenges and provide possible solutions
• Set clear business goals and make informed decisions
• Demonstrate effective verbal, nonverbal, and written communication
• Create and deliver business presentations using visuals
• Develop and train staff on effective customer service skills
• Describe types of computers, input and storage devices, and networks commonly found in businesses
• Understand the importance of records management
• Demonstrate efficient meeting management
• Develop a clear career plan and advancement strategies

Upon successful completion of the Microsoft Office Specialist section of the Administrative Professional with Microsoft Office Specialist Program, you should be able to use the Microsoft Office suite of software effectively and knowledgeably.  Each program and the skills you'll learn are listed below.

Microsoft Excel
You'll learn to:

• Create a spreadsheet
• Create formulas with the Function Wizard or manually
• Audit equations and troubleshoot errors
• Analyze data by using Sort, Filter, Subtotal, and PivotTables
• Format spreadsheets, graphs, and lists for printing

Microsoft Word
You'll learn to:

• Create a document
• Format fonts, paragraphs, bullets, and tables
• Use tables for online forms and Web page designs
• Automate mail merges
• Share documents with a workgroup

Microsoft PowerPoint
You'll learn to:

• Create a slideshow
• Format fonts, paragraphs, bullets, and text boxes
• Use custom animation, slide transitions, and effects
• Use graphics, sound, and on-screen navigation
• Prepare a slideshow for live presentations and kiosk demonstrations

Microsoft Outlook
You'll learn to:

• Use e-mail and Contacts, and work with attachments safely
• Organize the Inbox and filter junk mail
• Schedule meetings, recurring appointments, and tasks
• Analyze Outlook data in Microsoft Excel or Access

Microsoft Access
You'll learn to:

• Create tables, forms, and reports
• Use queries to find, filter, update, and calculate
• Create forms that handle data automatically
• Optimize the database for easy navigation and data input