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 >

 

QuickCert's MCAS Excel 2007 training 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.

The Microsoft Certified Application Specialist Certification, (MCAS) recognizes business professionals who have demonstrated expertise in Microsoft Office 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!

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

Your QuickCert MCAS Microsoft Certified Application Specialist Exam TRaining Course: Excel 2007 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 Microsoft Certified Application Specialist Exam TRaining Course: Excel 2007 Curriculum:

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

 

 

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

Free Demo