MS Excel 2007 (MOS - Exam 77-602)

Learning Objectives

To equip trainees with the technical knowledge and skills to master Microsoft Excel 2007. The MOS Exam measures the trainee's ability to accomplish the knowledge and technical skills learnt from this course.

Programme Outline

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

For Who

Working adults who want to master Microsoft Excel 2007 and attain Microsoft Certification.

Training Methodology

Hands-on & Interactive Training

Duration

24 hrs (3 full days / 8 Evenings)

Weekday/Weekend Classes available

Fees Per Trainee

$650.00