Overview/Description
To bring proficient users of Excel 2000 to an advanced level of competence
Target Audience
End-users seeking proficiency in the use of Microsoft Excel 2000 at an advanced level; end-users seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2000 at Expert level
Prerequisites
The Microsoft Office 2000: Beginning Excel 2000 learning path; familiarity with the Windows 95/98 or NT 4.0/2000 user environments
create, edit, and delete comments in Excel documents.
create a template based on an existing document, use that template to create a new document, and add and edit a comment.
share a workbook, save a shared workbook, and merge shared copies of a workbook.
print selected sheets in a workbook, change the setup of a worksheet before printing it, and use the Report Manager to print sections of a document.
show, hide, and customize Excel toolbars.
add a button to a toolbar.
protect Excel worksheets and formulas.
apply protection to and remove it from an Excel worksheet.
restrict the changes that users make to a workbook by preventing them from moving or deleting worksheets, preventing them from turning off the change history, and limiting their access through the use of passwords.
set the properties of a shared workbook so that changes are described and tracked.
set different passwords to open and modify a document, and enable tracking of a document.
audit a worksheet by tracing a cell's precedent and dependent cells and by tracing errors.
trace a cell's dependent and precedent cells in an Excel workbook.
format numbers and apply custom and conditional formatting to numbers in Excel.
apply custom and conditional formatting to an Excel worksheet.
work with named ranges in Excel 2000 by naming cells and ranges, naming already-labeled cells and ranges, and using named cells and ranges in a formula.
differentiate between and use the Hlookup and Vlookup functions in Excel.
name a range of cells, access the Vlookup function, and create a formula containing Vlookup.