Skip Navigation
If you can't find what you are looking for,
please call us at 703-993-2109.

Home >> Programs >>  Online >> Gatlin >> Admin. Professional
   

GATL 0100: Administrative Professional with Microsoft Office Specialist
Gatlin Education Online Course

Course Description
Features
Topic Highlights
Certificate Requirements
Course Objectives
PDF Brochure
Who Should Attend
Instructors
PC Requirements
FAQ

COURSE DESCRIPTION

This nationally recognized Administrative Professional with Microsoft Office Specialist online training course teaches the skills that you must acquire to be successful as a Microsoft administrative professional. Students will learn and train on the most popular Microsoft Office 2003 programs including Word, Excel, Access, Power Point, and Outlook - plus an optional QuickBooks unit. This on-line program is only offered in partnership with major colleges and universities.

FEATURES

Administrative Professionals are the largest segment of the office workforce!

Over 4.1 million secretaries/administrative assistants are employed in the United States, according to the latest statistics from the U.S. Bureau of Labor. Approximately 300,000 secretaries/administrative professionals are employed in Canada; millions more work in businesses all over the world.

 
Registration
Start at any time, and work at your own pace.

Click here to download the registration form.
Demo

Click here for a demonstration.

Fee

$2,095

Length

240 Hours

CEUs

24 CEUs

Included Materials
The following textbooks and reference materials will be provided by GES:
  • Administrative Assistant's and Secretary's Handbook, 2nd edition
  • Microsoft Office Word Made Easy, 2003
  • Microsoft Office Excel Made Easy, 2003
  • Microsoft Office PowerPoint Made Easy, 2003
  • Microsoft Access Made Easy 2003
  • Microsoft Outlook Made Easy 2003
Contact Info.
  • Online contact form
  • Address:
      George Mason University
    Office of Continuing Professional Education
      4400 University Drive, MS 2G2
      Fairfax, VA 22030
  • Telephone: 703-993-2113
  • Fax: 703-993-2121

  • The Administrative Professional plays an increasingly vital and skilled role in today's (and tomorrow's) office...
    • The administrative professional's job today requires skills in management functions and technology, including: project management, integrated computer software applications, organization and scheduling, Internet/Intranet communications and research, document preparation, storage, and retrieval, with emphasis on electronic record-keeping, customer service, and public relations.
    • Administrative Professionals are handling a wider variety of duties beyond strictly clerical roles-Today's AP often purchase office equipment and supplies, plan meetings and special events, work closely with vendors and suppliers, create presentations and give them as well, interview, orient and supervise other staff, write and edit documents, schedule events and facilities, coordinate direct mailings, maintain multiple schedules and calendars, handle messages and correspondence (with voice mail, e-mail, and regular postal mail), maintain computer files, directories, and databases, and more.
    A typical day for today's administrative assistant can include:
    • Developing a production report using spreadsheet software
    • Preparing charts, slides, and handouts for a management presentation
    • Corresponding via phone, fax, or e-mail with clients all over the world
    • Researching a topic on the Internet
    • Coordinating a videoconference
    • Scheduling an airline flight and purchasing tickets over the Internet
    • Supervising and training a co-worker
    • Effectively representing management at a meeting

    TOPIC HIGHLIGHTS

    Unit 1 - Administrative Professional
    1. Rating Chart (self-analysis)
    2. Training Needs
    3. Career Opportunities
    4. 21st Century Skills
    5. A Professional Image
    6. Ethical Behavior (with interactivity)
    7. Internal Relations
    8. Make-up of Team
    9. External Relationships
    10. Communications
    Unit 2 - Work Environment
    1. Today's Office
    2. Today's Worker Skills
    3. 21st Century Skills
    4. Working in Office Team (w/ interactivity)
    5. Office Security
    6. Virtual Office Workers
    7. Workplace Ethics
    Unit 3 - Time and Task Management
    1. AP Work Area (w/ interactivity)
    2. AP Responsibilities
    3. Time Management (w/ interactivity)
    4. Appointment Scheduling
    5. The Admin Pro and Stress
    Unit 4 - Telecommunications
    1. Equipment and Systems
    2. Special Equipment
    3. Voice Messages
    4. Phone Responsibilities (w/ interactivity)
    5. Incoming Calls
    6. Outgoing Calls
    Unit 5 - Records Management
    1. Records Management Defined
    2. Records Management Practices
    3. Records Retrieval
    4. Archives<
    5. Records Retention<
    6. Retention Schedule
    7. Records Transfer
    8. Records Disposal
    9. ARMA Rules (Assn/Records Managers and Administrators)
    10. Storage Methods (w/ interactivity)
    Unit 6 - Language Usage
    1. Grammar
    2. Language Usage and Style
    3. Common English Usage Problems
    4. Spelling
    5. Pronunciation
    6. Punctuation
    7. Numerals
    8. The Business Letter
    9. Other Written Communications
    10. Forms of Addresses
    11. Legal Documents and Terms
    12. Keyboarding Skills
    13. Word Processing
    14. Multimedia and Presentation Software
    15. Desktop Publishing
    Unit 7 - Microsoft Office Word - Basic
    Section I: MICROSOFT OFFICE - WORD Basic & Intermediate
    1. Introducing Word
    2. Creating and Saving Documents
    3. Working with Text
    4. Formatting Paragraphs
    5. Managing Page Appearance
    6. Introducing Tables and Tabs
    7. Using Templates and Wizards
    8. Using Graphic Effects and Hyperlinks
    9. Proofing and Printing Documents
    Section II: MICROSOFT OFFICE - WORD Advanced
    1. Enhancing Documents with Styles, Columns, and Art
    2. Using Templates and Forms
    3. Mail Merging
    4. Designing Web Pages
    5. Tracking Changes in Documents
    6. Using Outline View
    7. Emailing Messages and Documents
    8. Connecting with Other Office Programs
    Unit 8 - Business Documents and Reports
    1. Written Messages
    2. Writing Characteristics (w/ interactivity)
    3. The Planning Steps
    4. Email and Memos
    5. Letters
    6. Message Checklist
    7. Proofreading Tips
    8. Formatting Guidelines
    9. Reports
    10. Proposal Writing
    11. Collaborative Writing
    Unit 9 - Microsoft Power Point
    1. Creating a Presentation
    2. Working with a Presentation
    3. Printing a Presentation
    4. Adding and Modifying Text
    5. Drawing and Modifying Objects
    6. Inserting Information into PowerPoint
    7. Producing a Slide Show
    8. Creating an Internet Presentation
    Unit 10 - Office Mail
    1. Outing Mail (w/ interactivity)
    2. State Abbreviations (w/ interactivity)
    3. Incoming Mail
    4. Mail Classifications
    5. Electronic Services
    6. Future Mail Trends
    Unit 11 - Microsoft Outlook
    1. Jumping into Your Email
    2. Working with Email
    3. Managing Contacts
    4. Appointments, Meetings, and Events
    5. Taking Charge of Tasks
    6. Managing and Protecting Files
    7. Using Outlook with Other Office Programs
    Unit 12 - Planning Meetings and Conferences
    1. Meeting Elements
    2. Facilitator's Role
    3. Role of Participants
    4. Meeting Types
    5. Role of AP in Meetings (w/ interactivity)
    6. Role of AP in Conferences and Conventions
    Unit 13 - Ergonomics in the Workplace
    1. Ergonomics and You
    2. History of Ergonomics
    3. Ergonomics Today
    4. Ergonomic Environment
    5. Ergonomic Workstation
    6. Posture and Body
    Unit 14 - Financial Management
    1. Bookkeeping and Accounting
    2. Business Taxes
    3. Banking
    4. Special Business and Financial Information for the Small Business
    5. Weights and Measures<
    6. Office Equipment/Computers
    7. Database Management
    Unit 15 - Microsoft Excel
    Section I: MS Excel Basic & Intermediate
    1. Introduction
    2. Setting up a Worksheet
    3. Adding Formulas
    4. Formatting a Worksheet
    5. Filtering and Fiding Information
    6. Organizing and Sorting Data
    7. Working with Multiple Files and Charts
    8. Printing Worksheets and Charts
    Section II: MS Excel Advanced
    1. PivotTables and PivotChart Reports
    2. Distributing Information Online
    3. Sharing Information
    4. Integrating with Microsoft Office Programs
    5. Using Date from Other Sources
    6. Working with Macros
    7. Manipulating and Summarizing Lists
    8. Customizing Charts and Creating Maps
    Unit 16 - Microsoft Access
    1. Database Management
    2. Introducing Access
    3. Using Tables and Sub-forms
    4. Using Filters and Reports
    5. Managing Database Change
    6. Keeping Database Information Reliable
    7. Working with External Data
    8. Using Queries
    9. Form and Report Techniques
    Unit 17 - Leadership and Management
    1. Value of Leadership
    2. Leadership vs. Management
    3. Management Defined
    4. Leadership Qualities
    5. Leadership Tasks
    6. Summary (w/ interactivity)
    Unit 18 - Planning Your Career
    1. Self Assessment
    2. Career Options
    3. Specialty Areas
    4. Certification Areas
    5. Research Careers
    6. Job Application
    7. Resume Planning (w/ interactivity)
    8. Interview Preparation
    9. Job Application
    10. Summary (w/ interactivity
    Unit 19 - QuickBooks (Optional Unit)
    1. The First Time in QB
    2. Setting up Accounting
    3. Entering Historical Data
    4. Managing Accounts and Lists
    5. Invoices and Sales Tax
    6. Paying Bills
    7. Managing Assets and Reports
    8. Paying Employees
    9. Managing Taxes
    10. Online Banking and Budgets

    CERTIFICATE REQUIREMENTS

    A 70% or better must be achieved in order to receive a Certificate of Completion.

    COURSE OBJECTIVES

    Upon successful completion of the Administrative Professional with Microsoft Office Specialist Program, the student should:
    1. Understand and be able to perform the basic administrative skills, tasks and processes, required for employment as an Administrative Professional in a business office environment, including, but not limited to:
      1. Effective Communication and Language Usage
      2. Business Correspondence
      3. Planning Meetings and Travel
      4. Records Management and Mail Handling
      5. Leadership and Management
    2. Understand and be able to perform the basic financial skills, tasks and processes, required for employment as an Administrative Professional in a business office environment, including, but not limited to:
      1. Accounts Payable
      2. Accounts Receivable
      3. Banking
      4. Inventory Control and Ordering
    3. Use the Microsoft Office suite of software office productivity products effectively and knowledgeably. The programs include:
      1. Word (word processing program)
      2. Excel (spreadsheet program)
      3. PowerPoint (presentation software)
      4. Access (database management software)
      5. Outlook (scheduling and email program)

    PDF BROCHURE

    Please click here to download the PDF brochure for the online courses offered by OCPE.

    This brochure and the registration form for this course require Adobe Reader. Click here to download the latest version of Adobe Reader.

    WHO SHOULD ATTEND

    Prerequisites
    There are no specific pre-requisites for the Administrative Professional course. If possible, students should have basic skills or knowledge in keyboarding (typing), using computer programs and the Internet, and English grammar and punctuation. No previous experience is required.

    Target Audience
    The target audience for the Administrative Professional with Microsoft Office Specialist course is anyone who desires to learn the job skills required for working in a business office environment.

    INSTRUCTOR

    Carline Dalgleish has been employed in the business office management profession since 1970. She began in the Medical Records department of the Army/Air Force Hospital in Nuremberg, Germany and has, over the years, performed accounts receivable and business office management services for physicians, clinics, hospitals, as well as the Healthcare Financing Administration (now CMS). She has real-time experience in administrative and financial departments, as well as management experience in business office administration, regulatory compliance, information technology and services. In addition, she has created the curriculum for and instructed accounts receivable and accounts payable educational programs.

    In the early 90's, Carline moved full-time into curriculum development, teaching and management of business and allied health education programs, with special emphasis on business office administration and management.

    Carline is a Certified Medical Assistant - Administrative, a licensed practical nurse, and holds a Bachelor's degree in Business Information Systems. She is currently working on her Master's degree in Leadership and is a part-time George Mason University, OCPE, Gatlin instructor.

    She is a member of the International Association of Administrative Professionals (IAAB), the National Dean's Scholars List, AHIMA, PAHCOM, AAMA, AAPC, CCST, AAMT and AMTIE. She currently owns and operates COUGAR-Ed.net, which specializes in curriculum development and delivery of continuing education products, seminars and services.

    PC REQUIREMENTS

    Computer Requirements

    • IBM-compatible (PC) computer running Windows 2000 or later or Windows XP
      • Microsoft Office 2003 including:
        • Word Excel PowerPoint Outlook
        • Access
    • Adobe Acrobat Reader (free version) If you do not have the Adobe Acrobat Reader, you will be provided the link in the Admin Pro course to download the free reader
    • Flash Player. If you do not have the Flash Player, you will be provided the link in the Admin Pro course to download the player.
    Internet Connectivity
    • Preferred: Cable or DSL Internet access.
    • If your Internet service provider uses only dial-up, a minimum of 56K connection rate is preferred
    FAQ

    1. How do I register for a Gatlin online course?

    Gatlin does not offer courses directly to the public. It offers courses through George Mason University and other colleges and universities. Please contact our office at 703-993-2113 or click here for more information or to register for a course.

    2. How much do Gatlin online courses cost?

    To view the prices for all Gatlin courses that are offered by George Mason University, please click here.

    3. Why do I have to take Gatlin courses through a participating school?

    That is the only way Gatlin Education Services offers its courses. They do not deal directly with the public.

    4. Do I have to travel to register for or to attend a Gatlin online course?

    All Gatlin courses are delivered entirely online, so you do not have to go to a class or travel to a school. Please contact our office at 703-993-2113 or click here for more information or to register for a course.

    5. How long does it take to complete a Gatlin course?

    All of our Gatlin courses are asynchronous. You can start and finish the course at your own pace. Most courses are designed to be completed within 180 days. You may request an extension if you think you will need more time to complete a course. Please contact us at 703-993-2113 or click here if you have any questions or if you would like to register for a course.

    6. Do I have to buy additional materials?

    Please refer to the green Included Materials box located on the upper right hand side of this page. If materials are included in this course, they will be shipped by Gatlin to you via UPS ground service after you have registered for a course.

    7. Can I get financial aid for Gatlin courses?

    George Mason University offers financial assistance through the Sallie Mae Training Loan Program for qualifying students. Call 703-993-2113 for more information. GES also provides a loan opportunity for students (www.collegeloanapplication.com).

    8. What happens when I complete the course?

    If you obtain a final passing grade of 70% or greater in a course, we will award you a George Mason University certificate of completion.

    9. Who will be my instructor?

    Each student is paired up with a George Mason University, OCPE, Gatlin facilitator for one-on-one interaction. The facilitator will be available (by e-mail or by telephone) to answer any questions you may have and to provide feedback on your performance. All of our facilitators are successful working professionals in the fields in which they teach.

    10. What are the system requirements in order to take an online course?

    Please see the "PC requirements" section listed for individual courses.

    11. When can I start the course?

    You can register for a course at any time.

     

    Spacer

     

    Last updated
    Suggestions or comments about this Web site? Please e-mail the webmaster.
    Copyright © George Mason University
    Office of Continuing Professional Education
    4400 University Drive, MS 2G2 · Fairfax, Virginia 22030 · 703-993-2109


    If you can't find what you are looking for, please call us at 703-993-2109.
    George Mason University Home Page Office of Continuing Professional Education Home Page