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