| |
|
| |
Advanced Data Management in Excel 2002 Training Class |
|
| |
|
|
| |
|
|
| |
Advanced Data Management in Excel 2002 Training Seminar
To provide an overview of the advanced data management and organization features in Excel 2002
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Price |
|
| |
$74.95
|
|
| |
|
|
| |
Agenda |
|
| |
Using templates in Excel 2002
- use and customize templates in Excel 2002.
Creating a template in Excel 2002
- customize and save a workbook as a template in Excel 2002.
Working with smart tags in Excel 2002
- use smart tags in Excel 2002.
Using styles in Excel 2002
- use styles in Excel 2002.
Creating a style in Excel 2002
- create and save a style in Excel 2002.
Advanced printing in Excel 2002
- print gridlines, row and column headings, comments, and formula in Excel 2002.
Working with templates in Excel 2002
- create and edit a template in Excel 2002.
Custom number formats in Excel 2002
- use advanced number formats in Excel 2002.
Using advanced number formats in Excel 2002
- create, apply, and delete a custom number format in Excel 2002.
Conditional formatting in Excel 2002
- apply conditional formatting to a cell in Excel 2002.
Creating and copying conditional formats in Excel 2002
- create a conditional format and apply it to another cell in Excel 2002.
Sorting and filtering data in Excel 2002
- sort and filter data lists in Excel 2002.
Data subtotaling in Excel 2002
- subtotal data in Excel 2002.
Sorting, filtering, and subtotaling data in Excel 2002
- sort, filter, and subtotal a data list in Excel 2002.
Grouping and outlining data in Excel 2002
- group and outline a data list in Excel 2002.
The Excel 2002 LOOKUP function
- use lookup functions in Excel 2002.
Using the HLOOKUP function in Excel 2002
- use the HLOOKUP function in Excel 2002.
Advanced functions in Excel 2002
- use the advanced mathematical, text, and database functions in Excel 2002.
Using the data form in Excel 2002
- describe the features and functionality of the data form in Excel 2002.
Creating links in Excel 2002
- link worksheets and workbooks in Excel 2002.
Linking a workbook in Excel 2002
- link a workbook in Excel 2002.
Shared workbooks in Excel 2002
- set up workbooks for sharing by multiple users in Excel 2002.
Merging a workbook in Excel 2002
- merge a workbook in Excel 2002.
Validating data in Excel 2002
- validate data using formula auditing in Excel 2002.
Using data validation in Excel 2002
- validate data in an Excel worksheet.
Auditing tools in Excel 2002
- track data using a range of tools in Excel 2002.
Tracking changes in Excel 2002
- turn on the tracking feature and select a method of viewing tracked changes in Excel 2002.
Data protection in Excel 2002
- apply worksheet and workbook protection in Excel 2002.
Protecting a worksheet in Excel 2002
- apply protection to a worksheet in Excel 2002.
|
|
|
|
| |
|
|
| |
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
|
|
|
| |
|
|
| |
Pre-Requisites |
|
| |
The Microsoft Office XP: Beginning Excel 2002 learning path; familiarity with the Windows 95/98 or NT 4.0/2000 user environments
|
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
| |
Select a market segment to view more courses
|
|
| |
|
|
| |
Or, select a category to view more Information Technology courses
|
|
| |
|
|
| |
 Browse By Category
Browse By Location
Browse New Courses
|
|
| |
|
|
|
| |
| |
|
|
|
|