All the Skills measured by Exam 77-602 :

1. Creating and Manipulating Data
• Insert data by using AutoFill.
• Ensure data integrity.
• Modify cell contents and formats.
• Change worksheet views.
• Manage worksheets.
2. Formatting Data and Content
• Format worksheets.
• Insert and modify rows and columns. 
• Format cells and cell content. 
• Format data as a table.
3. Creating and Modifying Formulas
• Reference data in formulas.
• Summarize data by using a formula.
• Summarize data by using subtotals.
• Conditionally summarize data by using a formula.
• Look up data by using a formula.
• Use conditional logic in a formula.
• Format or modify text by using formulas.
• Display and print formulas.
   
4. Presenting Data Visually
• Create and format charts.
• Modify charts.
• Apply conditional formatting.
• Insert and modify illustrations.
• Outline data. 
• Sort and filter data.
  
5. Collaborating on and Securing Data
• Manage changes to workbooks.
• Protect and share workbooks.
• Prepare workbooks for distribution.
• Save workbooks.
• Set print options for printing data, worksheets, and workbooks.

Become a Microsoft Certified Application Specialist in Excel 2007 in 5 days or 10 evenings

Courses starting on: June 23rd 2008, July 7 2008, July 21 2008
Course Fees: 500/-
Maximum Class Size: 10 students
Free Exam Voucher Provided

You will be provided lots of time to practice on Self Test Software, before you are confident to attempt the Microsoft exam.