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