Administrative Professional with Microsoft Office 2007 Master

See how a Course Works: Intro to Online Learning





Description

Administrative professionals are the largest segment of the office workforce! Over 4.1 million secretaries and administrative assistants are employed in the United States, according to statistics from the U.S. Bureau of Labor. Millions more administrative professionals work in businesses all over the world.

As an administrative professional, you'll play an increasingly vital and skilled role in today's (and tomorrow's) office. Your job can encompass everything from project management to public relations and from staff management to special events.

This unique program will give you the skills you need to be a successful administrative professional, as well as a master of Microsoft's suite of programs. The Microsoft Office 2007 Master program is the only comprehensive, performance-based certification program approved by Microsoft to validate business computer skills using Excel, Word, Power Point, and Outlook. 

Students who complete Microsoft Office certification training earn more (about 12%) than employees who aren't certified. In addition, 82% of the students who become certified report getting a raise upon receiving their certification. The need for Microsoft Office training is vast—it's now a requirement in education, as well as in virtually all business, technical, and professional jobs.

How to Become Microsoft Office 2007 Master Certified
To earn the Microsoft Office 2007 Master certification, you must pass four Microsoft certification exams: Word, Excel, Outlook, and PowerPoint 2007. 

Textbooks are included for this course, as well as a free 180-day trial of Microsoft Office 2007 Professional software.

Outline

  1. Administrative Professional
    1. The Dynamic Workplace
      1. The Workplace—Constantly Changing
      2. Workplace Team and Environment
      3. The Virtual Workplace
    2. Workforce Behaviors
      1. Your Professional Image
      2. Anger, Stress, and Time Management
      3. Ethical Theories and Behaviors
    3. Communication Essentials
      1. Written Communications
      2. Verbal Communication and Presentations
      3. Customer Service
    4. Technology Basics
      1. Technology Update
      2. Workplace Mail and Copying
      3. Telecommunications—Technology and Etiquette
    5. Records and Financial Management
      1. Managing Records
      2. Personal Finance
    6. Meetings and Travel
      1. Event Planning
      2. Travel Arrangements
    7. Career Advancement
      1. Job Search and Advancement
      2. Leadership
  2. Microsoft Office 2007 Master
  1. Getting Started: Beginning Word
  2. Mice and Men: Beginning Word
  3. Save It for a Rainy Day: Beginning Excel
  4. Be My Neighbor: Intermediate Word
  5. Charlotte’s Web site: Intermediate Word
  6. The Paperless Office: Outlook
  7. What Time Is It? Intermediate Excel
  8. Sound Advice: Intermediate Excel
  9. Get Smart: Advanced Word and Excel
  10. The Good, The Bad, and the Really Ugly: Advanced Word and Excel
  11. Reach for the Stars: Beginning PowerPoint
  12. Show Me: Advanced PowerPoint

Additional Info

Languages
English
Course Length
240.00 hours
Duration of Access

90 days
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
Requirements/Materials Included

This course cannot be taken on a Mac computer. You can use Windows XP or Windows Vista  operating systems to complete this program. Please note that while you may use Windows Vista, its functions are not taught as part of this program.

Hardware requirements:

  • IBM-compatible (PC) computer
  • Processor: 1 GHz 32-bit (x86) or 64-bit (x64)
  • RAM: 1 GB of system memory
  • Hard Drive: 40 GB with at least 15 GB of available space
  • Video: Support for DirectX 9 graphics with WDDM Driver
  • 128 MB of graphics memory (needs more) 
  • Pixel Shader 2.0 in hardware
  • 32 bits per pixel
  • DVD-ROM drive
  • Audio output

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.
 
You'll need Internet access. If your Internet service provider uses only dial-up, a minimum of 56K connection rate is recommended; however, high-speed access (cable or DSL) is preferred.

Books included with this course:

  • The Beginning Guide to Microsoft Word 2007 
  • The Intermediate Guide to Microsoft Word 2007
  • The Advanced Guide to Microsoft Word 2007
  • The Beginning Guide to Microsoft Excel 2007
  • The Intermediate Guide to Microsoft Excel 2007
  • The Advanced Guide to Microsoft Excel 2007
  • The Complete Guide to Microsoft Outlook 2007
  • The Complete Guide to Microsoft PowerPoint 2007

This course includes a 180-day FREE trial of Microsoft Office 2007 Professional and Microsoft Office 2007 CourseNotes from Course Technology.

Certification

Upon successful completion of this course, you'll be able to:

  • Determine how to effectively set goals and make administrative decisions
  • Understand business etiquette
  • Communicate effectively, both verbally and in writing
  • Engage in collaborative planning, communication, and research
  • Create and format professional business documents, including mail merges, Web pages, and interactive forms
  • Create and edit formulas, audit equations, and present information in charts and tables
  • Create and edit Outlook objects, such as e-mail, meetings, tasks, and contacts
  • Create and modify slide presentations, including editing graphics, formatting text and text boxes, and animating objects and transitions

This program will also teach you the exam objectives for the following certification tests:

Exam 77-601: Microsoft ® Word 2007
Exam 77-602: Microsoft ® Excel 2007
Exam 77-603: Microsoft ® PowerPoint 2007
Exam 77-604: Microsoft ® Outlook 2007