Prerequisites:
Windows Level 1, or equivalent knowledge
In
Excel 2000/97, Level 1, students get started with Excel, create,
modify, print, and format worksheets, work with basic formulas
and functions, use multiple worksheets, enhance worksheets, use
styles and AutoFormats, and work with charts.
Register
Online
Getting
Started with Excel 2000
Exploring Spreadsheet Uses
Defining Workbooks/Worksheets
Starting Excel
Using the Office Assistant
Creating Worksheets
Creating New Workbooks
Using the AutoComplete Feature
Saving and Closing New Workbooks
Modifying Worksheets
Opening Existing Workbooks
Copying Worksheet Data
Moving Worksheet Data
Cutting and Pasting Data
Deleting Data and Reversing Actions
Saving Existing Workbooks
Formatting Worksheets
Inserting and Deleting Rows and Columns
Changing Column Widths/Row Heights
Using Numeric Formats
Changing the Alignment of Data
Using Conditional Formatting
Printing Worksheets
Previewing Print Jobs
Using Page Break Preview
Defining Page Setup Options
Creating Headers and Footers
Printing Worksheets
Formulas and Functions
Using Formulas
Creating Formulas
Editing Formulas
Using Relative Cell References
Using Absolute Cell References
Using Mixed Cell References
Using Functions
Using AutoSum
Using AutoCalculate
Using Multiple Worksheets
Working with Multiple Worksheets
Moving Between Worksheets
Inserting and Deleting Worksheets
Moving and Copying Data Between Worksheets
Grouping Worksheets
Creating 3-Dimensional Formulas
Renaming Worksheets
Enhancing Worksheets
Enhancing Text
Changing Text and Font Attributes
Adding and Modifying Borders
Creating and Modifying 3-Dimensional Objects
Using Styles and AutoFormats
Using Styles
Creating Styles
Formatting Cells with Styles
Modifying and Deleting Styles
Using AutoFormats
Working with Charts
Creating Charts
Formatting Charts
Modifying Charts
Resizing and Moving Charts
Editing Chart Data
Placing and Modifying Data Tables in Charts
Printing Charts