Prerequisites:
Windows Level 1, or equivalent knowledge
In
Excel 2002, Level 1, students learn how to create, modify, print,
and format worksheets, work with basic formulas and functions,
use multiple worksheets, enhance worksheets, use template, styles
and AutoFormats, and find and replace data.
Register
Online
Getting
Started with Excel 2000
Exploring Spreadsheet Uses
Defining Workbooks/Worksheets
Starting Excel
Moving Around Worksheets
Selecting Ranges
Exploring Toolbars and Menus
Exiting Excel
Creating Worksheets
Opening New Workbooks
Entering Data
Using the AutoComplete Feature
Editing Data
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 Cells
Inserting and Deleting Rows and Columns
Changing Column Widths/Row Heights
Applying Numeric Formats
Changing the Alignment of Data
Printing Workbooks
Checking Spelling
Previewing Print Jobs
Using Page Break Preview
Printing Worksheets
Formulas and Functions
Creating Formulas
Editing Formulas
Using Cell References
Working with Basic Functions
Using AutoSum
Using AVERAGE
Using MAX
Using MIN
Using the Function Wizard
Using AutoCalculate
Enhancing Worksheets
Changing Text and Font Attributes
Merging and Splitting Cells
Rotating Text in Cells
Indenting Text in Cells
Adding and Modifying Borders
Shading Ranges
Working with Pictures
Using Templates, Styles, and AutoFormats
Creating Workbooks Using Templates
Creating Styles
Formatting Cells Using Styles
Modifying and Deleting Styles
Using AutoFormats
Finding and Replacing Data
Finding and Opening Existing Workbooks
Finding and Replacing Text
Finding and Replacing Numeric Data
Finding and Replacing Cell Formats
