Excel 2007 - Microsoft Certified Application Specialist In A Box

Scheduled Dates Locations filtered. Show all UK course locations.

Course Overview

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

Examinations

During the course, you will have the opportunity to test your knowledge and complete a full practice exam before taking the final exam at the end of day 2.

Prerequisites

Delegates should have a good working knowledge of Microsoft Office Excel 2007 before taking this certification course.

Course Outline

During the 2 day course you will cover the following topics to prepare you for exam 70-602: Using Microsoft Office Excel 2007 :

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

Excel 2007 - Microsoft Certified Application Specialist In A Box / MSEXMCAS