Training from Alpha Technical Solutions

Overview

This five day instructor led course prepares students to achieve the Microsoft Office Excel 2007 MCAS certification.

Examination information

• MCAS Examination 77-602

Prerequisites

Before attending this course, students must have:

• A good working knowledge of Microsoft Office Excel 2007.

Course outline

Module 1: Creating and Manipulating Data

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

Module 2: Formatting Data and Content

• Format Worksheets
• Insert and Modify rows and columns
• Format cells and cell content
• Format data as a table

Module 3: Creating and Modifying Formulas

• Reference data in formulas
• Summarize data using a formula
• Summarise data using subtotals
• Conditionally summarise 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

Module 4: Presenting Data Visually

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

Module 5: Collaborating 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