GET IN THE LEAD - get certified today! Experience the benefits of classroom learning - anytime, anywhere! QuickCert's expert instruction and multi-media courses are to get you certified - or your money back! Read why successful professionals choose QuickCert >

 

The Microsoft MCAS Training Package from QuickCert include expert instructor-led training modules with customized presentations, practice exam simulators and learning supplements for an all-inclusive training program that provides all the benefits of classroom training at your own pace.

QuickCert's MCAS 2007 Training Package includes the following exams:

• Microsoft Word 2007
• Microsoft Excel 2007
• Microsoft Access 2007
• Microsoft PowerPoint 2007
• Microsoft Outlook 2007

The Microsoft Certified Application Specialist (MCAS) credential, part of the Microsoft Business Certification program, identifies specific skills covering the most in-demand 2007 Microsoft Office system products—Microsoft Office Word 2007, Excel 2007, PowerPoint 2007, Access 2007, and Outlook 2007—as well as the Windows Vista operating system. The MCAS certification is replacing the Microsoft Office Specialist or MOS certification for the Office 2007 Suite.

QuickCert's Office 2007 MCAS Certification training courses prepare students for the MCAS exams by teaching greater skill mastery in each of the individual Microsoft Office 2007 programs. Candidates must pass one or more certification exams in order to earn the MCAS credential.  The MCAS exams provide a valid and reliable measure of technical proficiency and expertise in Microsoft Office 2007 or Windows Vista by evaluating the ability to use the advanced features in the products to solve real-world business problems.

QuickCert offers individual MCAS certification training courses for Access 2007, Excel 2007, Outlook 2007, PowerPoint 2007 and Word 2007.  As a Microsoft Certified Partner, you can be certain that QuickCert's comprehensive MCAS training program will provide you with all the tools necessary to successfully prepare for your MCAS certification exam(s). We guarantee it!

Click on one of the tabs above to learn more about our course curriculum or QuickCert product features, or to learn more about a specific exam, click on a course number below.

Not sure what course is right for you?
Contact one of our Career Advisors at 888.840.2378 for assistance.

Your QuickCert MOS: Microsoft Office Specialist -
Windows 2003 Course Training Package Includes:

Delivery Format	Instructor Led Modules	Practice Exam Simulator	Exam Pass Guarantee
DVDs or online

Exam Pass Guarantee - Learn More

Free Product Upgrades

Toll Free Educational Support

Compatibility with:
98 | 2000 | ME | XP | 2003| Vista | Windows 7 | Windows 8

 

Hear What Our Customers Are Saying...

“I’m 100% satisfied with QuickCert’s training program. I love that it’s broken into manageable sections.   This is an all-inclusive training solution… they give you the manuals, the lectures broken into short segments, and practice tests that really mirror the actual tests I’ve taken. I plan to renew my membership!!”

— Karen S., Network Administrator, Calabasas, California

Questions?  Contact one of our Career Advisors at 888.840.2378 for assistance or email sales@quickcert.com.

MCAS Certification Training Course: Microsoft Certified Application Specialist- Office 2007 Course Curriculum:

Word 2007

 

The Basic Document

Editing a Document
Formatting Text
Formatting Paragraphs
Adding Tables
Controlling Page Appearance
Proofing a Document
Format Document Text
Format a Paragraph
Create a New Style
Insert or Create a Table
Change the Page Appearance

Managing Lists

Customizing Tables and Charts
Customized Formatting
Automating Data Entry
Controlling Text Flow
Drawing
Performing Mail Merges
Automating Common Tasks
Sort and Format a List
Customize a Table
Create Themes and Templates
Create and Use Building Blocks
Change the Document Layout
Use the Mail Merge Wizard

Word & Other Programs

Collaborating on Documents
Versioning
Reference Marks & Notes
Working in Long Documents
Securing a Document
Creating Forms
Using XML in Word
Creating Web Pages
Link or Embed Content
Compare and Merge Documents
Reference Marks and Notes
Create a Table of Contents
Secure a Word Document

Course Summary

 

 

Excel 2007

 

New Features

Starting in Excel
Basic Navigation
Working with Data
Formulas and Functions
Formatting Data
Working with Worksheets
Printing
Level Summary
Use AutoSum and AutoFill
Use the Vlookup Function
Use Themes, Styles and Formats
Use Table Styles
Insert Cells, Rows and Columns
Cut, Copy and Paste Cells
Manage Worksheets
Adjust Page Layout

Templates

Sorting and Filtering
Navigating in Excel
Working with Comments
Using Name Box
Controlling and Validating Data Entry
Controlling What You See
Using Drawing Tools
Charting
Level Summary
Create a Hyperlink
Use AutoFilter
Sort Data in a Range or Table
Use the Subtotal Command
Use Advanced Filter
Create a Custom List
Use the Name Box and Go To
Add, Edit, and Delete Comments

Advanced Data Tools

Advanced Formula and Function Tools
Protecting and Reviewing Your Work
Merging and Consolidating
Working with External Data
Macros
XML
Trusting and Privacy in 2007
Excel Options
Level Summary
Use Scenarios
Audit a Formula
Use a PivotTable Report
Consolidate Data
Track and Review Changes
Use Goal Seek
Validate Data
Use Conditional Formatting

Summary

 

 

PowerPoint 2007

 

Starting in PowerPoint

Beginning a Presentation
Formatting Text
Formatting Paragraphs
Preparing to Deliver
Format Slide Text
Create a Presentation
Change a Placeholder
Create and Print Handouts

Adding Tables

Charting in PowerPoint
Inserting Multimedia Objects
Working with AutoShapes
Add and Customize a Table
Insert Graphics in Slides

Powerpoint Masters

Special Effects
Delivering a Presentation
Collaborating in PowerPoint
Securing and Distributing
Create and Modify Masters
Apply Animation Effects
Deliver a Custom Slide Show
Use Comments and Markup

 

Outlook 2007

 

Using Outlook

Application Window
Messages
Appointments
Contacts
Tasks
Moving, Copying, and Deleting Items
Printing and Finding Items
Customize the Navigation Pane
Use the To-Do Bar
Create an Email Message
Use the Reading Pane
Attach a File to a Message
Open and Preview Attachments
Create a New Contact
Add a Contact from a Message

Advanced Management

Message Settings
Task Management
Item Organization
Assign Categories to Contacts
Apply a Flag to Mail Items
Customize a Message View
Find a Message using Search
Save a Message as Text    
Send a Calendar via Email
Save a Calendar as a Web Page    
Use a Distribution List

Options and Customization

Managing Views
Sharing Calendars
Managing Outlook
Security and Privacy
Create a Default Signature
Schedule an Appointment
Create a Recurring Appointment     
Schedule a Meeting
Respond to a Meeting Request
Create and Assign a Task    
Respond to a Task Request
Create, Delete, and View Notes   

Course Summary

 

Access 2007

 

Access Basics

Designing a Database
Building a Database
Non-Numerical Data Types
Managing Table Data
Filters and Queries
Using Forms
Producing Reports
Create a Database
Create a New Table
Edit a Relationship
Set Field Data Type
Manage Table Data
Filter a Datasheet
Design a Query
Create a Form
Design a Report

Controlling Data Entry

Finding and Joining Data
Creating Flexible Queries
Enhancing Forms
Customizing Reports
Sharing Access Data
Create a Validation Rule
Join Tables in a Query
Create a Parameter Query
Add Controls to a Form
Create a Grouped Report
Get External Data

Structuring Existing Data

Writing Advanced Queries
Creating and Using Macros
Making Forms More Effective
Improving Reports
Setting Startup Options
Database Maintenance
Distributing and Securing the Database

Summary

Questions?  Contact one of our Career Advisors at 888.840.2378 for assistance or email sales@quickcert.com.

Free Demo