|
Level One:
|
|
|
 |
What is Microsoft Excel 2000 |
|
 |
Navigation |
|
 |
Creating a workbook |
|
 |
Using spreadsheets and on-line help |
|
 |
Formatting values and ranges |
|
 |
Opening and modifying a workbook |
|
 |
Deleting cell contents and worksheets |
|
 |
Revising text and numbers |
|
 |
Sorting data |
|
 |
Printing workbooks |
|
 |
Printing screens and ranges |
|
 |
Using drawing tools, functions & charts |
|
 |
Inserting and deleting rows/columns |
|
 |
Using and creating templates |
|
|
Level Two:
|
|
|
 |
Auto and custom formatting |
|
 |
Creating and working with formulas |
|
 |
Formula order of operations |
|
 |
Copying formulas using relative and absolute reference |
|
 |
Using IF and nested IF functions |
|
 |
Working with dates |
|
 |
Importing data from other sources |
|
 |
Importing lists |
|
|
Level Three:
|
|
|
 |
Advanced charts |
|
 |
Hyperlinks and macros |
|
 |
Using filters and sorts |
|
 |
Data analysis |
|
 |
Conditional formatting and styles |
|
 |
Sharing workbooks and workgroups |
|
 |
Functions of sharing |
|
 |
Pivot tables |