|
The Complete
Guide to Excel
2007
Exam 77-602: Using Microsoft® Office Excel 2007
Online instructor and email support
This course also includes books, lesson plans, sample tests, and
assessments.
Objectives: The Beginning Guide to Microsoft Excel
2007 demonstrates: Format font styles (size, color, and
styles), Apply number formats (currency, percent), Use
references (relative), Use Functions, Use AutoFill, Modify
Charts
The Intermediate Guide to Microsoft Excel 2007
teaches: Use Conditional Formatting, Create form controls,
Copy or Move worksheets, Link worksheets, Work with Scenarios,
Use Goal Seek, Use Absolute and Relative References.
The Advanced Guide to Microsoft Excel 2007
demonstrates: Create a PivotTable, Use PivotTable auto format,
Filter the Data, Create Subtotals, Group and Outline Data, and
Use the VLookup Function.
Demonstrates these Microsoft Office Specialist (MOS) objectives
for Excel 2007 |
