Description:

Our Administrative Professional with Microsoft Certified Application Specialist (MCAS) training will not only provide you with Administrative Professional training but will also prepare you to become a Microsoft Certified Application Specialist The MCAS training will teach how to use the Microsoft Office 2007 suite of programs (Word, Excel, Access, Outlook, and PowerPoint) as well as the Vista operating system.

Goals:

Upon successful completion of the Administrative Professional with Microsoft Certified Application Specialist 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

• 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

• 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

• 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

• 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
   

• 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

Grading System:

Confirmation of Completion awarded with passing score.

School Description:

Offered in connection with a college or university near you, our self-paced, online career courses are designed to launch you into your dream job.

Begin your course anytime. Textbooks are included, and you will have access to student support via phone, email, and chat 24 hours a day.

Click "Enroll Now" to find the partner school for the career course you want to take.

Instructor Bio: Elizabeth Ann Nofs

Clair Dickson teaches alternative and adult high school completion courses, primarily in English and history. She also is a facilitator in her school's independent learning classroom, where students work either from books or online courses. Clair earned her B.S. in secondary English at Eastern Michigan University in Ypsilanti and is certified to teach English and history at the high school level. She's also currently working on a graduate certificate in educational media and technology through Eastern Michigan University's online distance learning program. She has earned Microsoft Certification for Word 2003 at the expert level.

In her spare time, Clair is a writer of hard-boiled mystery fiction. Her protagonist, female private investigator Bo Fexler, is a smart, sexy, modern woman. Clair has had more than fifty short stories published and is seeking representation for her first novel.

Elizabeth Ann Nofs is co-founder and the creative director for Comma Project, LLC. Her research on how men and women approach computer learning provided the foundation for the Comma Method of training, as well as The Computer Mama Show, a pilot produced with WFUM/TV28 (PBS), Flint, Michigan.

Elizabeth is the designer and developer of the Complete Computer Guide series. The teaching methodology incorporated into the guide series is a breakthrough in producing gender-balanced training with outstanding student completion, retention, and mastery rates.

Elizabeth has been a network administrator for many businesses as well as a Microsoft course instructor. Elizabeth has taught several thousand men and women from government, manufacturing, small business, and education. She has developed Microsoft Office solutions and databases since 1993.

She's the author of several books, including: The Computer Mama Guide to Computers (2001), The Comma Method of Computer Training (2003), The Comma Teachers Edition (2003), and The Complete Computer Guide (2005).

Elizabeth received her B.A. degree in biology from the University of Michigan, Ann Arbor.