Microsoft excel 2002 : illustrated introductory / Elizabeth Eisner Reding &Lynn Wermers

CONTENT

Getting started with excel 2002

Defining spreadsheet software
Starting excel 2002
Viewing the excel window
Opening and saving a workbook
etc.


Building and editing worksheets

Planning and designing a worksheet
Editing cell entries
Entering formulas
Creating complex formulas
etc.


Formatting a worksheet

Formatting values
Using fonts and font sizes
Changing attributes and alignment
Adjusting column widths
etc.


Working with charts

Planning and designing a chart
Creating a chart
Moving and resizing a chart
Editing a chart
Formatting a chart
etc.


Working with formulas and functions

Using names in a formula
Generating multiple totals with autosum
Using dates in calculations
Building a conditional formula with the IF function
etc.


Managing workbooks and preparing them for the web

Freezing columns and rows
Inserting and deleting worksheets
Consolidating data with 3-D references
Hiding and protecting worksheet areas
etc.


Automating worksheet tasks

Planning a macro
Recording a macro
Running a macro
Editing a macro
etc.


Using lists

Planning a list
Creating a list
Adding records with the data form
Finding records
Deleting records
etc.

Includes glossary and index