Excel 7.0: Introduction (Windows 95)
Course description
Overview:
Students will learn
the benefits of working with Excel 7.0.
Prerequisites:
Students
enrolling in this course should understand how to use a mouse and should be familiar with
Windows 95.
Benefits:
Students will learn
how to create and format Excel worksheets.
Objectives
Upon successful completion of this course, students will be able to:
- Understand the disadvantages of paper spreadsheets and the advantages of electronic
spreadsheets by exploring both.
- 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 Check feature and a variety of
printing options.
- Use the three-dimensional aspect of the Excel workbook environment by creating formulas
that reference cells on multiple worksheets.
Course content
- The paper spreadsheet
- The Excel program
- The workbook environment and Excel functionality
- Entering and correcting data
- Saving a file
- Using formulas
- Navigation and movement techniques
- Working with ranges
- Working with functions
- Editing cell contents
- Using Excel Help
- Inserting rows and ranges
- Moving and copying data
- Absolute references
- Formatting a worksheet
- Number formats and text alignment
- Copying and pasting formats
- Checking spelling
- Using Print Preview
- Printing a large worksheet
- Additional print options
- Using a multi-sheet workbook
- Creating a chart
- Spreadsheet Solutions