Learn More:

Exam 77-602:
Excel 2007

Authorized Testing Center

Keep It Simple is a Microsoft Authorized Testing Center.

To schedule an exam, call
866-PC-SKILLS or email us at info@keepitsimple.net.

Discounted Training Packages:

Creating and Manipulating Data

Insert data by using AutoFill.
Ensure data integrity.
Modify cell contents and formats.
Change worksheet views.
Manage worksheets.

Formatting Data and Content

Format worksheets.
Insert and modify rows and columns.
Format cells and cell content.
Format data as a table.

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.

Presenting Data Visually

Create and format charts.
Modify charts.
Apply conditional formatting.
Insert and modify illustrations.
Outline data.
Sort and filter data.

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.