Course Title: Administrative Professional with Microsoft Office Specialist

School: At a college near you (click "Enroll Now" to see location). [Learn More]
Hours required: 240  
Price: $1,995  
Length course offered: 6 Months   
Instructor: Elizabeth Ann Nofs [Bio]

Description:

This nationally recognized Administrative Professional with Microsoft Office Specialist online course and training program teaches the skills that students must acquire to be successful as an Administrative Professional using the Microsoft Office suite of programs.

Students receive training on the most popular Microsoft Office 2003 programs including Word, Excel, Access, Power Point, and Outlook. An introduction to QuickBooks is also provided. This online certificate program is offered in partnership with major colleges, universities, and other accredited education providers.

"The program was very well organized. I could navigate through all of the classes without any problems. My program advisor, Sarah Karr, was excellent in helping me to achieve my goals. I am ready to take another program!" - M.B., Heartland Community College (Fall 2006)

Goals:

Upon successful completion of the Administrative Professional section of the Administrative Professional with Microsoft Office Specialist Program, the student should:

• Identify changes that are occurring in the workplace. • Define common types of business organizational structures. • Determine major challenges confronting both management and administrative professionals. • Explain crucial skills and qualities for an administrative professional. • Determine how an effective administrative professional sets goals and makes decisions. • Identify virtual workplace considerations including personal characteristics, virtual workforce skills, and challenges.

• Describe an effective work environment for virtual workers. • Describe the personal characteristics and work characteristics that contribute to a positive professional image. • Identify the components of a professional appearance. • Understand the conventions of business etiquette. • Determine the effects of stress in the • Compose written communications. • Apply characteristics of effective correspondence.

• Apply appropriate planning and writing guidelines. • Engage in collaborative writing and research. • Identify elements of effective verbal communication. • Demonstrate effective verbal and nonverbal communication. • Explain how effective communication can help resolve conflicts. • Prepare and deliver a verbal presentation using visuals. • Describe the importance of effective customer service to an organization.

• Identify characteristics of companies that value customer service. • Develop effective customer service skills. • Describe types of computers, input devices, storage devices, and networks commonly found in businesses. • Describe the function of applications software and systems software. • Understand threats and solutions related to computer security and privacy. • Identify telecommunications messaging services and the etiquette associated with their use.

• Understand the importance of records management. • Describe the considerations in managing paper and electronic records. • Identify the factors associated with records retention, transfer, and disposal. • Describe the characteristics of effective meetings and the wide variety of meeting formats. • Implement organizational travel procedures. • Understand your skills, interests, and abilities as they relate to a career. • Determine a job search plan.

• Identify sources of job information and research organizations of interest. • Prepare a resume and letter of application. • Demonstrate effective interview skills. • Develop job advancement strategies. • Define leadership and describe leadership traits. • Define management and describe the functions of management. • Determine the administrative professional's job responsibilities. • Discuss the benefits of a healthy lifestyle, including proper diet and physical exercise.

Upon successful completion of the Microsoft Office Specialist section of the Administrative Professional with Microsoft Office Specialist Program, the student should:

Microsoft Excel

Description: The Complete Guide to Excel teaches users how to create spreadsheets from simple checkbooks to price sheets, market forecast and scenarios.

Objectives: On completion, users will be able to: • Create a spreadsheet. • Create formulas with the Function Wizard or manually. • Audit equations and troubleshoot errors. • Analyze data by Sort, Filter, Subtotal, and PivotTables. • Format spreadsheets, graphs and lists for printing

Length: There are three levels of Excel: Beginning, Intermediate and Advanced. Each lesson has 3 or 4 modules. Each module can be completed in 30 minutes or less.

Microsoft Word

Description: The Complete Guide to Word teaches users how to create documents from simple letterheads and envelopes to custom web pages.

Objectives: On completion, users will be able to: • Create a document. • Format fonts, paragraphs, bullets and tables • Use tables for on-line forms and webpage designs. • Automate mail merges • Share documents with a workgroup.

Length: There are three levels of Word: Beginning, Intermediate and Advanced. Each lesson has 3 or 4 modules. Each module can be completed in 30 minutes or less.

Microsoft PowerPoint

Description: The Complete Guide to PowerPoint offers examples of colorful, animated slideshows.

Objectives: On completion, users will be able 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 slide show for live presentations and kiosk demonstrations.

Length: There are two levels of PowerPoint: Beginning and Advanced. Each lesson has 3 or 4 modules. A module can be completed in 30 minutes or less.

Microsoft Outlook

Description: The Complete Guide to Outlook teaches users how to set up and use email, an electronic calendar, contacts, tasks, and journal entries effectively. Security, administration and backups are also demonstrated.

Objectives: On completion, users will be able to: • Use email, 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.

Length: There are three levels of Outlook: Email, Calendar, and Administration. Each lesson has 3 or 4 modules. A module can be completed in 30 minutes or less.

Microsoft Access

Description: The Complete Guide to Access teaches users how to create database tables, forms, queries and reports. The focus is on optimizing the databases for efficient data entry and generating comprehensive reports.

Course Objectives: On completion, users will be able 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.

Length: There are three levels of Access: Beginning, Intermediate and Advanced. Each lesson has 5 modules. Each module can be completed in 30 minutes or less.

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

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 Computer Mama! She is the designer and developer of the Complete Computer Guide series.

The teaching methodology incorporated into the Guide 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 is 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.

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 BS in Secondary English at Eastern Michigan University in Ypsilanti, Michigan and is certified to teach English and History at the high school level.

She is 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 hardboiled mystery fiction. Her protagonist, the 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.