Working with
Cells Module:
This
module
shows users
how to enter
and edit
data in
Excel 2002
worksheet
cells and
create
hyperlinks..
-
Enter
cell
data
including
text,
numbers,
and
formulas
-
Edit
cell
data
-
Insert,
delete,
and
move
cells
-
Find
and
replace
cell
data
and
formats
-
Create
hyperlinks
Working with
Files Module:
This
module shows
users
how to
locate,
open,
and save
files in
Excel
2002..
-
Manage workbook files and folders
-
Create workbooks using templates
-
Save workbooks using different names and file formats
-
Convert worksheets to Web pages
-
View and edit comments
Formatting
Worksheets
Module:
This
module shows users
how to
format and
adjust
cells,
adjust rows
and columns,
and apply
formatting
and styles
in an Excel
2002
worksheet..
-
Apply
and
modify
cell
formats
-
Modify
row
and
column
settings
-
Use
automated
tools
to
format
worksheets
-
Apply
styles
Page Setup &
Printing
Module:
This module
shows users
how to
preview and
print
worksheets
and
workbooks,
add headers,
footers, and
titles, and
adjust page
settings in
Excel 2002
worksheets..
Worksheets &
Workbooks
Module:
This
module shows
users
how to
work
with
worksheet
rows and
columns,
move
between
worksheets
in a
workbook,
consolidate
data,
change
the zoom
setting,
and
check
spelling
in Excel
2002
worksheets..
-
Modify row and column formats
-
Modify worksheet names and positions
-
Insert and delete worksheets
-
Use 3-D references
-
Check spelling
-
Work with a subset of data by filtering lists
Formulas and
Functions
Module:
This module
shows users
how to work
with
formulas and
functions in
Excel 2002
worksheets..
-
Work
with
formulas
-
Use
references
and
AutoSum
-
Enter
Functions
-
Use
basic
and
date
functions
-
Use
financial
and
logical
functions
Charts and
Objects
Module:
This module
shows users
how to
create,
modify, and
print
charts,
insert, move
and delete
pictures,
and draw
lines and
shapes in
Excel 2002
worksheets..
-
Create,
modify,
position,
and
print
charts
-
Create,
modify,
and
position
objects