MSE-101: Microsoft Excel Level 1

Overview:
This one-day course provides students with an introduction to basic worksheets skills and how to work with data in worksheets.

Prerequisites:
Prior to attending this class, students should have the following experience:

• Understanding of the basic concepts involved in working with a personal computer (PC)
• Familiarity with the Windows interface

Objectives:
Upon successful completion of this course, students should be able to:

• Identify 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 Excel's 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.
• Save an Excel workbook as a Web page.

Modules:

1. Excel Basics
2. Entering Data and Navigating in a Worksheet
3. Modifying a Workbook
4. Moving and Copying Data
5. Formatting a Worksheet
6. Printing a Worksheet
7. Introduction to the Workbook Environment
8. Creating Excel Web pages