Advanced Data Management in Excel 2002 Overview/Description Target Audience Prerequisites Expected Duration Lesson Objectives Course Number Overview/Description
To provide an overview of the advanced data management and organization features in Excel 2002
Target Audience
End-users seeking proficiency in the use of Microsoft Excel 2002 at an advanced level; end-users seeking to obtain Microsoft Office User Specialist (MOUS) certification in Microsoft Excel 2002 at Expert level
Prerequisites
The Microsoft Office XP: Beginning Excel 2002 learning path; familiarity with the Windows 95/98 or NT 4.0/2000 user environments
Expected Duration (hours)
4.8
Lesson Objectives Advanced Data Management in Excel 2002
use and customize templates in Excel 2002.
customize and save a workbook as a template in Excel 2002.
use smart tags in Excel 2002.
use styles in Excel 2002.
create and save a style in Excel 2002.
print gridlines, row and column headings, comments, and formula in Excel 2002.
create and edit a template in Excel 2002.
use advanced number formats in Excel 2002.
create, apply, and delete a custom number format in Excel 2002.
apply conditional formatting to a cell in Excel 2002.
create a conditional format and apply it to another cell in Excel 2002.
sort and filter data lists in Excel 2002.
subtotal data in Excel 2002.
sort, filter, and subtotal a data list in Excel 2002.
group and outline a data list in Excel 2002.
use lookup functions in Excel 2002.
use the HLOOKUP function in Excel 2002.
use the advanced mathematical, text, and database functions in Excel 2002.
describe the features and functionality of the data form in Excel 2002.
link worksheets and workbooks in Excel 2002.
link a workbook in Excel 2002.
set up workbooks for sharing by multiple users in Excel 2002.
merge a workbook in Excel 2002.
validate data using formula auditing in Excel 2002.
validate data in an Excel worksheet.
track data using a range of tools in Excel 2002.
turn on the tracking feature and select a method of viewing tracked changes in Excel 2002.
apply worksheet and workbook protection in Excel 2002.
apply protection to a worksheet in Excel 2002.
Course Number: 114461_eng