The Microsoft Certified Application Specialist Certification, (MCAS) recognizes business professionals who have demonstrated expertise in Microsoft Office 2007. QuickCert's Excel 2007 course provides students with the knowledge and skills that are needed to use the advanced software features, and integrate the Office programs with other software. When you pass the Excel 2007 Exam 77-602, you achieve Microsoft Certified Application Specialist (MCAS) status in Excel 2007.

As a Microsoft Certified Partner, QuickCert follows the approved Microsoft course curriculum, ensuring you receive the training and knowledge needed to succeed. QuickCert is so certain this course meets and exceeds the exam objectives, we guarantee you will pass your exam!

Learning segments

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

For More Information E-Mail us at sales@quickcert.com
or call us at 1.888.840.2378

GET IN THE LEAD —
get certified today!

Experience the benefits of classroom learning - anytime, anywhere! QuickCert's expert instruction and multi-media courseware is guaranteed to get you certified- or your money back!