|
WORKING WITH CELLS
|
 top
|
Shows how to enter and edit data in Excel 2002 worksheet cells and how to create hyperlinks.
TOPICS
COVERED
Entering Data
Editing a Cell
Editing Multiple Cells
Replacing Values and AutoFilling
Creating Hyperlinks
|
WORKING WITH FILES
|
top
|
Shows how to locate, open, and save files in Excel
2002.
TOPICS
COVERED
Opening Files
Saving Files
Files and the Internet
Using the Office Assistant
|
FORMATTING WORKSHEETS |
top
|
Shows how to format and adjust cells, adjust rows and columns, and apply formatting and styles in an Excel
2002 worksheet.
TOPICS
COVERED
Formatting Cells
Adjusting Cells
Adjusting Rows and Columns
Formatting Numbers
Using AutoFormatting and Styles
|
PAGE SETUP AND PRINTING |
top
|
Shows how to preview and print worksheets and workbooks; add headers, footers, and titles, and adjust page settings in Excel
2002 worksheets.
TOPICS
COVERED
Previewing
Page Setup
Headers, Footers, and Titles
Printing
|
WORKSHEETS AND WORKBOOKS |
top
|
Shows how to work with worksheet rows and columns, manage worksheets, and consolidate data in Excel
2002 worksheets.
TOPICS
COVERED
Working with Rows and Columns
Working with Worksheets
Linking Worksheets and Consolidating Data
Zooming and Spell-Checking
|
FORMULAS AND FUNCTIONS |
top
|
Shows how to work with formulas and functions in Excel
2002 worksheets.
TOPICS
COVERED
Working with Formulas
Using References and AutoSum
Entering Functions
Using Basic and Date Functions
Using Financial and Logical Functions
|
CHARTS AND OBJECTS |
top
|
Shows how to create, modify, and print charts; insert, move and delete pictures, and draw lines and shapes in Excel
2002 worksheets.
TOPICS
COVERED
Creating Charts
Modifying and Printing Charts
Working with Objects
Drawing Lines and Shapes
only £99.00
(approx $150 USD)
|
