Description

The Microsoft Certified Application Specialist program is the only comprehensive, performance-based certification program approved by Microsoft to validate business computer skills using Microsoft Office 2007: Excel, Word, Power Point, Access, and Outlook.

The Microsoft Excel 2007 Certification Training Program is part of the Microsoft Business Certification program: Microsoft Certified Application Specialist (MCAS). MCAS certification is the globally recognized standard for validating expertise with the Microsoft Office 2007 suite.

Certification can help you differentiate yourself in today's competitive job market, broaden your employment opportunities, and garner greater earning potential. Certification can also help you advance in your current job. Mastering more skills increases your effectiveness and efficiency. Research indicates that Office-certified professionals are more confident and productive with Microsoft Office programs.

Many employers consider certification when determining who to hire. Certification can be the difference in whether or not you get a job or get a better job. Students who complete Microsoft Office Specialist or MCAS certification training earn more (about 12% more) than employees who aren’t certified. In addition, 82% of the students who get certified report getting a bonus upon receiving their certification.

Microsoft Approved Courseware
When you use Approved Courseware for the Microsoft Certified Application Specialist and Microsoft Office Specialist programs to help prepare for Microsoft Office certification exams, you know you're using the very best study materials available.

In order for courseware to receive the Approved Courseware distinction, it must go through a rigorous review to ensure it meets the skill standards set forth by Microsoft. This is the first online Microsoft Excel 2007 certification training course approved by Microsoft.

By completing the Microsoft Excel 2007 program, you'll:

• Understand the Autofill function
• Learn how to merge and center cells
• Know how to link worksheets, consolidate data, and calculate revenue from several worksheets
• Understand how to use the PivotTable to automatically format and analyze data
• Know how to filter and outline data
• Be able to use the VLookup function

Outline

1. Beginning Guide to Microsoft Excel 2007
   1. Make a Rainfall Graph
   2. Create a Chart
   3. Create a Price Sheet
   4. Calculate Revenue
2. Intermediate Guide to Microsoft Excel 2007
   1. Tables and Print Options
   2. Create a Timesheet
   3. Calculate Revenue
3. Advanced Guide to Microsoft Excel 2007
   1. Cell References
   2. Create Filters and Subtotals
   3. Create a PivotTable

Demo

Additional Info

Languages

English

Course Length

35.00 hours

Duration of Access

All of our programs are self-paced and open-enrollment. You can start and finish the program at your own pace. When you register for a program, you’re given 90 days (three months) to complete it. If you need more time, three-month extensions are available.

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

To enroll in the Microsoft Excel 2007 Online Training Program, you should have basic computer skills, be comfortable using an Internet browser and selecting commands from a menu or toolbar, be proficient in file management (save, print, and back-up files), and be able to select, edit, and format text.

This program is for you if you're an office worker, manager, entrepreneur, or other professional who wants to start using advanced Microsoft Excel skills immediately. This program is also suitable for you if you're looking to learn about this software and expand your job possibilities.

Requirements/Materials Included

You'll need the following Microsoft products already installed on your computer in order to take this program: Windows XP or Windows Vista and Microsoft Excel 2007.

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

Internet connectivity:  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.

This program cannot be taken from a Mac computer.

Books included with this program:

• The Beginning Guide to Microsoft Excel 2007
• The Intermediate Guide to Microsoft Excel 2007
• The Advanced Guide to Microsoft Word Excel 2007

This program also includes: Microsoft Office Excel 2007 CourseNotes from Course Technology.