The Microsoft Certified Application Specialist Certification, (MCAS) recognizes business professionals who have demonstrated expertise in Microsoft Office 2007. Our 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, our course follows the approved Microsoft course curriculum, ensuring you receive the training and knowledge needed to succeed.  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

 

Exam 77-602 - Excel 2007 Course Summary

To pay please click here