Advanced Validation and Collaboration in Excel 2003


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number


Overview/Description
To identify the advanced data validation and collaboration features in Excel 2003

Target Audience
End users seeking proficiency in the use of Microsoft Excel 2003 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2003 at Expert level or an equivalent

Prerequisites
Familiarity with the Windows 2000 or XP user environments

Expected Duration (hours)
3.3

Lesson Objectives

Advanced Validation and Collaboration in Excel 2003

  • validate data in Excel 2003.
  • audit data in Excel 2003.
  • validate data in an Excel worksheet.
  • apply worksheet protection in Excel 2003.
  • use passwords, encryption, and digital signatures to protect Excel 2003 workbooks.
  • apply protection to a range, a worksheet, and a workbook in Excel 2003.
  • share and merge workbooks in Excel 2003.
  • track changes to data using a range of tools in Excel 2003.
  • use Excel 2003 collaboration features to track changes and merge a workbook.
  • apply data validation, protect, and share a workbook in Excel 2003.

    • Course Number:
    121344_eng