The Microsoft Certified Application Specialist Certification, (MCAS) recognizes business professionals who have demonstrated expertise in Microsoft Office 2007. UCertifyOnline'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 IT Academy Program Member, UCertifyOnline follows the approved Microsoft course curriculum, ensuring you receive the training and knowledge needed to succeed.  UCertifyOnline is so certain this course meets and exceeds the exam objectives, we guarantee you will pass your exam!

 Course Duration: 3 Months

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@UCertifyOnline.com