The Intermediate Guide to Microsoft Excel 2007

Exam 77-602: Using Microsoft® Office Excel 2007

Description: The Intermediate Guide to Excel 2007 teaches how to use advanced text alignment, Conditional Formatting, create form controls, rename a worksheet, copy or move worksheets, link worksheets and consolidate data, use Relative and Absolute References, work with Scenarios, use Goal Seek, use the Auditing Toolbar.

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 Intermediate Guide to Microsoft® Excel 2007 course should have basic computer skills including how to turn on the computer, how to use an Internet browser and how to select commands from a menu or toolbar. Students should also be proficient in file management: how to save, print and backup files.