|
Excel
2000: Introduction
Prerequisites: Windows 95
or equivalent knowledge.
Lesson 1: Excel basics
The Excel program
The workbook environment
Lesson 2: Entering data and
navigating in a worksheet
- Entering and correcting data
Saving a file
Using formulas
Opening a second file
Navigation and movement
techniques
Lesson 3: Modifying a workbook
Working with functions
Editing cell contents
Lesson 4: Moving and copying
data
- Inserting rows and ranges
Moving data
Copying data
Absolute references
Using the Fill Series feature
Lesson 5: Formatting a worksheet
Number formats and text
alignment
Copying and pasting formats
Special and custom formatting
Lesson 6: Printing a worksheet
Using the Print Preview command
Printing a large worksheet
Additional print options
Lesson 7: Introduction to the
workbook environment
- Using a multiple-sheet workbook
Creating a chart
Outlining
Spreadsheet Solutions
Lesson 8: Creating Excel Web
pages
- Using Excel as a Web tool
|
