The Advanced Guide to Microsoft Excel 2007
Exam 77-602: Using Microsoft® Office Excel 2007

Description: The Advanced Guide to Excel 2007 demonstrates how to name and manage ranges, copy or move worksheets, link worksheets and consolidate data, work with Scenarios, use Goal Seek, use the Auditing Toolbar to trace errors, analyze data with a PivotTable, filter the data, create Subtotals, Group and Outline data, and use the Logical, Lookup, Math and Text Functions.

Who will benefit from this course? Students who want to learn how to enter data into a spreadsheet and calculate the results will benefit from this course. Students who learn visually will appreciate the many illustrations and the step by step instructions. Successful students master how to create and edit formulas, audit equations, and format data.

Audience Description: Who should take this course?

The certification training is available to adult learners online in partnership with major colleges and universities. The audience for this course includes:

•  Office workers, managers, entrepreneurs, teachers, and military personnel who want to start using advanced skills immediately

•  Job training and professional development (WIA), as well as retired and unemployed people looking to expand their job possibilities

Course Prerequisites: Students who enroll in The Advanced Guide to Microsoft® Excel 2007 course should have basic computer skills. Students should also be proficient in file management: how to save, print and backup files.