This
is an excellent, feature rich, 56-page Excel Tutorial,
titled Your
Guide To Microsoft Excel XP, hosted by the San
Antonio Independent School District. Many Excel features are presented
and taught this Excel tutorial including the following: Menu
Bar, Toolbar area, entering and formatting data, working with columns
and rows, formatting cells, navigating and managing worksheets, using
formulas, and creating charts and graphs. You can take a quiz
at the end to test your Excel knowledge. This Excel tutorial is located
on this site's
MS
Office XP Tutorials page.
Excel
XP Tutorial and Guide
(56
pages, 1.8mb, pdf format)
What is Excel XP
What Should you consider before beginning?
Beginning Basics
Opening Excel XP
Parts of the Excel window
How to get help in Excel SP
Help options
found on the Menu Bar/Toolbar Area
Screen Tips
The Office Assistant
Ask a Question Wizard
The What’s This arrow
Working with Worksheets
Entering data into a worksheet
Formatting
problems with data entry
Changing the
appearance of Columns and Rows
Resizing column widths
Resizing row widths
Inserting and
Deleting Columns and Rows
Inserting new Columns
Inserting new Rows
Deleting Columns
Deleting Rows
Changing the appearance of
Cells
Selecting Cells
Adding color to cells
Adding borders to cells
Navigating a
worksheet and/or workbook
Scrolling up and down
Scrolling left and right
Switching between worksheets
Inserting,
deleting, naming, and moving a worksheet
Inserting a worksheet
Deleting a worksheet
Naming a worksheet
Moving a worksheet
Using Formulas
Simple Formulas
Errors found in formulas
Relative cell references
Using fill option
Absolute cell references
Functions
Types of functions
Example of AVERAGE function
Using the AutoSum icon
Linking Formulas
Creating
Charts or Graphs
Using the Chart Wizard
Copying
a worksheet into MS Word
A simple copy
and paste
Inserting a worksheet
Helpful
Information
Test for Knowledge
Create the following in MS Excel XP
Mini
MS Excel XP Quiz
Evaluation Form
Geometric Reflection and Evaluation
Resources, Links &
Citations