Description

This online training program will provide you with administrative professional training and will teach you how to use the Microsoft Office 2003 suite of programs.

Administrative professionals are handling a wider variety of duties beyond strictly clerical roles. Today's administrative professional often plans meetings and special events; works closely with vendors and suppliers; creates and gives presentations; interviews, orients, and supervises other staff; writes and edits documents; and more. This program will prepare you for all of the varied tasks you might encounter in a typical day.

Note: Students should have these Microsoft products already loaded on your computer in order to take this course: Word 2003, Excel 2003, Access 2003, Outlook 2003, and PowerPoint 2003.

Upon registering, you're given an initial six months to complete the program. Should you need more time, you may request a six-month extension at no additional charge.

Upon successful completion of the Administrative Professional section this program, you'll 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 skills
• 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 this program, you should be able to use the Microsoft Office 2003 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 mai
• 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

Outline

1. Administrative Professional
2. The Dynamic Workplace
   1. The Workplace—Constantly Changing
   2. Workplace Team and Environment
   3. The Virtual Workplace
3. Workforce Behaviors
   1. Your Professional Image
   2. Anger, Stress, and Time Management
   3. Ethical Theories and Behaviors
4. Communication Essentials
   1. Written Communications
   2. Verbal Communication and Presentations
   3. Customer Service
5. Technology Basics
   1. Technology Update
   2. Workplace Mail and Copying
   3. Telecommunications—Technology and Etiquette
6. Records and Financial Management
   1. Managing Records
   2. Personal Finance
7. Meetings and Travel
   1. Event Planning
   2. Travel Arrangements
8. Career Advancement
   1. Job Search and Advancement
   2. Leadership
9. Microsoft Certified Application Specialist Units:
10. Beginning Windows
    1. Format Text and Use Commands
    2. Beginning Hardware Troubleshooting
    3. File Management and Administration Features and Procedures
11. Word
    1. Beginning
       1. Editing Functions
       2. Insert and Resize Pictures
       3. Time-stamp Documents
    2. Intermediate
       1. Create and Format Tables
       2. Use Mail Merge
       3. Save as Web Page
    3. Advanced
       1. Create and Modify Forms
       2. Protect the Document
12. Excel
    1. Beginning
       1. Insert and Delete Rows and Columns
       2. Apply Number Format (Currency and Percent)
       3. Use Functions: Average and IF
    2. Intermediate
       1. Worksheets
       2. Absolute and Relative References
       3. Auditing Tool Bar
    3. Advanced
       1. Pivot tables
       2. Online Form With Drop-down Lists
       3. VLookup Function
13. PowerPoint
    1. Beginning
       1. Create a Presentation From a Template or Wizard
       2. Work With Graphics and Text Boxes
       3. Animation Effects
    2. Advanced
       1. Sound Effects
       2. Import Slides From Other Programs
14. Access
    1. Beginning
       1. Create Queries
       2. Use and Design Tables
       3. Write and Test Update Queries
    2. Intermediate
       1. Create Forms With Subforms
       2. Use Criteria and Parameters
       3. Sorting and Grouping
    3. Advanced
       1. Automate Data Entry
       2. Create Mail Merge
       3. Optimize a Database for Multiple Users
15. Outlook
    1. Use Mail Features
    2. Create a Distribution List
    3. Work With Attachments
    4. Archive Messages
    5. Handle Junk Mail

Demo

Click here to view a demostration of the Admisintrative Professional section of this program http://www.gatlineducation.com/demo/adminpro/adpro08_m01.html
Click here to view a demonstration of the Microsoft Office Specialist section of the program.

Additional Info

Languages

English

Course Length

240.00 hours

Duration of Access

6 months

Instructor

Clair Dickinson earned her B.S. in secondary English at Eastern Michigan University in Ypsilanti, Michigan, and is certified to teach English and history at the high school level. She also met all of the standards for teaching with technology as outlined by COATT (Consortium for Outstanding Achievement in Teaching with Technology.) Clair is considered highly qualified to teach computer courses, including Microsoft Office 2003 and 2007, Windows XP, and Windows Vista.

Clair is currently working on a Master's degree in educational media and technology through Eastern Michigan University's online distance learning program. The program explores ways to infuse technology into the learning experience so that learning is interactive.

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.

Prerequisites/Audience

There are no specific prerequisites to take this program, but students should have basic skills or knowledge in keyboarding (typing), using computer programs and the Internet, and a good command of English grammar and punctuation. No previous experience is required.

This course is for you if you want to learn the job skills required for working in a business office environment.

Requirements/Materials Included

The following textbooks and reference materials will be provided for this program:

• Procedures & Theory for Administrative Professionals, 6th Edition
• Beginning Guide to Microsoft Word
• Intermediate Guide to Microsoft Word
• Advanced Guide to Microsoft Word
• Beginning Guide to Microsoft Excel
• Intermediate Guide to Microsoft Excel
• Advanced Guide to Microsoft Excel
• Beginning Guide to Microsoft Access
• Intermediate Guide to Microsoft Access
• Advanced Guide to Microsoft Access
• Complete Guide to Microsoft PowerPoint
• Complete Guide to Microsoft Outlook

Computer Requirements
IBM-compatible (PC) computer running Windows 2000 Windows XP

Microsoft Office 2003, including:

• Word
• Excel
• PowerPoint
• Outlook
• Access

These programs are not provided; the software should already be installed on your computer before you begin this online training program.

Adobe Flash Player and Adobe Acrobat Reader are required for this course.
Click here to download the Acrobat Reader.
Click here to download the Flash Player.

Internet Connectivity
Preferred: Cable or DSL Internet access. If your Internet service provider offers only dial-up, a minimum of 56K connection rate is preferred.

This course cannot be taken from a Mac computer