 |
|
|
|
|
|
|
|
|
|
|
|
|
 |
|
|||||||||||
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
|
||
 |
 |
 |
|
|||||||||
Students will learn basic worksheet skills and how to work with data in worksheets.
Prerequisites:
Windows Introduction, or equivalent knowledge.
Unit 1 : Excel basics
The paper spreadsheet
The Excel program
The workbook environment
Unit 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
Unit 3 : Modifying a workbook
Working with ranges
Working with functions
Editing cell contents
Unit 4 : Moving and copying data
Inserting rows and ranges
Moving data
Copying data
Absolute references
Using the Fill Series feature
Unit 5 : Formatting a worksheet
Formatting a worksheet
Number formats and text alignment
Copying and pasting formats
Special and custom formatting
Unit 6 : Printing a worksheet
Checking spelling
Using the Print Preview command
Printing a large worksheet
Additional print options
Unit 7 : Introduction to the workbook environment
Using a multiple-sheet workbook
Creating a chart
Outlining
Spreadsheet Solutions
Unit 8 : Creating Excel web pages