Excel 5: Introduction
Course description
Overview: Students will learn basic worksheets skills and how to work with data
in worksheets.
Prerequisites: Students enrolling in this course should understand how to use
Windows 95.
Benefits: Students will learn how to use an electronic spreadsheet to create
basic data reports.
Performance-based objectives
Upon successful completion of this course, students will be able to:
- Create a basic worksheet by entering text, values, and formulas.
- Create formulas by using Excels built-in functions.
- Move and copy data by using shortcut menus, drag-and-drop editing, and toolbar buttons.
- Change the appearance of worksheet data by using a variety of formatting techniques.
- Prepare a document for printing by using the spell checking feature and a variety of
printing options.
- Use the three-dimensional aspect of the Excel workbook environment by creating formulas
that refer to cells on multiple worksheets.
Course content
- The workbook environment
- Entering and correcting data
- Saving a file
- Using formulas
- Navigation and movement techniques
- Working with ranges and functions
- Editing cell contents
- Inserting rows and ranges, moving and copying data
- Absolute references
- Using the Fill Series feature
- Formatting and text alignment
- Copying and pasting formats
- Checking spelling
- Printing
- Using a multiple-sheet workbook