Excel 2007 Microsoft Certified Application Specialist in a Box

Prerequisites:

Course Description:

This certification course provides a complete training solution to fully prepare students to achieve MCAS Accreditation

Included are:

• 2-days Instructor Led Training using MCAS Official Courseware
• MCAS Practice Exam Voucher
• MCAS Exam Voucher + FREE Retake
• MCAS A4 Pad
• MCAS Pen
• MCAS Mouse Mat
• Branded MCAS Carry Case

This course includes the following modules:

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 using a formula.
• Summarize data 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 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