On-line training course catalogue

Excel 2007 – Microsoft Certified Application Specialist in a Box

Type of course: Classroom

Course details

Fee	£395
Days	2
Course code	MSEXMCAS

Course dates

Location	Aug	Sep	Oct	Nov	Dec	Jan
London King William Street	|-	|-	|-	|6	|-	|-

Booking: click a course date | View location: click location name | Print this page | Download as Word document |

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

Prerequisities

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

 

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.