Administrative Professional with Microsoft Office Specialist

Image for Administrative Professional with Microsoft Office Specialist

Administrative Professional Certification from Gatlin International is Your Key to a Brighter Future

Register for a FREE Course: Intro to Online Learning





Description

The Administrative Professional Certification course from Gatlin International provides Administrative Professionals with the training they need to succeed in business. Our Administrative Professional Certification course includes Microsoft Business Certification training and is offered via state of the art, Web-based curricula that prepares students handle the highly technical demands of today&39;s business environment. Microsoft Office has become the default Office productivity suite in all areas of business and the Administrative Professional who has attained Microsoft certification has a distinct advantage over non-certified workers when being considered for employment and / or promotions. Administrative Professionals comprise are largest segment of the workforce in all areas of government and commerce!

A recent study found that over 4.1 million secretaries and administrative professionals were employed in the United States. In Canada, the number of secretaries and administrative professionals was approximately 300,000 and millions more are employed in businesses worldwide.

Administrative Professionals play an increasingly crucial role in business and the demand for Microsoft Business Certification has never been higher.

  • The Administrative Professional's job requires skills in management functions and technology that has lead to a huge demand for Microsoft Office certification training. Using Microsoft Office, the Administrative Professional is charged with a wide variety of responsibilities 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 with Microsoft Office Certification may also be charged with purchasing office equipment and supplies, planning meetings and special events, working closely with various vendors and suppliers, creating and gives presentations, interviews, orients and supervises other staff, writes and edits documents, scheduling corporate events, creating direct mailings, maintaining multiple schedules and calendars, handling corporate correspondence including voice mail, e-mail, and "snail mail", maintaining computer files, directories, and databases using Microsoft Office and more.

Gatlin International&39;s Administrative Professional certification with MOS course is designed to provide students with the training they need to acquire the Microsoft Business Certificate and gain the vital skills that will provide them with a competitive edge in the workforce. Our Microsoft Business Certification course gives students the skills needed to become successful, productive administrative professionals as well as providing them with training on the Microsoft Office Suite of programs with optional QuickBooks training.

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 in our Microsoft Office Certificate training course, you will receive an initial six month period in which to complete the program. Should you find that you need additional time in which to complete the Microsoft Business Certification training, you may request an additional 6-month extension at no extra charge.

Course Objectives

Upon successful completion of the Administrative Professional certification with Microsoft Office Specialist Programme, the student should:
  • 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:

    • Effective Communication and Language Usage
    • Business Correspondence
    • Planning Meetings and Travel
    • Records Management and Mail Handling
    • Leadership and Management
  • 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:
    • Accounts Payable
    • Accounts Receivable
    • Banking
    • Inventory Control and Ordering

  • Use the Microsoft Office suite of software office productivity products effectively and knowledgeably. The programs include:

    • Word (word processing program)
    • Excel (spreadsheet program)
    • PowerPoint (presentation software)
    • Access (database management software)
    • Outlook (scheduling and email program)

Outline

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
  1. 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

  2. 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
  1. 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

  2. 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

Demo

Click here to view a demo of this course.  Click BACK button after viewing demo.

Additional Info

Languages
English
Course Length
240.00 hours
Duration of Access
6 months
Instructor
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.
Prerequisites/Audience
Prerequisites
There are no specific pre-requisites for the Administrative Professional certification wiht Microsoft Office 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.
Requirements/Materials Included

The following textbooks and reference materials will be provided by Gatlin International:

Administrative Assistant's and Secretary's Handbook, 2nd 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 or later or Windows XP

  • Microsoft Office 2003 including (students are required to have the following, but are not provided with the course):
    • 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.
    This course cannot be taken from a Mac computer.

Provider Locator

Country: United Kingdom
  • Amaacon Centre for Learning and Training Apply
  • Flowers Institute of Technology and ManagementLondon Apply
  • SMARTlab Digital MediaLondon Apply
  • Solvebrand Apply
  • Tendering for Contracts Training LtdSurrey Apply