After completing Excel 97: Modifying Worksheets, the user should be able to:
| Move and copy data |
| Change the format of numbers and text |
| Create and use named ranges |
| Print all or part of a worksheet |
| Use Excel toolbars |
| Sort data |
|
Moving and Copying Data
Inserting and deleting rows, columns and cells
Moving cell data
Copying cell data
Entering absolute cell references
Formatting a Worksheet
Changing number formatting
Changing text formatting
Changing column width and row height
Working with Named Ranges
Naming a range of cells
Using names in formulas
Selecting named ranges
Printing a Worksheet
Checking the spelling of a worksheet
Using page setup options
Printing a whole worksheet
Printing a portion of a worksheet
Using Toolbars
Displaying additional toolbars
Tearing off a toolbar option palette
Creating a custom toolbar
Sorting Data
Sorting a list by the values in a column
Sorting by ascending and descending order
|
This course is distributed with
| Exercises, with supplied files, that allow users to practice in Excel 97 |
| A file containing the text of the exercises |
| Simulations that allow users to practice course skills, even if they don't have access to the Excel 97 product |
| A Excel 97 Glossary |
|